A little more info:

FIX: SERVERPROPERTY Returns Incorrect Value for LICENSETYPE

http://support.microsoft.com/default.aspx?scid=kb;en-us;291332

The workaround is to re-confirm the licensing in the SQL Server 2000 licensing control panel applet, but I...

Glitch,

You should look into the DATABASEPROPERTY function in BOL.

SELECT DATABASERPROPERTY('dbname', 'IsInLoad')

will return 1 if it is being restored, 0 otherwise.

You might try something like this, using VB script and SQL-DMO.

- J. Kozloski, MCDBA

' script using SQL-DMO to find available servers on network

' and register them in Enterprise...