C# Programming
11-16-2009, 05:13 AM
Hi All,
I have to write a code for *******ing multiple databases at a time. The steps which it has to perform for *******ing databases are :
1. Source Server database backup.
2. Target Server database backup.
3. Capture user information.
3. Terminate active DB user .
4. Restore Database on target.
5. Drop existing user.
6. Re-create users.
7. Map users to the logins.
Can i write a stored procedure in c # itself to make this happen? If yes, please let me know how.
Thanks,
Vikas
vikas da
I have to write a code for *******ing multiple databases at a time. The steps which it has to perform for *******ing databases are :
1. Source Server database backup.
2. Target Server database backup.
3. Capture user information.
3. Terminate active DB user .
4. Restore Database on target.
5. Drop existing user.
6. Re-create users.
7. Map users to the logins.
Can i write a stored procedure in c # itself to make this happen? If yes, please let me know how.
Thanks,
Vikas
vikas da