It is never a good idea to allow a user to call xp_cmdshell. Instead look at the following.

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/c571d5ed-8f31-4194-a875-b0b58d045e3a

and here

http://blogs.msdn.com/sqlserverfaq/archive/2009/07/24/how-to-impersonate-the-privileges-to-create-a-login-using-the-stored-procedures-using-execute-as-clause.aspx

Take a look here.

http://www.mssqltips.com/tip.asp?tip=1579

Does anyone know how to tell how many licences have being used. Say I have 155 cals. How do I know I am reaching that number. Where does SQL Server...