clinno's blog

N/A

Peltier Technical Services, Inc.
http://peltiertech.com/Excel/Charts/index.html

●Speedometer Chart
http://peltiertech.com/Excel/Charts/SpeedometerXP.html

(1)use sp_dropextendedproc 'xp_sendmail' to drop xp_sendmail

(2)copy a new sqlmap70.dll from SQL Setup Disk replace where it was in your
SQL installation DISK

(3)use sp_addextendedproc 'xp_sendmail', 'C:\Program Files\Microsoft SQL
Server\MSSQL\Binn\sqlmap70.dll' (assuming our new sqlmap70.dll was there)

Under certain circumstances, you may need to start an instance of Microsoft® SQL Server™ in single-user mode using the startup option -m. For example, you may want to change server configuration options or recover a damaged master database or other system database. Both actions require starting an instance of SQL Server in single-user mode.

When you start an instance of SQL Server in single-user mode:

Only one user can connect to the server.

The CHECKPOINT process is not executed. By default, it is executed automatically at startup.

The sp_configure system stored procedure allow updates option is enabled. By default, the allow updates option is disabled.

To start SQL Server in single-user mode
To start the default instance of SQL Server in single-user mode from a command prompt

From a command prompt, enter:
●sqlservr.exe -c -m

Note You must switch to the appropriate directory (for the instance of Microsoft® SQL Server™ you want to start) in the command window before starting sqlservr.exe.

-->This article is derived from SQL Server Books Online.