Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 create stored proc in master database

Author  Topic 

bbasir
Yak Posting Veteran

76 Posts

Posted - 2008-03-26 : 20:35:10
Is it possible to create an SP in the master database, so that I could use the xp_cmd_shell extended sp, so that I donot have to create an proxy account on sql server?

Can that work?
In my SP I will use openrowset and xp_cmdshell commands

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-26 : 21:46:50
Will not work even you create sp in master db.
Go to Top of Page
   

- Advertisement -