Search code examples
sqlsql-serversql-server-2012database-deadlocks

Transaction (Process ID 461) was deadlocked

I run a script which creates Database, Procedures and Tables in that database; I got following error message:

Msg 1205, Level 13, State 51, Line 1
Transaction (Process ID 461) was deadlocked on lock resources with another 
 process and has been chosen as the deadlock victim. Rerun the transaction.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.

And after that error message, there are messages like below:

(1 row(s) affected)

I can't see any DB created in sql server.But when I fire select statement of one of the table of that database, I get data of that table.

Solution

  • But, I recommend you to restart your sql server.

    So, it will again check your scripts and give you a true result whether your database have that table or not