Four Part Naming Issue  
Author Message
Morph





PostPosted: Mon Jul 25 00:33:15 CDT 2005 Top

SQL Server Developer >> Four Part Naming Issue

I have a system that execute queries across two databases. Up until now,
these 2 database have been situated on the same server, however the system
was built so these two databases could exist across multiple servers. To do
this, four part naming was employed, even if the database was on the same
server. We recently got a new production server, and deplyed the system on
this machine and we no longer able to run a four part name query on the local
server, where the fourth part (servername) is the local server. If have

however we also had an old production server that it worked on that was not
Developer edition on sql. (This machine has been rebuilt so I can't find out
exactly what is was)

Has anyone else had this problem before? Does anyone have any ideas how to
fix it, I can't abandon the use of four part naming.

@@VERSION results
Old server (four part name working)
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.0 (Build 2195: Service Pack 4)
new server (four part name not working)
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)

Thank you
Clint Colefax

SQL Server265  
 
 
Mike





PostPosted: Mon Jul 25 00:33:15 CDT 2005 Top

SQL Server Developer >> Four Part Naming Issue Some history of the "new" machine would be helpful. Is it a brand new
install of sql server, has the box had it's name changed etc?

Suggest you try:

sp_dropserver 'servername'
sp_addserver 'servername', local

Then stop and restart SQL server.

Mike John



>I have a system that execute queries across two databases. Up until now,
> these 2 database have been situated on the same server, however the system
> was built so these two databases could exist across multiple servers. To
> do
> this, four part naming was employed, even if the database was on the same
> server. We recently got a new production server, and deplyed the system on
> this machine and we no longer able to run a four part name query on the
> local
> server, where the fourth part (servername) is the local server. If have

> works,
> however we also had an old production server that it worked on that was
> not
> Developer edition on sql. (This machine has been rebuilt so I can't find
> out
> exactly what is was)
>
> Has anyone else had this problem before? Does anyone have any ideas how to
> fix it, I can't abandon the use of four part naming.
>

> Old server (four part name working)
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on
> Windows
> NT 5.0 (Build 2195: Service Pack 4)
> new server (four part name not working)
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on
> Windows
> NT 5.2 (Build 3790: Service Pack 1)
>
> Thank you
> Clint Colefax