<body><script type="text/javascript"> function setAttributeOnload(object, attribute, val) { if(window.addEventListener) { window.addEventListener('load', function(){ object[attribute] = val; }, false); } else { window.attachEvent('onload', function(){ object[attribute] = val; }); } } </script> <div id="navbar-iframe-container"></div> <script type="text/javascript" src="https://apis.google.com/js/plusone.js"></script> <script type="text/javascript"> gapi.load("gapi.iframes:gapi.iframes.style.bubble", function() { if (gapi.iframes && gapi.iframes.getContext) { gapi.iframes.getContext().openChild({ url: 'https://www.blogger.com/navbar.g?targetBlogID\x3d11356004\x26blogName\x3dxception\x26publishMode\x3dPUBLISH_MODE_BLOGSPOT\x26navbarType\x3dBLUE\x26layoutType\x3dCLASSIC\x26searchRoot\x3dhttp://openrent.blogspot.com/search\x26blogLocale\x3den_US\x26v\x3d2\x26homepageUrl\x3dhttp://openrent.blogspot.com/\x26vt\x3d-2179510228592399674', where: document.getElementById("navbar-iframe-container"), id: "navbar-iframe" }); } }); </script>

Turn off default tracing in SQL Server

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

FROM fn_trace_getinfo(default);

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)


Shutdown a Windows server remotely.

shutdown -r -t 0 -f -m