While working on a project sometimes it happened that we need to shift the database from one server to another due to various reason (sometimes…
When we are keen to know that what is currently running on SQL SERVER for analysis purpose then with the help of below SQL statement…
As we mention in TIP 10 to set database user as Single user now to make this available again for all the user or…
Sometimes it is require to set database as single user for maintenance or other recovery purpose. We need to write following statement GO ALTER DATABASE…