Posted by Omar Abid on 06/12/07 21:46

On 12 juin, 23:10, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Omar Abid (omar.abid2...@gmail.com) writes:
> > Thank you the problem was solved, and I used mid to get the table
> > name, because the output was "[DBO].[table]"
>
> You could modify the query if you don't want the schema.
>
> Then again, in SQL 2005, it may be dangerous to ignore the schema, since
> SQL 2005 makes schemas useful, and it can be deceivable to work with.
> The AdventureWorks database is a good example of this.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Thank you for your advice, it was really helpful to me
Omar Abid

• Next in forum: Modification Logs
• Prev in forum: Re: MSSQL - DTS Package - Find distinct rows - Output to TXT file - ActiveX?
• Thread view: Re: SQL Server 2005 with VB.net 2005

[Reply to this message]