Try connecting with DAC

http://msdn.microsoft.com/en-us/library/ms189595.aspx

See if you can gain access that way.

In the meantime, do you have backups of your master database?

Trey Staker (7/22/2010)

---

I used to work with a DBA who was a pretty good lock pick. We had a server down on a saturday and neither of us had...

That would be the cause. I would find out which one is the correct size and make all of them the same size.

Thanks for introducing me to Breadpig - that is a new one for me.

Have you tried commenting out that column and rerunning the Insert? What are the column definitions for the remaining columns?

Have you run DBCC Checkdb as the error suggests?

I learned something new today - again.

Yay.

Are you logging in with an account that has security admin or sysadmin permissions?

Something we have done is to backup the files to a USB drive and then courier the USB drive to the remote location.

For the differences between the two locations, do...

L' Eomot Inversé (1/18/2012)

---

SQLRNNR (1/18/2012)

---

anybody know a good resource for exporting into sqlplan format the xml from sys.dm_exec_query_plan(qs.plan_handle) for a smallish subset of ~100 plans?

I have been able to copy...

Gianluca Sartori (1/18/2012)

---

SQLRNNR (1/18/2012)

---

Gianluca Sartori (1/18/2012)

---

SQLRNNR (1/18/2012)

---

anybody know a good resource for exporting into sqlplan format the xml from sys.dm_exec_query_plan(qs.plan_handle) for a smallish subset of ~100 plans?

I have been able...

Gianluca Sartori (1/18/2012)

---

SQLRNNR (1/18/2012)

---

anybody know a good resource for exporting into sqlplan format the xml from sys.dm_exec_query_plan(qs.plan_handle) for a smallish subset of ~100 plans?

I have been able to copy the...

anybody know a good resource for exporting into sqlplan format the xml from sys.dm_exec_query_plan(qs.plan_handle) for a smallish subset of ~100 plans?

I have been able to copy the xml and get...

miss gomer

Glad you liked it.