Had no idea my question would spark so much conversation....

I'll try and answer all of the questions that I've ready and not responded to yet.

There are transactions in the stored...

GilaMonster (1/11/2010)

---

What uses the primary key to filter/select by? If nothing, I'd suggest a 3-phase approach here.

1) Make the primary key nonclustered

2) Add a clustered index on the CreateDate column

3)...

GilaMonster (1/11/2010)

---

gregory.anderson (1/11/2010)

---

Never heard of the partition thing...I'll look into that.

Yes, this is 2005 enterprise edition, sp2 I believe.

Right now, the customer is receiving 5 9's of uptime and they...

GilaMonster (1/11/2010)

---

Why do you want row locking there?

Before going that step, have you checked indexes?

Is this Enterprise Edition? If so, have you considered table partitioning. With a partitioned table,...

can someone explain the "freq_interval & 64 = 64"...specifically the & character. What does that do?

Rudy Panigas (1/6/2010)

---

Excellent script! Keep up the great work!

Question for you. Would you know if you can display the length of each job too? I would be nice to see...

Rudy Panigas (1/6/2010)

---

Excellent script! Keep up the great work!

Question for you. Would you know if you can display the length of each job too? I would be nice to see...

Kinda weird, I do not have the table msdb.dbo.sysschedules...I can see sysjobschedules though.

Did I not install SQL Server [Agent] correctly?

Elliott W (12/3/2009)

---

The problem with doing start|run as YOU from Server A is that it doesn't prove much.. All you have proven is YOU can do it.. If...

Elliott W (12/3/2009)

---

I have a thought..

Login as the SQLAdmin user either through Remote Desktop or on the console itself and see if you can get to that location. ...

Elliott W (12/3/2009)

---

When you reference the bat files is it on a default share C$ or such or one you created yourself? Check the permissions on the share, administrators...

Elliott W (12/3/2009)

---

gregory.anderson (12/3/2009)

---

I'm not sure if I follow yours completely....but I'll try again.

I have two servers, ServerA, and ServerB.

ServerA holds SQL Server Agent

ServerB holds asp.net application code

The job on...

Elliott W (12/3/2009)

---

So you have SQL and SQL Agent on server A and you call an OS command on Server B and you get an Access Denied.

Ok, how are you...

I'm not sure if I follow yours completely....but I'll try again.

I have two servers, ServerA, and ServerB.

ServerA holds SQL Server Agent

ServerB holds asp.net application code

The job on ServerA calls a...

GilaMonster (11/20/2009)

---

Double (triple) check that you're looking at the same server from the Quest tool and management studio. Double (triple) check that it's the same database. Double (triple) check that...