App roles arent my favorite. You still have to have the password embedded in the app.

Andy

DTS will work if you have SQL2K and use the move objects part. There are a couple ways to do it other than that. It's just data, so you can...

The logical inserted and deleted tables let you see the before/after image. Remember that these tables may hold 0 or more rows, the trigger fires once per transaction, not once...

Ok, you got me. I'll see if I have MSDE on a machine at home tonight, have to finish researching another issue anyway.

Andy

As far as I know it should still work. Did you have MSDE running?

Andy

Consider using bulk insert. You'd have to time it, but in some cases it may make sense to drop your indexes and add them back afterward.

Andy

Are you dropping the table each time?

Andy

Nothing simple. You can set up a bunch of int parameters based on what you think the max you'll ever need is and build your logic based around them. Or...

Your choices are to use a trigger or polling. With a trigger you could send the notification directly, or add a row (or more) to a table and have the...

Using a temp table isnt a bad way to go. You can do it easily using the insert...exec syntax. I think you can accomplish what you want more directly by...

I think I agree with Brian. Only caveat - sometimes a broad range of skills makes sense, sometimes you need to specialize - look at the medical market, GP's vs...

No, then you're really trying to do something a bit different. You can do it by building the sql and passing it to Exec(). In other words, the case will...

Not that I know how to do. Possibly at a very low level, either in SQL or part of the ODBC/OLEDB layer. Only other suggestion I have is to profile.

Andy

Generally columns of 8000 chars should be text columns, I'd say probably anything over 2000 even. SQL2K has the text in row option to offset the penalty you pay for...

Are you replicating anything? Transactions marked for replication have to be cleared by the log reader before they can be purged.

Andy