Month: February 2012

Citrix, DataBase

Error: Another Version of Microsoft Visual Studio 2008 has been Detected on this System that must be Updated to SP1

Symptoms While attempting to install the SQL database and management tools from Microsoft on Windows 2008 R2 server that has XenApp 6.0 or later version installed, the following error message appears: “Another version of Microsoft Visual Studio 2008 has been detected on this system that must be updated to SP1. Please update all Visual Studio 2008 installations to SP1 level, by visiting Microsoft update.” The following table provides information about where the installation of SQL 2008 database and management tools fails. Machine Type SQL 2008 database and management tools: Install XenApp Installed, Configured on Windows 2008 R2 using SQL Express […]

Read more
DataBase

How to kill all sessions that have open connection in a SQL Server Database?

As SQL Server DBAs, many times we need to KILL all Open Sessions against the SQL Server Database to proceed with Maintenance Task, Restore and more… You can use below different techniques to KILL all open sessions against the database. Technique – I Here we will query the SysProcesses table to get the session running against the user database and prepare the dynamic SQL statement to KILL all the connection. view source print? 01 DECLARE @DbName nvarchar(50) 02 SET @DbName = N’Write a DB Name here’ 03   04 DECLARE @EXECSQL varchar(max) 05 SET @EXECSQL = ” 06   07 […]

Read more
DataBase

Fix: Cannot detach the database ‘DBName’ because it is currently in use. (Microsoft SQL Server, Error: 3703)

Cannot detach the database ‘DBName’ because it is currently in use. (Microsoft SQL Server, Error: 3703) When you detach a SQL DB via script/programmatic way you notice SQL fails to detach the DB with error indicating that the DB is still in use.  The same DB detach just works fine when you manually detach the DB before attempting to do it via scripted way.  Once scripting fails, even manual detach fails including restarting the SQL server instance service fails to get the DB released. This scenario particularly exists while you are copying/duplicating/restoring the DB on the SQL server instance. Error: […]

Read more