Andy, I guess I'm now confused. I know there are two service accounts, one for MSSQLSERVER, and one for SQLSERVERAGENT. Now I always thought if you run JOBs that execute xp_cmdshell that the xp_cmdshell commands are run under the MSSQLACCOUNT account, and when you execute an xp_cmdshell command via QA (which is what Szymana is asking) the MSSQLSERVER account is used. So basically the MSSQLSERVER account is always used. My testing seems to confirm this, although it was not an exhaustive test. Now I suppose if the MSSQLSERVICE and SQLSERVERAGENT accounts are the same account then your answer would not confuse me. How confused am I?

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples