Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01323280
Message ID:
01323325
Views:
15
>>>>>>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.

Why would you need to use Master? :) You would want to use your database.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View