Production and BCP users SYNC help

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Production and BCP users SYNC help

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2010-10-06 : 14:52:52

Hi Experts,
my PROD and BCP server users arenot in sync and not having the sameprevilleges. how cna i make then in sync exactly?

is that like sp_helprevlogin? or something better with you?

please give me the link

thanks in advance

Arnav
Even you learn 1%, Learn it with 100% confidence.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-06 : 15:21:53

What is a bcp server?

Here's what I use and wrote: http://weblogs.sqlteam.com/tarad/archive/2008/06/24/How-to-transfer-SQL-logins-between-SQL-Server-2005-instances.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2010-10-06 : 15:56:29

thanks a lot

Arnav
Even you learn 1%, Learn it with 100% confidence.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources