Instance ID for SQL 2k

[macleod1021]

Is there a unique instance ID created when an SQL 2k instance is installed? I vaguely remember seeing this information somewhere but my memory is a bit clouded and I may be thinking of something else. If there is, where is it stored at? Is it something that I can get through DMO, registry or some other method?

There may also be another way to do what I'm looking for. I need to get some type of unique identifier that will be different if the user attempts to create a new instance and copy the database over.

Thanks.

 

[mrdenny]

select @@SERVERNAME will pull the server name and the instance name. If there is a \ and anything after it it's a named instance. If @@SERVERNAME is just the name of the server then it's the default instance.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[SQLDenis]

select SERVERPROPERTY ( 'InstanceName' ) will give you the instance name or null if it's the default instance

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[macleod1021]

I'm actually looking for a numeric value, if it exists. I know the registry stores a GUID, but I was looking for something that could be pulled from the server itself for the database.

 

[SQLDenis]

DB_ID will give you the database ID
DB_NAME will give you the database name

select DB_ID(), DB_NAME()

select SERVERPROPERTY ( 'ProcessID' ) will give you the Process ID of the SQL Server service

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[mrdenny]

I don't know of a numeric value for the instance.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com