>>>>>I think that xp_cmdshell is contained in the Master database, but if I don't see that database in my SQL Server Management Studio, what do I need to do?
>>>>
>>>>Look under Databases/system databases
>>>
>>>Ok, I found this tree:
>>>
>>>
>>>NTSERVER
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>Where do I find the xp_cmdshell? There are other branches, like Views, Synonums, etc. but I didn't see that in them.
>>
>>Under Master, look at Programmability/Extended stored Procedures/system Extended Stored Procedures
>
>It has a sys prefix. It is dbo in the script I inherited. Does that matter?
Normally you would refer to master.dbo.xp_cmdshell(). If you are already USING master, then dbo.cmdshell() will work.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________