looks like SQL shutdown to me.

C drives nowadays should be at least 30GB to support 2008 OS and SQL

you probably have your SQL system databases installed on the C drive and these are the likely culprits for using up space. these can be moved. I would avoid moving...

Gianluca is correct, there is no way, there should be IMHO but there isn't.

Best you can do short of sysadmin is have all jobs owned by the same SQL authenticated...

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/05/17/lock-escalation.aspx

pls post the error.

was it related to ansi settings by any chance?

hopefully this thread will help

http://www.sqlservercentral.com/Forums/Topic1156166-146-2.aspx#bm1158118

..and straight back off topic (what was it again?)

thanks to those who voted on the SQLagent connect item. I don't know if MS look at them again when they are...

that helps homebrew, cheers,

except the SQL to create an application role is different to a database role (CREATE APPLICATION ROLE ) and also requires a password specified in the create...

darn, I don't use application roles anywhere!

That will have...

you may also want to record who the database owner was before the restore.

add this code:

select 'alter authorization on database::['+db_name()+'] to ['+ suser_sname(owner_sid)+']'

AS 'owner of database when script was created'

from...

@Remi

darn them for closing it. worth another comment asking for it to be looked at again?

obviously a very worthwhile educational question on the basis that so many people have thought the shrink would have no affect.

now they know!

this is actually an example of where RBAR is a good thing. I...

Koen Verbeeck (8/10/2011)

---

Ninja's_RGR'us (8/10/2011)

---

Brandie Tarvin (8/10/2011)

---

Help me bug Microsoft about a minor issue that is driving me sane.

https://connect.microsoft.com/SQLServer/feedback/details/683683/ssms-open-empty-environment-option-does-not-work-correctly

This one is giving me heartburn. I almost ran something in Production that...