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.
| Author |
Topic |
|
royc
Yak Posting Veteran
53 Posts |
 Posted - 2006-11-07 : 02:44:15
|
| Hello,We are currently working with SQL 2000 and in many of my Stored procedures I am using xp_cmdshell.We are planning to upgrade to SQL 2005 this week and as far as I've heard running dos commands on 2005 from a Stored procedures is not supported and is replaced by another more secured solution.Can someone please shade some light on this issue and in case it is correct, suggest the securest way to replace xp_cmdshell?Thank you in advance,Roy |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-07 : 02:49:37
|
| It is still the same command, but as default the permission to run the command is restricted.Use Surface Configuration Tool to allow access to the command.Peter LarssonHelsingborg, Sweden |
 |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-11-07 : 03:36:27
|
| yeah, lots of things in SQL Server 2005 is disable by default, like remote connections.. etc i really dont know whether is this functionality or head ache....Chiraghttp://chirikworld.blogspot.com/ |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
|
|
|
Using xp_cmdshell in SQL 2005
blog thingie: http://weblogs.sqlteam.com/mladenp