COldCoffee (4/20/2010)

---

Jason, Il est la forme...

dma-669038 (4/20/2010)

---

Sound advice Steve, am one of those compulsive bloggers, either write a lot or not at all. Yes definitely people have to catch up and respond. Yes we will...

Thanks

I recently talked w/ Andy Leonard, and he was very interested...

That's ok we can assign 6666 to Emperor Paulpatine:-D

Paul White NZ (4/20/2010)

---

CirquedeSQLeil (4/20/2010)

---

I did note a few things, he still uses sysprocesses (I believe it is for the blocking process count), implements a ton of dynamic sql, uses...

Steve Jones - Editor (4/20/2010)

---

I'll check with Red Gate tomorrow. In terms of sponsorship, I think we can do something. Not sure we want to host it, but maybe we'll...

Unfortunate score - really.

gmamata7 (4/20/2010)

---

I'm Using the below script in SQL Agent & running daily as a job, which writes the data file & log file used space & free space in the...

This should be a good resource for you.

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

replenish

Have you verified that the server can still communicate with AD?

Also, is the account expired or locked out?

You may need to disjoin and then rejoin the Domain.

Though the brackets will correct that issue, I recommend not including special characters in server or database names (_ - etc)

COldCoffee (4/17/2010)

---

Will the below code help you buddy??

WITH MAX_DATE_FOR_A_MACHINE_CTE(MACHINE_NAME, MAX_DATE)

AS

(

SELECT

NAME

, MAX(DATE) MAX_DATE

...

It depends on your support contract with them. You should contact them directly to find out.

Many indexes only need to have a Reorg performed on them.

There is a great script for doing this by Michelle Ufford, here[/url].