Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
associates
Starting Member
31 Posts |
 Posted - 2006-08-07 : 23:32:30
|
| Hi, I was wondering if anyone might be able to help me out. I was trying to migrate access database to SQL Server 2005 Express Edition via Studio Express. I have also used SMAA for Access to migrate it to SQL Server 2005.HOwever, i got trouble when creating new database in the studio Express. The following below is the error messages. TITLE: Microsoft SQL Server Management Studio Express------------------------------Create failed for Database 'chw'. (Microsoft.SqlServer.Express.Smo)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)------------------------------Could not obtain exclusive lock on database 'model'. Retry the operation later.CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (Microsoft SQL Server, Error: 1807)Could anyone help me how to get around this issue? I have no clue of what the error msg trying to say? what is database 'model'?Thank you in advance |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-08 : 04:26:59
|
| model is a system database and is used as a template to create new databases.It's saying it can't get a lock on it which is a bit odd.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
error in creating database in studio express