How many AdventureWorks tables have an EmployeeID column? My query on sys.tables and sys.columns finds any column from all tables, with schema names.
SQL SERVER – 2005 – Get Field Name and Type of Database Table
How do you get the field name and type of a table in SQL Server 2005? Imran Mohammed answers with sp_help and an INFORMATION_SCHEMA.COLUMNS query.
SQL SERVER – mssqlsystemresource – Resource Database
What is mssqlsystemresource? It is the Resource Database, a read only database of system objects that makes upgrading SQL Server much easier.
SQL SERVER – 2005 -Track Down Active Transactions Using T-SQL
Want to track down active transactions in your database? One simple DMV query on sys.dm_tran_session_transactions returns them in SQL Server 2005.
SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database – Part 2
Joffery improved my script to find tables with foreign key constraint in a database, adding the ON UPDATE and ON DELETE rules and a little ordering.
SQL SERVER – Find Table in Every Database of SQL Server – Part 2
Part 2 of how to find a table in every database of SQL Server: this stored procedure loops through sys.databases and reads the Information_Schema view.
SQL SERVER – Find Table in Every Database of SQL Server
sys.tables only searches one database. My quick stored procedure finds a table in every database on the server and returns database, schema and table name.