>>when do you want it to fire and what do you want the fire action to be?

the trigger, ideally, should be fired only when there is a new row inserted...

Seth, there are very few times that column will be populated and hence the trigger will be needed.. and hence for performance sake, i was seeking better option...

>>Reqires significant CPU power to encrypt/decrypt the data on the fly.

This is true for column-level encryption, too?

good code.

>>Less overhead? Where did you get that?

quoted from http://msdn.microsoft.com/en-us/library/cc278098%28v=sql.100%29.aspx

"

performance for a very basic query (that selects and decrypts a single encrypted column) when using cell-level encryption tends to...

Steve

The sqlsrv32.dll (OLEDB) version in the OS 2003 box is 2000.86.3959.00 and in the 64 bit R2, it is 6.01.7600.16385.

But now the 2003 box is able to connect to SQL...

Ben,

the application machine (OS 2003 32 bit) and the SQL Server machine(64 bit R2) are hosted in separate boxes

But when you have to do a point in time recovery, if I move the TL backup that was done to the Legato's store, will it recognize the sequence, then,...

backupset has it. Thank you.

I got you.

Is there any standards in which normalization can be double checked/audited-? That will almost have to be a totally manual effort by a 3rd party, not? I...

Jeff & Jason

You've convinced me; how do you check what is the status in this regard for all the databases, so I Can make sure none are vulnerable by prior...

but the counters will give IO for all CRUD operations going on, including the backup, and hence may not be reflective of the backup?

OK. I will make a case for that. Is there a link on standards that you can think that is related to this?

How can I check if this or any...

>>If code is hitting your database from the application and is not in proc form, then profiler would be the better bet.

Can you filter in profiler by tablename ( I...

Paul,

Do you have a link for Kimball's star-schema that you refer to, for OLAPs?