extended proc?

[DLu]

Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'sp_MSgetversion'.

found above in error.log almost all the SQL 2k servers. What is it doing exactly for?
I could run sp_MSgetversion without that xpstar.dll?

thanks
David

[MAK]

sp_MSgetversion uses xpstar.dll


execute this.

sp_helptext sp_MSgetversion

[MAK]

http://www.fawcette.com/Archives/pre...0/jf0110-1.asp

[DLu]

in error.log, the first line has displayed the sql -8.00.760(intel x86) info already, why need to execute the sp_MSgetversion again later, and also need a xpstar.dll's help?
thanks
-D
thanks for the info.

[MAK]

I believe MS wants to get the info from the File xpstar.dll (go to properties and see the version of the file)

Everytime when you do a hot fix or service pack this file is getting updated.

I have no idea why they do not want to store that in a variable. I believe when this sp runs for the first time stores that info on the @@version global system variable.

[MAK]

may be that is why it is undocumented, so that we would use only @@version