Store procedure

[fschenatz]

Hej har en liten fråga gällande store procedure.

Har fått på halsen att ta reda på vad denna store procedure gör. så jag lägger med hur raderna ser ut, skulle någon vänlig skäl vilja förklara vad denna store procedure gör.

 

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

GO

 

GRANT EXECUTE ON dbo.xp_ndo_enumusergroups TO public

GO

 

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

GO

 

GRANT EXECUTE ON dbo.xp_ndo_enumusersids TO public

GO

 

återkom med svar så fort det går tack

 

/fschenatz

 

[Cluster]

Snabb googling ger vid handen att den har koppling till Navision's authenticiering:

With the SQL Server Option for Dynamics NAV, you can use Windows authentication to connect to SQL Server. This is only possible when the server’s operating system is Windows XP, Windows 2000 Server or Windows Server 2003.

You must add two extended stored procedures, xp_ndo_enumusergroups and

xp_ndo_enumusersids, to each instance of SQL Server that you want to access with

Windows authentication. The installation program for Dynamics NAV installs the

xp_ndo.dll for you. The first time Dynamics NAV connects to the server, the program

will add the extended stored procedures automatically.

http://download.microsoft.com/download/a/5/0/a506cf2c-3162-4009-82e4-103c0f5db70c/w1w1isql.pdf

 

/Cluster

------------------------------------------------------

I do not fear computers. I fear the lack of them

--------> http://eforum.kicks-ass.net <---------