| Author |
Topic |
|
nomadsoul
Yak Posting Veteran
89 Posts |
 Posted - 2006-12-10 : 03:43:33
|
| Hi,Im not new to SQL Server but I am new to v.2005. We have done a class project and to finish up I am creating schemas, logins and different user roles and permissions.I now need to detach the DB and send it to our team leader for submission. I'm scared to do this because I don't know if all the logins and passwords I've created will appear in it's new location. Will they be there in the new server's security folder just as I created them or will they dissapear into the ether?Signed:Sweating very muchIt is better to be prepared and not have an opportunity than to not be prepared and have an opportunity |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-12-10 : 15:00:38
|
| The logins will not go with the database. Basically anything that does not appear under the database node in the SSMS hierarchy is not in the database and will not go with it when you attach and detach.You can just script the logins and send the script along with the database. |
 |
|
|
nomadsoul
Yak Posting Veteran
89 Posts |
Posted - 2006-12-10 : 16:53:25
|
| Thanks snSQL, is there a script generator feature like there is with DB objects? or do I do it myself? Because I didn't find any such feature unless it's hidden somewhere.-Using Express.It is better to be prepared and not have an opportunity than to not be prepared and have an opportunity |
|
|
|
nomadsoul
Yak Posting Veteran
89 Posts |
Posted - 2006-12-10 : 16:57:14
|
| I found this:http://support.microsoft.com/kb/246133Im going to try it. I may need some help with it and will post again if I do.Thanks againIt is better to be prepared and not have an opportunity than to not be prepared and have an opportunity |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-12-10 : 21:10:45
|
| You should probably back up the database rather than detach it to send.When you were creating the logins you should have saved the commands used then you can just send that script.I think your tutor will expect you to have developed a script to create logins and users if that is part of the project.If not then you should just send the database and leave him to deal with the logins.If it was me then I would expect a script to create everything needed including the logins and database.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
nomadsoul
Yak Posting Veteran
89 Posts |
Posted - 2006-12-12 : 11:21:50
|
| Thanks nr, sorry I replied so late. couldn't get back here till now. The script was not expected but I wanted to all a little extra zing to the projectIt is better to be prepared and not have an opportunity than to not be prepared and have an opportunity |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-12-12 : 14:31:38
|
| Best of luck nomadsoul - I got 98% in my Computing paper, and that's because I went the extra mile.Regulars here will know that Wendy, who operated the Mainframe back in the early '70s, was part of the reason I went the extra mile. But Heck! that's just an incentive-scheme, right?!Kristen |
|
|
|
nomadsoul
Yak Posting Veteran
89 Posts |
Posted - 2006-12-12 : 17:05:57
|
| Kristen,Nice, now you can relax i bet.What did nr mean by this:"When you were creating the logins you should have saved the commands used then you can just send that script."How do I do that?It is better to be prepared and not have an opportunity than to not be prepared and have an opportunity |
|
|
|
|
Detaching and Attaching