moonshadow
Programmer
We have a SQL 6.0 system (Ok, stop laughing). It has a database on it called PMIS_Customer which gets restored each night from a backup copied from another server by a scheduling system (Ashwin). For the last week it has failed every night complaining that the 'database is in use by other users'. I get the same message during the day when I try and perform a restore, drop or set to single user mode. I cannot find any users that are in the database, using sp_who or activity monitor, although there are users connected to the server. The only solutions I've found are to either stop/start SQL (can't do that again), or use sp_MSKillDB to delete the database entirely & then recreate it. I'm not too keen to do this in the schedule - it seems a bit reckless. Has ANYONE got any ideas ?
