How It Works: The SQLAgent Log File

I am still working to resolve the customers problem but during my investigation I briefly looked a the SQLAgent logging format and thought you all might like some of these details. From: Robert Dorr Sent: Monday, May 24, 2010 9:47 AMSubject: RE: SPID in SLEEP state indefinitely   The error itself is from SQLAgent while…

4

Troubleshooting xp_cmdshell failures

This post assumes you have properly enabled the xp_cmdshell feature using the Surface Area Configuration tool and you have used Management Studio | Server Properties | Security to establish a proxy for xp_cmdshell execution. Sample command:   master..xp_cmdshell ‘whoami’ SQL Authentication: TestLogin   (Public in pubs) When xp_cmdshell is executed it returns initialization errors with error message…

3