Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Transfer Logins and Passwords Between SQL Server 7.0 Servers

By coliveira,

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

Total article views: 1624 | Views in the last 30 days: 2
 
Related Articles
FORUM

Transfer SQL Server Objects Task

Transfer SQL Server Objects Task

FORUM

Transferring Databases

Transferring Databases between servers

FORUM

Transfer SQL Server Objects

Conditional data copy using Transfer SQL Server Objects in SSIS

FORUM

Transfer Logins from Oracle to Sql Server

Transfer Logins from Oracle to Sql Server

FORUM

Transfer Jobs between 2 servers

I need to transfer jobs from prod to test server

Tags
 
Contribute