CirquedeSQLeil (1/5/2010)

---

Lynn Pettis (1/5/2010)

---

Alvin Ramard (1/5/2010)

---

Lynn Pettis (1/5/2010)

---

CirquedeSQLeil (1/5/2010)

---

Lynn Pettis (1/5/2010)

---

Actually, nothing earlier...

Basically, you got the idea.

The user will need a different login if you want to restrict access, but still provide the user with the other login that basically has god-like...

Alvin Ramard (1/5/2010)

---

Lynn Pettis (1/5/2010)

---

CirquedeSQLeil (1/5/2010)

---

Lynn Pettis (1/5/2010)

---

Actually, nothing earlier indicated that it...

Actually, the users login doesn't even need to be mapped to a user in a database to have access sice it has sysadmin rights at the server level.

Cool Beans!

CirquedeSQLeil (1/5/2010)

---

Lynn Pettis (1/5/2010)

---

Actually, nothing earlier indicated that it was urgent, so more...

A user with sysadmin server rights has full access to everything in the instance.

Actually, nothing earlier indicated that it was urgent, so more like ...

I have...

Had an interesting conversation with a friend of mine a while back. He is a systems engineer type who is now a Deputy Program Manager. When he moved...

I can see why it is urgent now. It has been three weeks since you initially asked for help. Obviously it must not have been to important when...

Greg Edwards-268690 (1/5/2010)

---

GSquared (1/5/2010)

---

tosscrosby-60625 (1/4/2010)

---

GSquared (1/4/2010)

---

tosscrosby-60625 (1/4/2010)

---

CirquedeSQLeil (1/4/2010)

---

GSquared (1/4/2010)

---

Well, while we're adding pictures: For a potentially limited time only, the goofy looking guy in the picture on my posts is...

By the way, most of us are volunteers with paying jobs of our own, and saying this: Its very Urgent. i may lose my job if dont get this., doesn't...

You'll have to use the sysjobhistory table and compute the end date/time using the run_date, run_time, and run_duration columns.

First, I would not do the backup over the network. Do the backup local to server A then move it to server B. Since the servers are in...

Try sysjobschedules.