Yes, it should revert back to your original username. This may sound like a long shot, but did you actually execute the REVERT? If you're running it one...

If all you care about is trapping the error and not sending the email, you probably want to look at using a TRY...CATCH block. http://technet.microsoft.com/en-us/library/ms179296%28v=sql.100%29.aspx

I'm wondering why you're sending...

jasona.work (11/8/2013)

---

Ed Wagner (11/8/2013)

---

jasona.work (11/8/2013)

---

So, put up gutter guard over the week to keep the back gutters on the house from filling with leaves, still need to get some to...

Well, if you're new to dates, the single best piece of advice I can possibly give you is to store dates in date fields. Don't use string data types...

jasona.work (11/8/2013)

---

So, put up gutter guard over the week to keep the back gutters on the house from filling with leaves, still need to get some to finish off the...

When you say...

vigneshlagoons (11/8/2013)

---

Hi,

I have a grid like this and when I change Designation value of Name X from PA to PAT, this change should reflect to Sathish Designation too. Changing similar...

Good question to end the week. Not everyone knows the basics, so a simple one every once it a while isn't a bad thing.

rodjkidd (11/7/2013)

---

It would appear that someone decided to switch off a bunch of import jobs on one of servers.

Spookily they didn't run from 1st Nov to 4th Nov inclusive. So...

The requirements are...

We use SQL Sentry for our monitoring and investigation. It's a great product and I'd recommend it to anyone.

I haven't used any Oracle monitoring tools myself, and don't work...

Accounting

Theory

Jeff Moden (11/6/2013)

---

To summarize...

1. You need to have a Windows account setup for the xp_CmdShell proxy. It can and should be just a "standard" user.

2. You need...

newbieuser (11/6/2013)

---

Hi friends,

I'm connecting to sql server 2012 database from management studio 2008R2 from my laptop. I always leave the session open on the management studio, but I've...