get meta data

• sqlfriend

  SSC Guru

  Points: 52794

  More actions

  June 19, 2011 at 6:07 pm

  #252204

  If I would like to pull column and tables metadata from SQL server 2008/2005, what it the best way of doing that?

  Thanks

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  June 19, 2011 at 6:25 pm

  #1340926

  You could use CDC or CT depending upon your requrements.

  The following article may be helpful to you:

  http://parasdoshi.com/2011/02/09/technology-post-on-database-keeping-track-of-whathowwho-of-changed-data-in-sql-server-2008/

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  June 19, 2011 at 6:35 pm

  #1340929

  Check Books Online for the sys.tables and sys.columns system tables.