Need a little assistance...

[ranchan02]

Hi Everyone:

I wrote a stored procedure that calls the master..xp_cmdshell and when I execute my stored procedure, it gives me this error:

----------------
Cannot load the DLL xplog70.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
----------------

I did a search on the machine that hosts the SQL Server and the file xplog70.dll does not exist in there, so could someone explain to me how to re-install this dll file? Thank you.

 

[vongrunt]

If memory serves me well, that file must be in MSSQL\Binn directory. Some DBAs remove it for security reasons...

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]

 

[ranchan02]

Hi vongrunt:

Thanks for the reply. Dumb question...can I just copy and paste the dll into this MSSQL\Binn directory from the CD?