a shrink needs to make updates to the database so is not an option when the database is in read-only mode.

Ron, I thought it was Friday?

Steve is developing a talent for putting a bit of a twist into the seemingly simpler questions!

thats a good question.

My visit count is more than double my posts, either some people remain logged on for ever or visits are counted oddly....

Thanks Craig, always the bearer of good news. 🙂

I knew I was going to have to do some more work to actually get the space back, but nice to know...

did you have the updates box ticked when you checked, it should show all patches applied

Copying system databases from any server to another will always lead to some issues, and...

@paul-2 - please read the first 3 posts - this might HAVE to be a drop column and I need to be prepared for that.

I appreciate the intention - but...

Gianluca Sartori (1/12/2012)

---

Quite true, but you could batch UPDATEs to set the column to NULL. Once every row...

PaulB-TheOneAndOnly (1/12/2012)

---

george sibbald (1/12/2012)

---

well yes, obviously, but how much space is that? Very much an...

Gianluca Sartori (1/12/2012)

---

Lowell (1/12/2012)

---

for something similar, we've created the parallel table without the image column, migrated the data, then renamed the old vs new table, and after we were sure...

well yes, obviously, but how much space is that? Very much an 'it depends' question.

If...

well, simple ways

see what patches you have in add\remove programs

do a search on 'build list' in the search field at the top right of the SSC page, and check out...

thanks lowell, that could be batched up and would also have the advantage for us of defragmenting the table (no primary key, no clustered index). I could also add an...

I think its worth noting here that even members of SQAgentoperatorRole cannot modify or delete jobs they do not own.

This limitation unfortunately prevents granting the right to someone to fully...

SCOM