Sql2k sp4 sql user password

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups

DB Engine

SQL Server MSDE SQL Server CE

Services

Analysis (Data Mining)Analysis (OLAP)DTS Integration Services Notification Services Reporting Services

Programming

CLR Connectivity SQL XML

Other Technologies

Clustering English Query Full-Text Search Replication Service Broker

General

Data Warehousing Performance Security Setup SQL Server Tools Other SQL Server Topics

Directory User Groups

Related Topics

MS Access Other DB Products MS Server Products .NET Development VB Development Java Development More Topics ...

SQL Server Forum / General / Security / March 2006

Sql2k sp4 sql user password

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mecn - 29 Mar 2006 22:49 GMT

If I DTS master.syslogins and sysusers table,the users' passwords
transferred as well?

Thanks

Reply to this Message

m.bohse@quest-consultants.com - 30 Mar 2006 13:25 GMT

Mecn,

you better use the Transfer Logins Task in DTS. This will transfer the
logins incl. passwords.

Markus

Reply to this Message

Uri Dimant - 30 Mar 2006 14:21 GMT

DTS Package will not transfer login's original SID. Search on internet
for 'sp_help_revlogin' stored procedure

> Mecn,
>
> you better use the Transfer Logins Task in DTS. This will transfer the
> logins incl. passwords.
>
> Markus

Reply to this Message

mecn - 30 Mar 2006 15:14 GMT

thanks

> Mecn,
>
> you better use the Transfer Logins Task in DTS. This will transfer the
> logins incl. passwords.
>
> Markus

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2009 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.