That must be an issue with 2005 Agent because the setup works fine in 2008 Agent, i.e. it keeps going even after an error has occurred from not being able...

Rob Scholl (7/1/2011)

---

We have a developer who likes to have a single stored procedure return completely different result sets based on an @action parameter being passed. In general they...

When there have been no updates or seeks on the index of course 🙂

Here is a quick proof that shows how to achieve that state:

IF EXISTS ( SELECT *

...

Jeff Moden (6/30/2011)

---

Tony,

One more "extension" of the problem you posed. It's super easy to break out all of the individual parts of the path and number them. Shamelessly...

It may help us if you provided some sample DDL and DML so we can build a little test environment on our side. This way, with the sample data and...

Commercial offerings are scarce, and I think that's a good thing. There is only one book you really need, but it's not the one most people think of right away:

Books...

Hmmm...I see x64 downloads.

Go here: http://support.microsoft.com/kb/2261464

...then click on "View and request hotfix downloads" at the top.

Got it now 🙂

Use sys.sysprocesses for 2005+

Craig Farrell (6/30/2011)

---

You guys bash folks looking for someone who will conform first, and change after. Sorry, I have to disagree. Until you've meshed into their fold you don't understand...

Me too 🙂

It's always 2, the id for tempdb, for me.

LoginName & NTUserName are proper which is nice. Maybe one of those could be used to infer the DB name, depending on...

Excellent, you're very welcome 🙂

That does not seem to work in terms of finding the correct database name. It always says tempdb for me 🙁

I think this is along the lines of what you're looking for. Please let us know:

CREATE TRIGGER dbo.TBL_LOCATIONS_after_insert ON dbo.TBL_LOCATIONS

AFTER INSERT

AS

BEGIN

INSERT ...

In my experience when a manager talks about "teamwork" it typically translates into something along the lines of conformity and group-think. Innovation and improvement over current ways of doing things...