Posted by Hugo Kornelis on 03/13/06 01:04

On 12 Mar 2006 14:26:55 -0800, newtophp2000@yahoo.com wrote:

>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?
>
>Thanks a lot!

Hi newtophp2000,

In SQL Server 2000, namiing was <server>.<database>.<owner>.<table>. In
SQL Server 20005, this changes to <server>.<database>.<schema>.<table>.

The only change is that owner and schema are now seperated. On migration
from 2000 to 2005, all objects will automatically be placed in a schema
that matches the name of the owner. After that, you can decide to change
the schema, and you set the schema for new objects how you want.

--
Hugo Kornelis, SQL Server MVP

• Next in forum: Re: Different query plans for view and view definition statement
• Prev in forum: Re: Getting list of recently added IDENTITY items
• Thread view: Re: Naming syntax in 2005

[Reply to this message]