Scripts

Technical Article

Run a Script Against All User Databases

Now you can run administrative T-SQL tasks against all your databases in one shot. Very usefull for environments that have a seperate database for each client, ASP's, etc. It's pretty straight forward and can be used for almost any task. This example Looks for a table and prints the database name and selects from the […]

You rated this post out of 5. Change rating

2001-10-21

3,106 reads

Technical Article

Find Longstanding Open Transactions

Ever forget to commit a transaction and then find out hours later that there is deadlocked transactions all over your database server? Worse yet has one of your coworkers done this to your database server? Never again, this stored procedure will net send the machine that has an open transaction, and send you (The DBA) […]

4 (1)

You rated this post out of 5. Change rating

2001-10-08

9,059 reads

Technical Article

Transfer Logins and Passwords Between SQL Server 7.0 Servers

The SQL Server 7.0 Data Transformation Services (DTS) Object Transfer feature transfers logins and users between two servers, but it does not transfer the passwords for SQL Server authenticated logins. (DTS in Microsoft SQL Server 2000 does transfer passwords.)

You rated this post out of 5. Change rating

2001-10-01

1,648 reads

Blogs

Why the masters and what lies ahead

By

I recently graduated with a Master’s in Strategic Communication from the University of Delaware....

Copilot Reminded Me How To Find a File Handle

By

Recently I was trying to delete a folder and kept getting the “something is...

Planview Portfolios REST API with ADF – Retrieving Actual Data

By

In the introduction of this blog post series, I explained the use case: extracting...

Read the latest Blogs

Forums

DB stuck in restoring state

By LearningDBA

A developer tried restoring a test DB 3 times and each time it was...

singleton is interferring with getting multiple nodes in xml

By stan

Hi we have an xml doc shaped essentially as shown in image 2 below. ...

The backup to one location fails but is successful on another

By Arsh

Dear Friends, Would be glad if any of you can help in a backup...

Visit the forum

Question of the Day

Implementing Change Data Capture

I have a complex environment that uses quite a few SQL Server 2022 servers. We have a powerful SQL Server running Enterprise that hosts most of our transaction data. However, there are remote locations that run Standard, Web, Express, and Express with Advanced Services editions for local collection of data before the data is transferred to our central Enterprise Edition server. We are considering using Change Data Capture (CDC) to lower the amount of data we transfer from clients. Which editions can we implement this feature on?

See possible answers