Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Master Database
Message
From
12/06/2008 13:12:58
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01323280
Message ID:
01323538
Views:
10
>>>>>>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
>>>>----- Databases
>>>>---------- System Databases
>>>>--------------- master
>>>>-------------------- Tables
>>>>------------------------- System Tables
>>>>
>>>>
>>>>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.

I guess my question was more about the "sys" versus the "dbo" in the tree. I don't have a dbo.xp_cmdshell, just a sys.xp_cmdshell.
Previous
Reply
Map
View

Click here to load this message in the networking platform