May 14, 2002 at 8:45 am
I am having database uwifi with a existing records added by the user, when i run the following command DROP DATABASE uwifi GO sp_droplogin 'uwifi' Go RESTORE DATABASE Uwifi FROM DISK='C:\Program Files\Uwifi\NOC\Database\Uwifi' WITH MOVE 'Uwifi_DAT' TO 'C:\Program Files\Uwifi\NOC\Database\Uwifi.MDF', MOVE 'Uwifi_LOG' TO 'C:\Program Files\Uwifi\NOC\Database\Uwifi.LDF', REPLACE GO Use uwifi GO sp_change_users_login 'auto_fix', 'uwifi' GO sp_password NULL, 'uwifi', 'uwifi' Go exit The records added by the user is deleted, what ever records are default are there. I want all the records added by the user should also be updated when I run above command. So can anyone help me in this
May 14, 2002 at 9:27 am
You have to do a backup database to get a copy of the users entered records, then you can drop and move to a new location.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 14, 2002 at 10:39 pm
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply