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 |
|
DBADave
Constraint Violating Yak Guru
366 Posts |
 Posted - 2006-06-06 : 09:39:37
|
| If I run xp_cmdshell 'dir *.*', my results areoutput--------------NULL(1 row(s) affected)If I restart SQL Server and try it again while connected directly to the server it works. However, as soon as I try running the command from my PC, I receive the above results. If I then try to run the command directly from the server, I also receive the above results. It stops working. Any ideas?Extra Info----------SQL Server 2000 sp3aWindows 2003 sp1My domain account is a member of a domain group that has been added to the local administrator group on the sql serverThanks, Dave |
|
|
|
|
|
xp_cmdshell Breaks After Remote Execution