In My WPF application I'm connecting to SQL server 2008 dataBase.
i want to give the users the option to restore the dataBase, when I'm trying to disconnect, and restore, i get the message saying that the restore failed due to the fact that it doesn't exclusive access.
I tried executing the command:
ALTER DATABASE <my db> SET SINGLE_USER with ROLLBACK IMMEDIATE
and now i can't access it at all...
1. how can i kill all the connections to the dataBase for restore?
2. How can i cancel this ALTER command?
View Complete Post