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 |
|
nietoroger
Starting Member
3 Posts |
 Posted - 2011-06-02 : 10:16:16
|
Hi.I hope you can help me with this issue.I have a job that executes a command, something like: DECLARE @ORDEN NVARCHAR(2000)SET @ORDEN ='DIR *.*'EXEC MASTER.DBO.XP_CMDSHELL @ORDEN Today i get this error on 3 different serversCannot load the DLL ²»ÒªÃÔÁµ¸ç£¬¸çÖ»ÊǸö²ËÄñ QQ:897694317 ¼ÓQQȺ56992793 It is the same error in all servers.Thanks in advance. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-06-02 : 10:33:22
|
| On 3 servers?It seems like a registry issue when trying to get a dll reference - but on different servers that's a bit odd.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
nietoroger
Starting Member
3 Posts |
Posted - 2011-06-02 : 11:09:30
|
The 3 servers are independent of each other. So we can't think in a virus.The complete message is ODBC: Msg 0, Level 16, State 1Cannot load the DLL ²»ÒªÃÔÁµ¸ç£¬¸çÖ»ÊǸö²ËÄñ QQ:897694317 ¼ÓQQȺ56992793, or one of the DLLs it references. Reason: 126(error not found). |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-06-02 : 12:06:51
|
| Is the error exactly the same on each server or does the unreadable dll text change? It looks like it's not referencing a valid location.Have you rebooted the servers recently?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
nietoroger
Starting Member
3 Posts |
Posted - 2011-06-02 : 12:21:30
|
| I checked in all of them and the message is exactly the same. But in other servers it doesn't happens. In my pc with sql server 2008 developer edition it doesn't happens either.We asked to the crew a reboot, i'm waiting for it. |
|
|
|
|
|
|
Problem with XP_CMDSHELL