Use this script to find tables, views, stored procedures that directly reference a column in the SELECT statement or in a join. This script will also return stored procedure and view names that have SELECT * in them when the specified column exists in the table referenced by that SELECT statement.
2002-03-15
1,053 reads
Drop all indexes, constraints and statistics for given table.
2002-03-14
1,195 reads
Generates a XML document containing metadata on a specified table. Table name is provided to the procedure.
2002-03-13
585 reads
This short and simple script is a very fast way to count the rows in all your indexed tables. I ran it against a 2-gigabyte database containing large tables (some with over a million rows!), and it returned results in under a second.
2002-03-12
2,872 reads
Procedure to help find missing constraints when comparing two databases that are supposed to be the same. SP has ability to show all constraints per database, and the ability to generate create scripts to make adding the missing constraints easier.
2006-12-26 (first published: 2002-03-12)
776 reads
This procedure when executed with the correct parameters, exports all stored procedures from a database into different .SQL files in the path specified.Usage :exec USP_PRINT_PROCS username, password, servername, databasename, directory path
2002-03-12
555 reads
Returns the Owner, Table Name, Row count for all user tables in the current database.
2002-03-11
605 reads
I was posed a question a few months back on another site about being about to create a Pivot Table (Horizontal version of vertical data) and I saw the question again today. This will allow you to do that, just make changes to the query where the title is the replacement need. It will build […]
2002-03-07
1,323 reads
--Delete all restrictions from those tables included in the input parameters Procedure HP_BORRA_CONSTRAINTS -- Include CHECK, FOREIGN KEY, PRIMARY KEY, UNIQUE, and DEFAULT constraints.
2002-03-07
459 reads
This will report all backup activity for all databases, sorted by date, so you see the last backup activity first. You can filter this one by a db name as well, and only see the backup info for said database.
2002-03-07
804 reads
By Brian Kelley
I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...
By Steve Jones
I had a customer recently reach out to ask if SQL Clone would work...
Ollama SQL FastStart kit just works out of the box. It makes it easy...
Comments posted to this topic are about the item Create an HTML Report on...
Erectile dysfunction (ED) affects millions of men and arises from a combination of physical,...
While doing some housekeeping activity on several old but large production databases, I come...
In SQL Server 2022, how many backup files can I have in a striped backup?
See possible answers