Brian Knight

Brian Knight, MCSE, MCDBA, is on the Board of Directors for the Professional Association for SQL Server (PASS) and runs the local SQL Server users group in Jacksonville. Brian is a contributing columnist for SQL Magazine and also maintains a weekly column for the database website SQLServerCentral.com. He is the author of Admin911: SQL Server (Osborne/McGraw-Hill Publishing) and co-author of Professional SQL Server DTS (Wrox Press). Brian is a Senior SQL Server Database Consultant at Alltel in Jacksonville and spends most of his time deep in DTS and SQL Server.

Technical Article

sp_MSforeachfk-Perform an action on every FK

This stored procedure loops through each user defined Foreign Key and performs an action on that FK, like disabling them or printing its name. Please install this stored procedure in the MASTER database. For full usage instructions and advanced parameters please see the article about it at http://www.sqlservercentral.com/columnists/bknight/sp_msforeachworker.asp. .Shortened version of the usage (there are […]

You rated this post out of 5. Change rating

2002-06-14

666 reads

Technical Article

sp_MSforeachsproc -Perform an action on each sproc

This stored procedure loops through each view and performs an action on that stored procedure, like printing the records or running an sp_help. Please install this stored procedure in the MASTER database. For full usage instructions and advanced parameters please see the article about it at http://www.sqlservercentral.com/columnists/bknight/sp_msforeachworker.asp.Shortened version of the usage (there are a lot […]

You rated this post out of 5. Change rating

2002-06-14

1,374 reads

Technical Article

sp_MSforeachtrigger-Perform action on each trigger

This stored procedure loops through each trigger and performs an action on that trigger , like disabling or printing it. Please install this stored procedure in the MASTER database. For full usage instructions and advanced parameters please see the article about it at http://www.sqlservercentral.com/columnists/bknight/sp_msforeachworker.asp. Shortened version of the usage (there are a lot more parameters […]

You rated this post out of 5. Change rating

2002-06-14

667 reads

Technical Article

sp_MSforeachview - Perform an action on each view

This stored procedure loops through each view and performs an action on that view, like counting or printing the records. Please install this stored procedure in the MASTER database. For full usage instructions and advanced parameters please see the article about it at http://www.sqlservercentral.com/columnists/bknight/sp_msforeachworker.asp. Shortened version of the usage (there are a lot more parameters […]

You rated this post out of 5. Change rating

2002-06-14

2,057 reads

SQLServerCentral Article

SQLsnake Worm Hits SQL Servers and Networks Hard

If you haven't changed the SA password on your SQL Server, you may be soon paying the price. Beginning last week, an old worm has come back in full force, infecting about 100 SQL Servers an hour. Reports of heavy port 1433 scanning began in early may but by the 22nd, the virus really began to take its hold on systems with no SA password.

You rated this post out of 5. Change rating

2002-05-28

4,811 reads

Technical Article

Detect the Amount of Wasted Data Space in a Table for 2000

SP_WASTED_SPACE will run through each column in your database and print a report of all the character columns. It will then print a report with :* The maximum length that a column is storing* The average length of data stored in each column* The amount of wasted space in each column* Hints on how to […]

You rated this post out of 5. Change rating

2002-03-14

1,127 reads

SQLServerCentral Article

Total SQL Analyzer Review

Often times, a DBA is asked by clients to document their entire server. This usually includes jobs, database objects and DTS packages. What an utterly boring task it is for a DBA to document the properties of each column, table, and database. FMS's new Total SQL Analyzer to the rescue, freeing up time for people who are tired of creating mountains of documentation.

You rated this post out of 5. Change rating

2001-12-12

3,536 reads

Blogs

Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution

By

For decades, enterprises have approached data management with the same mindset as someone stuffing...

Truncate Table Pitfalls

By

 Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....

dataMinds Connect 2025 – Slides & Scripts

By

You can find all the session materials for the presentation “Indexing for Dummies” that...

Read the latest Blogs

Forums

extended events to spy on our server between 8 and 9 am

By stan

Hi, our peer who owns a remote mysql server from which we extract warehouse...

Restore Job fails in Replication

By Arsh

Dear Folks, Restore jobs in my SQL2022 Standard edition replication were failing on a...

visual studio seems to lose "provider" on pkg imports

By stan

hi, just to get this part out of the way, if my intended target...

Visit the forum

Question of the Day

Vector Datatype Dimensions

The new vector datatype in SQL Server 2025 requires a number dimension parameter. What is the maximum number of dimensions supported?

See possible answers