Posted by Erland Sommarskog on 03/13/06 01:21

(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/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]