For a description of the error severity level of SQL Server, take a strong look at the following two linksOffline HelpMs-help://ms. Sqlcc.v9/ms. Sqlsvr.v9.zh-chs/sqlerrm9/html/3e7f5925-6edd-42e1-bf17-f7deb03993a7.htmOnline
The transaction log for database 'xx' is full, Error: 9002, Severity: 17, State: severity
Check database logs with the following error message:
Error: 9002, Severity: 17, State: 4.The transaction log for database 'SharedServices1_Search_DB' is full.
SQL Server raiseerror usage
RaiserrorReturn the User-Defined error message and set the system flag to record the error. By using the raiserror statement, the client can retrieve entries from the sysmessages table, or dynamically generate a message
SQL server cannot be started. MSSQL 18052 error: 9003, severity: 20, status: 1., 180529003
Symptom:System log files (Control Panel-management tools-system logs)You can find the following two errors:17052:The master database cannot be recovered.
How to solve the connection problem in SQL Server 2000
Applicable
Important: This article contains information about modifying the registry. Before modifying the registry, you must back up the registry and know how to restore the Registry in case of
Company an old SQL SERVER 2000 database, a few times a week will occur (one or more) CPU duration 100%, causing the application does not respond to the situation, as shown in:The error message is as follows:View CodeThe database version, patch
server| Resolution | How the problem resolves connection problems in SQL Server 2000 apply to important notes: This article contains information about modifying the registry. Be sure to back up the registry before you modify the registry, and be
Problem phenomenon:System log files (Control Panel – Admin tools – System log)You can find the following two errors:17052:Unable to recover master database. is exiting.18052:Error: 9003, severity: 20, Status: 1.
Workaround One:
Rename the
To install SCCM2012, we upgraded the test database to SQLServer2008SP3CU4 today, but changed it to a port and found that Servcie could not be started. The following Error message is displayed in SQLServererrorlog: Error: 17172, Severity: 16, State: 1
The company uses an old SQL Server 100% database, and the CPU usage lasts for several times (once or multiple times) for in a week, causing no response from the application, as shown in: the error message is as follows: date 20137122: 14: 03 log
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.