Ian Scarlett (9/24/2008)

---

I should have looked at the original post in detail.

Although you can use the INSTEAD OF trigger to replace data in columns, the nullability is checked BEFORE the...

I hadn't thought about confirming ownership but the table is the only one of that name and it is owned by dbo, as is the trigger. I also checked...

As unbelievable as it is, it isn't firing. I did try adding a print statement to the beginning of the trigger and nothing. I've also checked to make...

I forgot to mention, if I run the stored procedure it returns a value. However, since the trigger isn't firing, the procedure doesn't run.

The two fields that get populated are set to NOT NULL, so the INSERT operation fails. If I were to supply values for them, the INSERT would succeed, but...

Hmmm...

CREATE TRIGGER INSERT_TICKET ON TICKET

INSTEAD OF INSERT

AS

IF LNAME = 'Massi'

--Do nothing

ELSE

INSERT INTO TICKET

...

That is an excellent suggestion. Seeing as how we have specialized, valuable skills we could certainly help out organizations that we support. You've given me something to ponder...

^^^ Agreed, lawyers are quite an expense as it is and a case like that would look like a SCO gravy-train to them. As for government regulations, I thought...

My wife wants a laptop, maybe the next time we're near a major airport, we'll just go up to the counter and say we lost a laptop. Then we...

I'm a Reporting Services beginner, but I stumbled across the following article while looking for something else:

http://www.sqlservercentral.com/articles/Development/2945/[/url]

It goes into detail about how to achieve what you are looking for if...

Your story reminds me of what happened to my dogs 3 weeks ago. They were playing and the little one got his jaw under the collar of the big...

Although I haven't been working in this field long ~5 years, I agree wholeheartedly with your observations.

Between the recruiters scrounging up bodies to fill seats to get commissions and contractors...

I have always just used the same AD groups to apply permissions to them in a role. Although I do recall discussing how we were going to set up...

I enjoy these types of movies too. Although I rank low on the list as well, I don't live in a huge city. Even still, if there were...

In my last job, I had access to the accounting and HR databases, but I never touched them. As "fun" as it would have been to answer questions that...