View Single Post

   
  #1 (permalink)  
Old 02-29-2008, 07:10 AM
tgru
 
Posts: n/a
Default @@servername returns NULL

I am trying to script out the creation of database scripts. I am trying
to use @@servername in the statement. I found out the select
@@servername returns NULL. I used sp_dropserver to drop any servernames
first, restarted SQL, ran sp_addserver 'servername' to add the
servername, restarted SQL. select @@servername still returns NULL...

Any ideas why this may be happening?

Thanks,

TGru

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Reply With Quote