Posted by Erland Sommarskog on 06/12/07 21:10

Omar Abid (omar.abid2006@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, 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]