Search code examples
sql-server-2008instance

SQL Server Instance ID

I'm looking for a way to identify a particular SQL Server Instance from a stored procedure within the server. What I need is to be sure that my app is connecting to that particular instance and not to some other instance with the same name/ip address.

Solution

  • I'd take a look at the SERVERPROPERTY function - you could use a mixture of InstanceName, MachineName, ServerName or ProcessID for example.