@@servername

If I try this
SELECT @.@.servername
In Query Analyzer, I get a servername other than mine (I'm connected to loca
lhost)
What's happening?
Thanks
RicardoRicardo,
If the server has been renamed in the past whilst SQL was installed, then
the @.@.servername will be wrong.
In order to resolve it, do the following.
SP_DROPSERVER OLDSERVERNAME
GO
SP_ADDSERVER CORRCECTSERVERNAME, LOCAL
GO
Then you must restart SQL server to take effect.
Immy
"Ricardo" <anonymous@.discussions.microsoft.com> wrote in message
news:F29CD1CA-3752-4B2F-97E9-CF6BE4FF10EB@.microsoft.com...
> If I try this
> SELECT @.@.servername
> In Query Analyzer, I get a servername other than mine (I'm connected to
localhost)
> What's happening?
> Thanks
> Ricardo|||Thanks Immy

@@servername

If I try this
SELECT @.@.servername
In Query Analyzer, I get a servername other than mine (I'm connected to localhost
What's happening
Thank
RicardoRicardo,
If the server has been renamed in the past whilst SQL was installed, then
the @.@.servername will be wrong.
In order to resolve it, do the following.
SP_DROPSERVER OLDSERVERNAME
GO
SP_ADDSERVER CORRCECTSERVERNAME, LOCAL
GO
Then you must restart SQL server to take effect.
Immy
"Ricardo" <anonymous@.discussions.microsoft.com> wrote in message
news:F29CD1CA-3752-4B2F-97E9-CF6BE4FF10EB@.microsoft.com...
> If I try this
>
> SELECT @.@.servername
>
> In Query Analyzer, I get a servername other than mine (I'm connected to
localhost)
>
> What's happening?
>
> Thanks
> Ricardo|||Thanks Imm