Creation of database in SQLSERVER2008 cannot get exclusive lock on database ' model '

SQLSERVER2008

Problem: Creating a database in SQLSERVER2008 does not get an exclusive lock on the database ' model '

Workaround:

Run the following code in Query Analyzer:

Use master

DECLARE @sql varchar (100)
While 1=1
Begin
Select top 1 @sql = ' kill ' +cast (spid as varchar (3))
From Master. sysprocesses
where spid > and spid <> @ @spid
If @ @rowcount = 0
Break
EXEC (@sql)
End

Creation of database in SQLSERVER2008 cannot get exclusive lock on database ' model '