You use the combination of inserted and deleted. For an update both are populated. Inserted has what the record(s) looked like AFTER the update was applied, the deleted table has...

Probably the easiest way would be to select all your data into one or more parallel temp tables, then do the calculations from there.

Andy

Hi Wade,

The basic syntax (see BOL for more details) looks like this:

***********

create trigger u_testtable for update on testtable as

--comments/owner here

--always a good idea to include this

set nocount on

select f1, f2...

You can increase the command timeout in ADO, but that's usually a bandaid for bad query plans. The views in themselves aren't bad, just have to look at how you...

I removed the duplicate postings you mentioned.

Why would your procs change so often? And in what way do they change?

Andy

How much data do you have? Snapshotting live with SQL is tricky, can create a ton of blocking since it locks the db. SQL2K offers a concurrent option to avoid...

Yes, in profiler there is an option to save to a table. Very handy.

You can modify a stored procedure to auto start to enable your trace. Or have a job...

In SQL2K support for dropping a column is built in, allowing you to easily use the method Abdul mentioned. It's interesting, but can I ask why you need to do...

The problem is while a user will be able to connect, essentially they will have no permissions - this because the id in sysxlogins in master doesn't match the uid...

You might take a look at patindex. The best implementation I've seen is in the VB Script regexp library, you'd have to use the sp_oacreate series of procs, not fun,...

Glad it helped!

Andy

/3GB /PAE

Andy

Nope. You can either apply a where clause to the view when you use it in a select, or use a function to do about the same, or you can...

I generate a change script using SQL Compare.

Andy

Robert, we'll take a look at it. Im not sure you'd be able to keep with the volume though! Seriously, we'll put it in on the agenda for discussion.

Andy