Here is an interesting method for keeping track of modifications brought to an SQL Server database structure: http://www.codeproject.com/KB/database/sql2005dba.aspx This is quite useful when working on a new version of a database driven web site, since all modifications made to the development database will eventually have to be applied to the QA database and finally the […]
Search SQL objects
Sometimes, I wished I had a mean to find database objects using a particular column or table, and I just came across an interesting script that might help with this. It is a stored procedure to find SQL Server objects based on a column name or text in the code (for Stored Procedures, Functions and […]
SQL Server query to list all user tables in a database
select name from sysobjects where type = ‘U’