Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
User and Permission Table
Hi ! May I know how can I transfer those user, permission and access table to a new database ? For example, database apple --> database apple1 I managed to transferred all other user created DB but I can't transfer master database. Please help !- whkwan
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Transferring Database
I thought it is not so easy to overwrite what is in master database furthermore, physical file location is stored in master database and my file location in new server is different from the old one. Will that cause any problem ? Thanks ..- whkwan
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Transferring Database
Hi ! Now I need to transfer current database to a new server. File location might be different. Any steps to do that ? Unfortunately all user information is stored in master database. Physical file location also stored there but directory struture will be different. How can I do that ? Pls...- whkwan
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
