Search
Monday, January 05, 2009 ..:: Blog ::.. Register  Login
 Search_Blog Minimize

 Print   
 Blog_Archive Minimize

 Print   
 Nice SQL script to sync User logins Minimize
Location: BlogsDevelopments    
Posted by: TM Central 6/3/2008 2:23 PM

One of our least-favorite tasks is moving a database.  This is a well-documented pain for a simple reason: user logins.  Each SQL server has a unique id (SID) attached to each user so even if the user name is the same, the login may-or-may-not be linked to the DB permissions. This article has a better description and a great solution:

http://www.sqlservercentral.com/articles/Log+Shipping/63028/

Permalink |  Trackback

  
Copyright 2005 by TMCentral, LLC   Terms Of Use  Privacy Statement
DotNetNuke® is copyright 2002-2009 by DotNetNuke Corporation