Yeah, this could...

The With IGNORE_DUP_KEY only ignores duplicates on insert operations. From BOL:

IGNORE_DUP_KEY = { ON | OFF }

Specifies the error response to duplicate key values in a multiple-row insert...

Move them as well.

Seriously I am not sure what you are really asking. Do you want to know if you should upgrade from SQL 2000? What you should...

You can immediately follow your first query with Select @@ROWCOUNT which returns the # of rows returned by the previous statement.

There is no "SELECT" trigger. You can have triggers on Insert, Update, and Delete. The only way I know of to audit selects is to set up a...

Attached is a report that uses ADventureWorks and shows how to use the CountRows function. You will need to unzip it and then you can open it in BIDS.

I assume this will work on a server as it works on my PC. Right-Click on My Computer -> Properties and on mine it says Intel Core 2 CPU.

Remember...

The reasons you give are why I avoid granting direct table access whenever possible. I typically only grant access to the database through stored procedures as I can control...

You want to use the CountRows function. If my report is Employees By Department and my group is named department then in the group footer I would use CountRows(Department)...

There are no indexes created on Foreign Keys by default. Now, odds are you WILL want to have indexes that include foreign key columns. It really depends on...

You would need to duplicate the filter on the grand total.

Another option may be to create a calculated column in your dataset that does the filtering.

Executing your final statement will return the value. Now if you are talking about running this in a loop you need a table variable to store the results and...

You will want to use a derived table in the FROM clause that gets the pertinent information from the episodes table in place of the episodes table. In this...

Looks good to me. By doing it this way the trace definition remains available and you can run it whenever you need.

You can check the traces that are defined...

Can you please explain what you expect for results from the test data you provided?

What is the ultimate goal? Do you want to see balance remaining? I am...