Viewing 3 posts - 1 through 3 (of 3 total)
Problem solved...
There were a lot of cmd processes blocked in the server.
So for sql was impossible to gain acces to another session of external command...
A virus was found.
With virus removed...
September 5, 2006 at 7:04 am
Yes.
This is driving me crazy.
I don't think this can be a security problem. (I use sa as username running my code).
In any case...
There is a smarter way to know if...
August 25, 2006 at 7:19 am
Sure. The code is:
/*Code starts here*/
DECLARE @retValueINT
DECLARE @strSqlVARCHAR(1000)
DECLARE @RemoteUsrVARCHAR(50)
DECLARE @RemotePwdVARCHAR(50)
DECLARE @ServerName VARCHAR(50)
SET @RemoteUsr = 'sa'
SET @RemotePwd = 'RightPasswordHere'
SET @ServerName = 'servername'
SET @strSql = 'osql -U ' + @RemoteUsr + '...
August 25, 2006 at 3:22 am
Viewing 3 posts - 1 through 3 (of 3 total)