Probably, I did not make it clear. The jobs I would like to handle are on the Windows level.

Run sp_helpserver

Nija: you confused me.

Could you explain how dbcc inputbuffer affects modification of a parent table, and fire triggers?

Many thanks

How about something like: 

SELECT MAX(startdate), MemberNbr FROM MemberNbr GROUP BY MemberNbr HAVING A <> 0

You do not have any criterion in search. You do not need your data displayed in order. So, you may not need any index in your table.

Personally, I think it is not logically feasible to audit activities on parent levels from a child level.

How about

SELECT MAX(startdate), MemberNbr FROM MemberNbr GROUP BY MemberNbr

Could you tell me where I could go to the SQLDebugger security?

As what you wrote, @@ERROR only returns the error number of the last transaction. If you would like to be sure you had better include a piece of code something...

Could you have differential backup?

Remember, it is okay to restore a user database with old service pack to a server with a later service pack. You may have an error if you do it...

msdb..backupset

You may drop index before bulk-inserting data, then rebuild the index. FillFactor may also be changed to other value, depending on the percentage of import data next time.

It is...

Run sp_lock to see which objects are locked. You got to be very careful when manipulating large tables. I mean check your queries carefully before executing them.

Could you use

SELECT * FROM TableA CROSS JOIN TableB