You don't have to use a trigger.

You could use the OUTPUT clause from the insert statement:

INSERT INTO TabA (Col1, Col2)

OUTPUT Inserted.Col1, Inserted.Col2 INTO TabB (Col1,Col2)

VALUES ('A','B')

Because of the naming conventions (you're right, they're horrible), it's hard to tell exactly what's happening in the "generic" design. However, looking at your design, it sure seems to me...

Congratulations.

Yes, you should learn tons & tons. When you've only yourself to rely on, you start learning things very, very quickly. Remember that automation is your friend. Spending an hour...

The only time I had to do this I was using an application to take the output from a stored procedure and then save it to a file. I haven't...

I'm sorry, no, becuase, I think like everyone else, I still don't understand what you're trying to accomplish...

If I understand the question, you can simply use the Database Diagrams to see all the tables and their relationships. Assuming those relationships in your database are all through primary...

D'oh!

Did Steve see?

And following up on what Matt says, you want to know that too. Except for extreme circumstances (you're about to lose the house, the family is hungry, etc.) lying your...

Bad news. I just ran this little in 2008:

goto MyLabel

exec sp_who

Mylabel:

It's STILL there. I'm planning on being in Seattle in November for PASS... I'll brink an Ozark Tire Thumper and...

I agree. We work with XML a lot out in the applications, but the database mostly just returns regular old result sets.

However, if you really had to, in addition to...

You can run DBCC OPENTRAN('dbname') to verify that there are no open transactions. Run the Activity Monitor will also let you know if a transaction is still open in the...

Tell them the truth. Anything else will get you into trouble.

"I've been working for these insane college kids at this dot com and I can't stand it any more."

I used...

Oh man, don't they have to kick you off the boards for 8 months like Don Imus if you use language like that?

I still don't understand the problem fully, so I'm not sure I can help.

The second line is just a short cheat that's available with the "go" statement that makes it...

The way I did it early in my career was answer as many questions for my peers as possible. Then I'd take the question & answer to the guys I...