Neal Waterstreet

  • Home
  • About
  • Book Reviews
    • 2018 Reading List
    • 2017 Reading List
    • 2016 Reading List
    • 2015 Reading List
    • 2014 Reading List
    • 2013 Reading List
  • Projects
    • OBi200
    • DS716+ memory upgrade
    • Cord cutting
  • Presentations
  • Contact

Try the statement later.

November 1, 2011 by neal Leave a Comment

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.

Filed Under: Misc, Stuff

Leave a Reply Cancel reply

You must be logged in to post a comment.

November 2011
M T W T F S S
 123456
78910111213
14151617181920
21222324252627
282930  
« Oct   Dec »

Blogroll

  • Atlanta MDF
  • Atlanta Microsoft Business Intelligence Group
  • Atlanta Modern Excel User Group
  • Chris Webb's BI Blog
  • codegumbo
  • Lance England
  • PowerPivotPro
  • Prologika
  • SQLBI

Tags

Aereo Atlanta Microsoft BI Backups BA Conference Batch blog Business Rules Certification Chicago coffee Coursera Data Modeling Data Quality Data Warehouse DAX DVR Entity-based staging Error Messages ETL Excel Goals google Headphones HTPC Leaf Tables MDM MDS news OT PASS Healthcare VC Power BI Power Pivot Power View review Roku SQLSaturday SQL Saturday 272 SQL Server SSIS Subscription View Tabular Tech Training Validation Work

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Copyright © 2021 · Minimum Pro Theme on Genesis Framework · WordPress · Log in