Anything in the windows or sql logs that explains the services not starting or stopping?

Sure, send me the vpn access info along with XXX$ in my paypal account and I'll get that sorted out for you.

In the mean time we don't see your servers...

@jake-2

Read this and then start a new thread if necessary

http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server

SM = SQL Monitor

MO = http://www.thefreedictionary.com/Modus+Operandi

Matches SM MO. It starts shorts traces to log something then shut it right down...

Ah! Ok, tx.

Leo.Miller (8/10/2011)

---

Another solution would be to set all the queries to use WITH (NOLOCK)

select * from Test1 with (nolock) where ID_Col = 10

But I would consider this a bit of...

Please post the actua execution plan(s) and we'll have a look.

I have sql monitor installed here and the logs is full of messages like this one.

Someone / something started a trace, you can be sure of that.

LutzM (8/10/2011)

---

Seems like I wasn't clear enough the code I posted could be used...

That report is fine, but how do you intend on scaling that to 30+ dbs if you don't have a script to run?

DBCC SQLPERF(logspace) will give you that. Of...

Agreed, but copy / paste is not a significant amount of work in my own book!

LutzM (8/10/2011)

---

Because it would not return a character value with leading zeros?

The function Matt...

Yes, you set the files for 100GB, but if there's only 10 GB of used space then there's 90 GB available for inserts / updates.

I think you have good reasons to post your reasons. Most guys here have become really good at filtering out "shaddy" descriptions.

I'm not insinuating you are doing anything illegal...