Thanks for the response Roy.

_UB

Thanks for the articles... I need to look into this further.

Gsquared,

Thanks for the informative article.

One question though. My question is to know if there is any advantage of one method over the other. Or is it just preference (...I say...

Do you mean Best Practices?

Thanks. I'll try to give as much info as possible, if you need more, please let me know.

We have Sql Server 2005 server with a database running in 80 compatibility...

Exactly, that's the problem I am trying to solve. Different client side have different settings (JDBC, ADO.NET, ODBC... OleDB), so my goal is to try to use the SQL Server...

From what I gathered, looks like the rest are not stored at all, but just inherited. Either from Global database settings or Session settings or inline settings.

hmmmm......

OBJECTPROPERTY has a couple...

SELECT OBJECTPROPERTY(OBJECT_ID('Procedure_Name'), 'ExecIsQuotedIdentOn')

SELECT OBJECTPROPERTY(OBJECT_ID('Procedure_Name'), 'ExecIsAnsiNullsOn')

where are the rest... are they even stored for each Stored Proc.....at all?

Thankyou GSquared. I always greatly appreciate your response to my posts.

I'll be sure to read your articles.

_UB

Yes. I agree. I read the same for INSTEAD OF triggers.

My earlier comment was based on what I read on AFTER triggers. I guess my comment did not convey that...

Looks like UPDATE TRIGGER is the only way to perform UPDATES on the 'Date_modified' column.

There is an entry in the Microsoft Connect site already on this. For people who are...

Matt,

I agree with the INSTEAD OF TRIGGERS, that's what I am gonna write my triggers in. Not all, but only some TRIGGER that do more than just auditing.

From what I...

This setting is :

SELECT name, Is_Recursive_Triggers_On FROM sys.databases

Looks like the default is OFF

Thanks for the response.

No matter which column is updated, 'Date_Modified' needs to be updated. So, looks like INSTEAD OF Triggers might be a easier route.

thanks,

_UB

Thanks for the response.

All our queries hit the DB directly, no Stored Procedures. (I tried to convince otherwise, but ....)

UPDATE queries only supply values to the main columns not the...