You can also use @@ROWCOUNT as the FIRST statement in the trigger to determine the # of rows affected by the calling action.

You could do it if you designed the package to have 2 paths where 1 just executes that single task based on a configuration that sets a value in variable...

love seeing what y'all are reading. Because I'm cheap I'm going through the classics on my kindle. Currently reading my way through most of Dickens' books.

Grant Fritchey (4/24/2012)

---

Jack Corbett (4/24/2012)

---

Ooh,...

Grant Fritchey (4/24/2012)

---

Kiara (4/24/2012)

---

Lynn Pettis (4/24/2012)

---

Nope, too much fun watching now. I can even answer his question on why he keeps getting the same value for...

Grant Fritchey (4/20/2012)

---

The Dixie Flatline (4/19/2012)

---

Okay, I will apologize for bringing this up in the Thread. But I'm getting tired of writing private messages.

Yes, Gail, I was at the...

SpringTownDBA (4/13/2012)

---

The base...

SpringTownDBA (4/13/2012)

---

As I've recently tackled some Full-text performance problems, I'll throw out some possibilities.

1. The FTS engine does have some caching in it. There is no documentation on what/when/how...

You are correct, you would have to grant access to the tables or views in the original database. You could use Table-Valued functions instead of views and sign them....

That's not accurate. SQLAgentOperator can view ALL jobs, but can only modify the jobs that the user owns....

You didn't come across as unappreciative. I just don't believe your colleague because there aren't a whole lot of ways to get gaps in a column with the IDENTITY...

GilaMonster (4/12/2012)

---

I'm getting very frustrated (and very saddened) by the (apparently) increasing number of people who seem to feel that writing T-SQL is about throwing code segments together at random...

Rich Yarger (4/12/2012)

---

I just received some information from one of my colleagues that is looking at the ID skips with me, and he has indicated that he does not believe...

If you want to update the column whenever it is edited you have 2 options with SQL Server.

1. Include the column in the update statement either using GETDATE() or...

If the column already exists and is one of the date data types then you should be able to ALTER it to add the constraint.

Your T-SQL would be:

ALTER TABLE x

...