In explination it is "Number of transactions started for the database."

It does not include Select as it does not cuase data changes.

But note I have seen some items throw weird...

Yeah, they really are pushing for you to use WIndows Authentication for optimal security.

Yeah using proper casing the string would be better. Thanks for the input.

Well it can actually depend on yuor version of SQL and some settings I forget. If you store as a string and compare to a string SQL in most cases...

It all depends on your queries and your data. Sometimes a person will autogen (IDENTITY) a value for the primary key to use in relationships but a real world key...

Here are a few others as asked for.

1. -1

This trace flag sets trace flags for all client connections, rather than for a single client connection. Is used only when setting...

We experimented with it and found it added a bit of a load to our systems but never got around to playing with the options to see if we could...

Or simply wright your trigger in a method that is completely reusable then you can do something like so.

Suppose I have a column in every table called ModCol for the...

Oops sorry mistook your question for the wrong intent. I do myself usually right for LEFT JOINS simple because it is easier for me to visualize.

For best performance and security use SPs for updates, inserts, deletes, etc.

Generally found ADO Client sider cursor for Connection cursor type to be fastest but should test both server side...

Right versuses left is nothing more than choice of table reference order and which needs all the data. In this case table 2s data should all be there but those from 1...

DO you have any commits in your SP as everything should work or fail.

WHat is the application written in and can you change to ADO easily (or with help).

Without having data to test with I can only shoot a bit here but this should work better simple because it replaces the exists which are you primary reason for...

The syntax is strictly

IF UPDATE(colname)

You can check for multiple columns like so.

IF UPDATE(colname1) AND/OR UPDATE(colname2)

Or that that column was not in the update like so

IF NOT UPDATE(colname)

But those are the...

Besides

DATEADD ( hh , (DATEDIFF ( hh , GetDate(), GetUTCDate() )) , @dt_Date_Time )

will only deal with the current time difference between the values. Consider that Time Zones...