Hi,
I'm fairly new working with SQL Server 7 so any help would be greatly appreciated. I want to replicate our production database but I'm running into a few problems.
1. I restored a user database but the master database doesn't reflect the sysuser information. Now I can't create any new logins because it gives me a SQLSTATE 42000 error specifying that the user or group already exist. How can I resolve this?
2. What is single user mode? I tried to restore a master database from another SQL Server but it wouldn't let me unless i was in single user mode.
3. How do I install the ad hoc update feature? Is there any other way to edit the table information without this feature? thanks.
I'm fairly new working with SQL Server 7 so any help would be greatly appreciated. I want to replicate our production database but I'm running into a few problems.
1. I restored a user database but the master database doesn't reflect the sysuser information. Now I can't create any new logins because it gives me a SQLSTATE 42000 error specifying that the user or group already exist. How can I resolve this?
2. What is single user mode? I tried to restore a master database from another SQL Server but it wouldn't let me unless i was in single user mode.
3. How do I install the ad hoc update feature? Is there any other way to edit the table information without this feature? thanks.