Site Sections
Posts
808
Comments
670
Trackbacks
1
<< Explaining ESB and SOA through Story-Telling | Home | .NET 3.0 Framework RTM >>
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 8 and 6 and type the answer here:
Archives
Post Categories
Stuff
clustrmaps
Locations of visitors to this page