Greg

Good, comprehensive article - thanks. Just one thing I thought I ought to pick up on:

When a session creates temporary table that contains a named constraint inside a transaction,...

The error message tells you where to look - it's in the sp_rename stored procedure. My guess is that "OBJECT" needs to go in (single) quotes.

John

So you want to match every job with every status? Just use a CROSS JOIN.

John

Adam

You don't say exactly what you're struggling with. I haven't read through those links that you posted, but what I'd do is have two separate packages. The first...

No, that doesn't do the same thing, and it's not recommended[/url], either.

John

Edit - ignore me. I was talking about something different. I wasn't aware of this option for...

Here's one popular solution[/url].

John

You can do that with dynamic SQL, or you can insert the values individually into a temp table or table variable and join to that.

John

GilaMonster (3/16/2016)

---

SteveD SQL (3/16/2016)

---

Also can I assume that if I had a SP that returned a larger results set I could pre-fetch the values to variables like below and...

Yes, if you must do it in the data layer instead of the presentation layer, an inline table valued function would perform better. Better still, why not create a...

Change the default database for sa to master.

John

SELECT name FROM sys.servers WHERE server_id = 0

SELECT SERVERPROPERTY('ServerName')

John

What data type is the ScheduledDateTime column in your database?

John

smitty-1088185 (3/7/2016)

---

Could you provide an example? When I run the following command no text shows for the SQL_TEXT

SELECT

spid

,sp.STATUS

...

Interesting. I had assumed that NULL is always listed first in an ORDER BY. Indeed it is, if you order ascending. But if you add DESC to...

franky.Piferoen (3/10/2016)

---

Hi,

I forgot in the previous reply to mention the error from the errorlog

Login failed for user 'SomeUser'. Reason: Could not find a login matching the name provided

Thx for the...