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,656 reads

Blogs

T-SQL Tuesday #191: Invitation–Your Favorite String Parsing

By

It’s that time of the month, and I’m late. My apologies. I had a...

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....

Read the latest Blogs

Forums

PWDCompare

By Steve Jones - SSC Editor

Comments posted to this topic are about the item PWDCompare

The Improvement Limit

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Improvement Limit

Migrate SSRS Reports to a New Server in Just a Few Clicks

By Kunal Rathi

Comments posted to this topic are about the item Migrate SSRS Reports to a...

Visit the forum

Question of the Day

PWDCompare

What does the PWDCOMPARE function do?

See possible answers