Turn off default tracing in SQL Server

SQL Server 2005 runs a default trace. Run this query to determine if tracing is enabled:

SELECT *
FROM fn_trace_getinfo(default);
GO

This yields the result set below, where property 5 ("Current Trace status") is set to a value of 1 (where "1" means on and "0" means off).



To turn off default tracing, run this query:

sp_configure 'default trace enabled', 0

To reenable it, run this query:
sp_configure 'default trace enabled', 1

Enable Fusion log to troubleshoot assembly binding.

HKLM/Software/Microsoft/Fusion/EnableLog DWORD 1

Determine fragmentation level of SQL Server databases

select * from sys.dm_db_index_physical_stats (null,null,null,null,null)

Delete the SharePoint SSP

Delete any web applications related to the SSP first, then issue this command line:
stsadm -o deletessp -title SharedServices1 -deletedatabases

Find SQL database ID (dbid)

sp_helpdb

Shutdown a Windows server remotely.

shutdown -r -t 0 -f -m