Monday, April 28, 2008

adding extended procedure

USE master
EXEC sp_addextendedproc xp_ndo_enumusergroups, 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xp_ndo.dll'
GO
GRANT EXECUTE ON [xp_ndo_enumusergroups] TO PUBLIC

GO

USE master

EXEC sp_addextendedproc xp_ndo_enumusersids, 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xp_ndo.dll'

GO GRANT EXECUTE ON [xp_ndo_enumusersids] TO PUBLIC

GO

No comments: