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.
SQL SERVER – Identifiers As Valid Object Names
Chi-Ho Min found you can skip parts of a four part name with dots, like servername…tablename. Here is how identifiers work as valid object names.
SQL SERVER – 2005 – Find Database Collation Using T-SQL and SSMS – Part 2
Reader jwwishart shared another way to find database collation in SQL Server 2005: a one line SELECT of collation_name from sys.databases.
SQL SERVER – 2005 – List All Column With Identity Key In Specific Database
Question I received in Email : How to list all the columns in the database which are used as identity key in my database?