If you take a look at the first link in my signature below, you'll see how we usually prefer code assistance requests to be formatted. We're looking to have...

I agree with Jeff here. Don't use that method, and give the SQLAgent running the job the necessary permissions, and save with no encrypted data.

Concurrency.

The most typical reason two identical environments behave differently (and I do mean identical, down to the data in them)...

SQLKnowItAll (1/27/2014)

---

We have a main database on its own server for our internal application. Several other applications with databases on different servers need this data in real time. We currently...

I hate to say it, then, but you've basically answered your own question.

The command's not getting to the server, and the service you're using to send it over isn't getting...

I don't know if you need a full on table for this, but yes, you need to create a list somewhere, somehow, for this.

You can create the list in the...

I'd start with running a serverside trace on the 2012 server to determine if the commands are even getting there.

If the commands are reaching the server, then it's something we...

You need to add a profile to the dbmail. It's not security for the login, it's setup for the sysmail profile for the login

Check out msdb.dbo.sysmail_add_principalprofile_sp.

"invalid profile" is not an exact error. Can you cut and paste the full error message here?

Run away unless this is hourly. Just run.

Personally, I'd offer a semi-realistic plan based on their lack of data. Start with quoting them a 2 week period to...

Lynn Pettis (1/24/2014)

---

Thanks to all who answered my question so far. I was just curious as I overheard one of our SAs make the comment that it was a...

PARSENAME (usually used for server.database.schema.table) will work just as well for an IP4 address, and would save you some of your patindexing.

Can we see the query you're using to get...

GilaMonster (1/23/2014)

---

In that case, Kraig's comments on contention don't apply, he was talking about the practice of creating a table...

Ah hah!...

The problem with a sequence table isn't the uniqueness (it works), it's the contention you get when everything needs to access the single point. Because of that, GUID is...