Articles

SQLServerCentral Article

Creating your own sp_MSforeach stored procedure

This article shows you one of the most time saving stored procedure built into SQL Server and then shows you how you can modify it to affect additional objects like triggers. For example, after this article and the code in the article, you'll be able to disable every trigger in your system in one line of code.

(1)

You rated this post out of 5. Change rating

2002-06-17

16,551 reads

SQLServerCentral Article

2002 SQL Server Best of Breed Product Nominations

Welcome to the first SQLServerCentral.com SQL Server Best of Breed Product Awards. These awards allow you to reward the products that you feel are the best in the SQL Server industry. These awards are user nominated and users vote for the winners.

You rated this post out of 5. Change rating

2002-06-10

24 reads

SQLServerCentral Article

Maintenance Plans - Backups and Removing Old Files

Andy has written several good articles for us on maintenance plans - including some stuff that makes us a little more likely to use them! This week he talks about how and when old backups are removed by maintenance plans. A page turner! Well, it's only one page, but you know what we mean!

You rated this post out of 5. Change rating

2002-06-10

7,601 reads

Blogs

Building AgentDBA’s Slack Escalation

By

Until now, a CRITICAL finding did the right internal routing, but the last mile...

Changing the Owner Removes Permissions: #SQLNewBlogger

By

This is actually inspired by an article SQL Server Central, which taught me something...

T-SQL Tuesday #200 - I Bet It's Bad if I See...

By

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

Read the latest Blogs

Forums

Developer edition cannot connect from other computers

By sqlfriend

I installed a new SQL server 2025 Enterprise developer edition for our development environment....

ALAMAT BCA KCU PONTIANAK TLP/WA 08218200174

By m4rt1n4

Telp Cs:(0821)8200174 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota...

ALAMAT BCA KCU TANJUNG PANDAN TLP/WA 08218200174

By R4nt4u

Telp Cs: (0821)8200174 Jl. Jend. Sudirman No.17, RT.008/RW.04, Pangkal Lalang, Kec. Tj. Pandan, Kabupaten...

Visit the forum

Question of the Day

Moving the Error Log

How can I change the location in which the SQL Server error log is written in SQL Server 2025?

See possible answers