I'd rather not use a cursor, whenever possible, but I have been unable to think of a way to do this without it. You see, in order to maintain data...

Dang, I always miss something in a query....

Comes from juggling as many projects as I am, I guess.

I will mess around with the trigger some more to see if I...

Thanks. Good learning experience.

I think I am still in good shape though, because of this:

CREATE TABLE Test (

[ID] Int Identity,

name VARCHAR(200),

Val VarChar(10)

)

GO

CREATE TRIGGER trg_Test ON dbo.Test

AFTER INSERT

AS

DECLARE @rowCount INT

SELECT @rowCount...

I have been reading up on triggers and while the documentation doesn't come right out and say it, it does imply that with After triggers they fire once per record, and...

Oh year, forgot about that insert. Kind of pathetic because I use it all the time.

So I cannot expect my trigger to fire for each record inserted? I'm going to...

I thought that a trigger fired for each record that X action happened to, which is why actions on tables with triggers are inherently slower than without.

Also, I am...

Some the the fields did not "move forward", as is supposed to happen in section 2, and only one of the defaults got set, the ejDepartment, the first of the...

That's what I thought too, until part of the trigger didn't work, and reordering the code in the trigger, with no other mods, made all parts of the trigger work...

That BOL topic discusses order of triggers, not order of operations within a single trigger, which is my problem.

The order of the sections in the trigger was random when they...

I have not really thought of a more valid test for this, if this one is invalid. My testing had no isolation or segmenting of networks. My main concern was...

Just ran across this. See the "How do I perform encryption with SQL Server?" question at: http://www.sqlsecurity.com/FAQs/SQLServerFAQ/tabid/55/Default.aspx

Chris

We have been discussing this for a project we are doing and we have settled on the encryption that is part of the OSes API.

I thought about third-party tools...

When I did it I ran the same query twice, one with encryption and once without, and I was able to compare similar packets in the sniffer, and see that...

I may be out of my realm, since I know SQL2000 encryption and do not know how much it has changed for 2005, so keep that in mind as you...

This depends on your persepective. First of all, if you put it on the dev boxes be prepared to put it on the Prod boxes, because once the developers start...