Try using a SQL login and password.

Andy

Steve - have you tried comparing your test with one where the table doesn't have identity column? Or maybe uses unique identifier? I'd like to see those results!

Andy

With SQL2K Scope_Identity() solves those issues - I agree it was a pain and a MAJOR source of bugs if someone added a trigger that inserted to another table with...

Andy - Im sure other readers would be interested in looking at your proc if you wouldn't mind adding to our script library.

Bill - interesting idea. Try dbo.backupfile in msdb....

I dont think you have to use MSMQ - dont you have the option to use tables instead?

Andy

I like Brians list, I would add Professional SQL 2000 by Rob Viera. Havent read Admin 911 book, though I've seen some of the authors other work and he seems...

I've had a demo cd here for months that I never got around to of Commerce Server. I dont know that it would place heavier demands on your SQL box...

You'll probably want to use a text column. Are you including formatting chars in your char count? Normally you can get about 8k bytes per record as long as you're...

Interesting...just never tried it I guess! I will look some, be nice to find a way.

Andy

Not sure I understand - why cant you use the single attach? Once a db is detached the log files are junk - all open transactions are completed before you...

Glad we could help a little!

Andy

No problem at all! We don't get enough DMO topics, was nice to have one!

Andy

Steve has great taste in recommending suggestions! You'll be better off doing your analysis from a table, but Profiler does support some interesting grouping options you might want to explore...

I'd bet on the space too. I've got one box where I have to watch the space more than I'd like, doing some of the larger db's takes some juggling....

If Im going to use dynamic sql it will be on the client. The string handling tools and development environment are better (to me anyway!). I agree that hard coded...