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.
| Author |
Topic |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2009-09-02 : 16:06:47
|
| I have restored a db in new server. Now I want 2 logins from the old server. Is there any way to script those two logins with permissions and create in new server?Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ScottWhigham
Starting Member
49 Posts |
Posted - 2009-09-03 : 10:16:06
|
quote:
Originally posted by laddu
I have restored a db in new server. Now I want 2 logins from the old server. Is there any way to script those two logins with permissions and create in new server?Thanks.
What "permissions" are you wanting to script out? When you restore the database, the user permissions will already be present. And FYI: Tibor's script is for SQL 7/2000 servers. It will work in 2005/2008 but will not bring over things like policy adherence, status, or any of the new features/roles in 2005/2008.I think this is the simplest method: [url]http://support.microsoft.com/kb/246133[/url]========================================================I have about 1,000 video tutorials on SQL Server 2008, 2005, and 2000 over at http://www.learnitfirst.com/Database-Professionals.aspx |
 |
|
|
krishnarajeesh
Yak Posting Veteran
67 Posts |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2009-09-07 : 16:34:45
|
| sp_revlogin is the procedure, use that you will be all setArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
Moving logins