@GilaMonster, I came back to re-read because I was thinking I may have missed something you were picking up in my description. I think see what you were expanding on....

This is true only when the job is owned by a member of the sysadmin Fixed...

GilaMonster (9/19/2012)

---

opc.three (9/19/2012)

---

For A: Unlike Oracle, in SQL Server if you want each statement to implicitly start a new transaction then you must SET IMPLICIT_TRANSACTIONS ON. The default in...

Oracle_91 (9/10/2012)

---

Hi All,

I have 2 sql sevr 2005 instances with same build no,same edition.

I restored the database from one insatnce to another instance. But when i execute the...

Jason Selburg (9/12/2012)

---

Did you rebuild statistics?

I do believe that even though the servers may be configured the same/same hardware, when you restore a database the stats get "out of whack".

I...

Following along with Kevin's post, think it through carefully. Here is a nice write up I recently found to help you consider all points of why you might employ partitioning,...

mrrobsewell (9/14/2012)

---

I have a PS script that interrogates JobServer.Jobs on all servers across my estate at 7am.

So when I come into work it has emailed me a single email for...

The question definitely has layers to it as Sean alluded to. They were hoping to learn various things about you from it.

I would have picked apart and addressed each part...

If your table is truly static and you have the space then add as many indexes as you need to cover the queries being issued. Go ahead and use a...

v5d1.ch (9/16/2012)

---

Thank you joy smith.that article explains lot but i am still bit confused.i understood why we need to rebuild whenever we drop a column.it is beacuse we have to

...

It could be characterized as a hack, but adding a trigger to the relevant msdb system tables might get you what you need:

USE msdb

GO

IF OBJECT_ID(N'dbo.sysjobs_update') IS...

Timothy Graffham (9/19/2012)

---

I was very excited to go to my post this morning and see 8 responses. I thought I was going to get some real help. Instead,...

Great, common ground.

You too.

Lynn Pettis (9/19/2012)

---

opc.three (9/19/2012)

---

Lynn Pettis (9/19/2012)

---

opc.three (9/19/2012)

---

Lynn Pettis (9/19/2012)

---

opc.three (9/4/2012)

---

Jeff Moden (9/4/2012)

---

opc.three (9/4/2012)

---

All sysadmins can execute any commands they wish and those commands will run in the context of the...

Lynn Pettis (9/19/2012)

---

opc.three (9/19/2012)

---

Lynn Pettis (9/19/2012)

---

opc.three (9/4/2012)

---

Jeff Moden (9/4/2012)

---

opc.three (9/4/2012)

---

All sysadmins can execute any commands they wish and those commands will run in the context of the SQL Server service...