May 3, 2011 at 11:55 am
I am converting a DTS package from SQL 2000 to 2008. Initially this package is being invoked via stored procedure that is using xp _ cmdshell.
in SQL 2008 I get permission denied error.
Does anyone know how to enable it in 2008?
Another thing is when you try to google for xp _ cmdshell 2008 - it crashes. I've tried searching here on sqlservercentral - it crashes too. is it a reserved word that can't be included in search criteria or something?
Many thanks!
May 3, 2011 at 12:08 pm
Melanie Peterson (5/3/2011)
I am converting a DTS package from SQL 2000 to 2008. Initially this package is being invoked via stored procedure that is using xp _ cmdshell.in SQL 2008 I get permission denied error.
Does anyone know how to enable it in 2008?
Another thing is when you try to google for xp _ cmdshell 2008 - it crashes. I've tried searching here on sqlservercentral - it crashes too. is it a reserved word that can't be included in search criteria or something?
Many thanks!
Haven't seen any issues with that search phrase causing a crash. works just fine in google for me.
Check out the links by Ninja
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 3, 2011 at 12:26 pm
It doesn't work in Bing or Google searches in IE8 or Chrome. Even when I search SQLServerCentral's Forums internally it blows up. Very weird.
May 3, 2011 at 12:29 pm
Hmmm...I wonder if you might be experiencing problems caused by spywear or maybe your employer has a proxy server that is causing the blowup.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply