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!
2007-10-02 (first published: 2002-02-11)
36,379 reads
Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!
2007-10-02 (first published: 2002-02-11)
36,379 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
669 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
703 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,796 reads
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
hi, we couldnt get our upstream data source developers to supply what is sometimes...
Are there any good articles on all the trace flags that are enabled on...
Comments posted to this topic are about the item The Data Model Matters
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers