A simple script to list tables in database without primary key, using sys.tables and OBJECTPROPERTY TableHasPrimaryKey in SQL Server 2005.
SQL SERVER – 2005 List All Tables of Database
The simple way to list all tables of a database in SQL Server 2005: select from sys.tables to get every table that users have created.
Searching Every Stored Procedure for a Word
Searching every stored procedure through sys.sql_modules finds text quickly, but comments, case, dynamic SQL, and other databases need care.
How the Main System Views Connect
Learn how the main system views connect through object_id, schema_id, index_id, and column_id so catalog joins stay accurate.
SQL SERVER – Fix : Error 2501 : Cannot find a table or object with the name . Check the system catalog.
Error 2501, cannot find a table or object with the name, is a common beginner error. Check the database with USE, the spelling and case, and the owner name.
SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column value of the table
A query to list every identity column with its seed, increment and current value, plus what those numbers mean and how to reseed a table safely.