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.

Could be me, but I didn't see any differences between the two strings.

Edit: And yes, there is a way to fix it, I just can't remember it off the...

The RESTORE will not add a new datafile. To do so, you first restore the database, then you ALTER it to add the second datafile.

Has to do with how the string values are actually concatenated. IIRC, straight concatenation, @Var1 = @Var1 + @Var2 for instance, actually copies the data from @Var1 and @Var2...