Data Dictionary from within SQL Server 2000
Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!
2005-02-04 (first published: 2002-02-11)
35,941 reads
Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!
2005-02-04 (first published: 2002-02-11)
35,941 reads
This script creates a stored procedure that you can call to get the record count for every table in a particular database. It uses the sp_MSforeachtable system stored procedure and a temp table.
2002-02-25
629 reads
This script is very helpful for anyone trying to recreate particular SQL Server Database Versions for Testing. It allows you to automatically recompile any stored procedures or views saved with drop, create and permission statements. The scripts must all be sitting in one directory and end in the same extension. I have found this very […]
2002-02-25
664 reads
Designing your application so that Stored Procedures are the only database objects that are accessed is generally the best practice. Agree? Disagree? Read this article by guest columnist Mindy Curnutt to see what she thinks!
2001-08-01
12,280 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking....
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
I have a SqlAgentJob calling a stored proc. that loops through a list of...
I know that there is a query you can run in SQL to search...
Hi all, 99% sure the answer to this question is "it is not possible",...