OK, cool, I didn't know you could do all of that.

Anyway, to answer your question, yes, I would put as much of that as possible in a stored procedure.

It is a lot of effort-overhead. I haven't used Certificates much beyond proc-signing for some cross-database stuff. Let me read Jonathan's article and see if I can better...

"SELECT COUNT() ..." is usually faster than "SELECT * ...", especially over a network connection.

How many rows does this query return?

Should...

You should be able to view them if you put it in Standby (which is normal for Log-shipping secondaries). I can, anyway. 🙂

Is it the Primary or a Secondary? And what's the compatibility level of the database.

Unless the queries all strictly follow the same very simple format, this is going to fall somewhere between "Impossible" and "Incredibly Hard" to do in SQL.

If the queries are all...

There are certain areas of SQL Server that are not as well supported by scripting as others. Security, in general, is one of them and certificates in particular.

Because of...

Yeah, I've had this happen to me too on customer sites. It was really annoying because it would NULL-Propogate across all of my email and dynamic SQL strings anywhere...

Check to see if there are any other processes...

telaan (8/28/2012)

---

Hi,

I am working with my AD admin to get delegation set up between several servers so we can do a double hop.

We've set the SPNs and enabled delegation but...

Heh, all problems are serious until you...

Lynn Pettis (8/28/2012)

---

And this is the ANSI standard way of doing the same update as above:

UPDATE Orders SET

some_col = (select

...

"host process ID 30416" refers to that user (or program's) Windows process ID. You'll need to check the windows Event Log (if you're lucky and its in there), or...