SQL Help!!!! (xp_ndo.dll)

boywonder

Damn it! I've just read the help file with the xp_ndo.dll file and tried to add a query via SQL Server Management Studio, but the first attempt was accepted and I mistakenly put in the 64 bit file instead of the normal one #-o .

Now when I try to execute the proper query:

USE master
EXEC sp_addextendedproc xp_ndo_enumusergroups, 'C:\Program Files\Microsoft SQL Server\MSSQL\Binn\xp_ndo.dll'
GO

GRANT EXECUTE
ON [xp_ndo_enumusergroups]
TO PUBLIC
GO

It says:

Msg 2714, Level 16, State 7, Procedure sp_addextendedproc, Line 24
There is already an object named 'xp_ndo_enumusergroups' in the database.

Anyone know how I can remove the problem one first!? :?

Many thanks

boywonder

LOL solved it! \:D/ \:D/

Found out there is a command 'dropextendedproc' which removes the existing problem one and then of course the code can execute as it should

DenSter

Good work figuring it out =D>

kriki

[Topic moved from Navision forum to SQL General forum]