title: SQL Server 2008 use server id as a default
body: <p>I have a tables of rows that exists in multiple databases. I will need to update the rows from one database into the other database and I have a primary key of int. So I am looking for a way to uniquely identify the server that added a particular row. I could use a uniqueidentifier in a default using the newid() or newseqentialid() but this seems overkill and inefficient.</p>
  
  <p>I would like to create a default value on a column of serverid of @@serverid but this doesn't exist, I could use @@servername but this seems too obvious to errors. Is there any way to get back a guid for the server and add it as a default on a column?</p>
  
  <p>Thanks in advance</p>
  
  <p>Phil</p>