Hello,
 Can anybody tell me why when i "select @.@.servername" it=B4s  returned NULL value?
 Should i do an INSERT in the master..sysservers? or can  you tell me if exists something that correct this  situation?
 Best RegardsMake a backup of master firs
do sp_dropserver 'servername
g
sp_addserver 'servername', loca
g
then stop and start your server
Then select @.@.servernam
Jef
MCDBA, MCSE+|||Thanks Jeff
>--Original Message--
>Make a backup of master first
>do sp_dropserver 'servername'
>go
>sp_addserver 'servername', local
>go
>then stop and start your server.
>Then select @.@.servername
>Jeff
>MCDBA, MCSE+I
>.
>
 
No comments:
Post a Comment