I dont know anything about CF, thanks for that! Definitely multiple resultsets is not always a good solution - just an idea to keep mind. In the app we're building...

Identity cols are often the subject of relentless debate. To me its like any other tool - use it properly and its great, abuse it and it hurts. I use...

SQL2K makes text columns much easier to manage - you can use an instead of trigger to handle the text directly when auditing.

Andy

Will try to look into when I have time - chasing a deadline this week!

Andy

You could also link the relevant SQL tables into Access and do the work from there. Access supports VBA, so most of what you can do in a VB app...

To do a server trace the easiest (its not hard, but will take some experimenting) way is to set up a trace in SQL Profiler, then save it as a...

Usually you'll want to capture user and host name. Host name is frequently wrong, a good example is Access if you set up a linked table on one machine then...

I think the restore with different name is mostly useful for making a copy of a db.

Andy

Take a look at the code in sp_renamedb - nothing too involved going on really, I'd go that way also.

Andy

Most common is a db maintenance plan that is set to repair errors. I know there was a bug in earlier versions (but not SP2 I thought) where sometimes the...

I agree it depends on the complexity. If you can generate in a few line of TSQL, do it. Once you get more complicated, better off to use an app....

Addendum - you can do it with an alias.

Andy

I dont 2.5 supports named instances. A major pain!

Andy

You could do a server side trace and log connect/disconnect events to a table, put a trigger on the table (or a job) to do your cleanup. Might do almost...

Isnt the problem with the row size, not some other issue? Try change the select * to select specific column names and see what happens.

Andy