Thanks for your response Chris.  Actually in SQL 2000 (on w2k03), it is my understanding that you no longer run comclust.  You actually setup DTC during the install.

Good news is...

prezader, thanks for the reply.

Another thought, does anyone have any good links to performance comparisons between 7.0 and 2000? We do mainly batch processing, and if SQL 2000 could perform better on bulk...

Shas3 - I am curious. Our prodution SQL 7.0 server is clustered active/passive. Why do you say 2000 would be a good move for a clustered production server?...

Thanks to all for the feedback!

alzdba - some good feedback, and I agree there are definitely politics involved.

I should note that it has already been decided that our cheapest tco...

I should have also mentioned we are using Advanced Server 2000.

Thanks.

Thanks to everyone for your feedback. This was a big help!

ajroney

Thank you to everyone who responded to this topic. It seems the root of my problem was that I was trying to restore master "WITH MOVE" to a new...

Hmmmmm. Using MSDB to run the restore script still didn't work. I do want to force a restore over the existing MASTER DB, however, I removed the replace...

Thanks for the replies.

I did try to setup a user - "Salary User", and create a table with SalaryUser as the owner. I then went in (through EM) and...

thanks for the response Steve. I should have also noted that I am using 7.0.

I wanted to thank all who responded. The links and the info provided were great.

I didn't mention, but I am working with bank software, so this concurrency issue is...

The root of the dynamic SQL comes from the avoidance or concurrency.

The reason for the dynamic sql mandate comes for the fact that mulitple users may be updating distinct attributes...

PS - I should also note that table object level security in the application I am working with is not an issue. Our users connecting the database usually have...

Thanks bkelley. I checked out the sites, and got some good ideas on how to avoid using dynamic sql. However, I am still unable to find hard evidence...