The PASS Healthcare Virtual Chapter has it’s first meeting on 11/17 at 1pm EST.
The topic will be “SQL Server in Healthcare – Healthy relationship?” by Scott Shaw. Go to http://healthcare.sqlpass.org for more information on upcoming topics and be sure to follow @HealthcareSQLVC on Twitter.
This is something that I’ve been working on over the last several months and it is great to see it taking off!
I got an error message I’d never seen before while altering a database.
Database is in transition. Try the statement later. (Microsoft SQL Server, Error: 952)
Try the statement later? What does that mean?
I altered a column in a test database and immediately tried to take it offline. That is when I got the error. After searching for the message I found this:
http://social.msdn.microsoft.com/Forums/en/sqlgetstarted/thread/e779230a-87bc-4cee-b223-98a029097dc1
One of the solutions was to search sys.dm_exec_requests for an alter process on that database. Sure enough it was suspended. I killed the SPID and the database was back online pretty quickly.