(newtophp2000@yahoo.com) writes:
> Here is a simple question. I am having difficulty accessing books
> online at Microsoft so I thought I would ask here. What is the
> standard naming syntax for Sqlserver 2005? Assuming I had the
> following table, [proddb01].[details].[dbo].[daily_tranx], how would I
> refer to it in the new version?

The same as you always have done.

The example is a little funny. "proddb01" sounds like a database, but
it appears in the position of the server name.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx