Part 3 of Find Table in Every Database: Greg Steinkuhler shares a stored procedure that also searches servers across the network, where sp_msforeachdb could not.
SQL SERVER – Orphaned MS DTC Transaction Information
An orphaned MS DTC transaction kept crashing our IIS application pool. A quick script on sys.syslockinfo shows if you have one, and a Microsoft hotfix solved it.
SQL SERVER – Function Property – Deterministic or Non-Deterministic
How do you tell if a user defined function is deterministic or non-deterministic? One OBJECTPROPERTY call with IsDeterministic gives you the answer.
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 Extension
Two more ways from Simon Worth to find table in every database of SQL Server, both built on sp_msforeachdb, one saving results to a temp table.
SQL SERVER – 2000 – SQL SERVER – Delete Duplicate Records – Rows – Readers Contribution
A reader asked how to Delete Duplicate Records in SQL Server 2000, and another reader answered with a quick SET ROWCOUNT script. Both, side by side.
SQL SERVER – How to Rename Database Objects to Comply With Naming Conventions
Christopher Miller shares a T-SQL script that renames default constraints to match his team’s naming conventions, cleaning up names that slipped through.