SQL Server Engine Tips

Guidelines, Best Practices, TSQL and SQL Programming Tips & Tricks.

This Blog

About
Email

Syndication

Search

News

These postings are provided
"AS IS" with no warranties,
and confers no rights.
Use of included script samples
are subject to the terms
specified at http://www.microsoft.com/ info/cpyright.htm.

SQL Server 2005

SQL Server Document Links

Browse by Tags

All Tags » Catalog Views (RSS)

Using catalog views in SQL Server 2005

Did you know that the catalog views in SQL Server 2005 exposes metadata for various objects in a database and at the server-level? This is the preferred method of accessing metadata. It is a much richer mechanism that doesn't require access to system Read More...

Posted Wednesday, September 06, 2006 11:31 AM by SQL Server Engine Team | 2 Comments

Filed under: Catalog Views, Announcements

Use of INFORMATION_SCHEMA views to access temp tables.

An MVP recently sent us an email asking how to use the INFORMATION_SCHEMA views to access temp tables. This MVP thought the session ID (spid) was needed to construct the suffix. Here was our response: ========================= Hi, The algorithm for generating Read More...

Posted Friday, October 07, 2005 7:06 PM by SQL Server Engine Team | 1 Comments

Filed under: Catalog Views

Determine primary keys and unique keys for all tables in a database...

Determine primary keys and unique keys for all tables in a database using INFORMATION_SCHEMA views and the new catalog views in SQL Server 2005 Read More...

Posted Friday, September 16, 2005 11:27 AM by SQL Server Engine Team | 7 Comments