Posts
1150
Comments
891
Trackbacks
1
Working with SQL Server 2005 System Views Across Databases


SELECT * FROM databasename.SYS.columns A
JOIN databasename.SYS.OBJECTS B
ON A.object_id = B.object_id
WHERE b.NAME = tablename

posted on Wednesday, November 01, 2006 9:59 AM Print
Comments
No comments posted yet.

Post Comment

Title *
Name *
Email
Url
Comment *  
Please add 6 and 2 and type the answer here: