Thank you. We'll look into this further. It at least will help us move in the right direction.

The manual edits are what we are trying to minimize, was thinking there might be some way to loop thru the table.fields, but if so, is there equivalent way to...

I did find the following link/post, that appears to describe a similar situation, and solves with a stored procedure. Didn't know if there were other alternative solutions:

Hi Steve,

Sorry for any confusion. I agree IDENTITY has no relation to primary keys. I can't think of a simple explanation...let's say you have a CUSTOMERS entity...

Thank you to all that replied...I think the execution context suggestion is probably the way to go in this situation. We will give it a try.

For Question 1, UserDev is dbo in development, but only has DB_DATAREADER and DB_DATAWRITER in QA server. Thats why I was wondering if the stored procedure needed to some...

Thank you. Well, now it appears we can do and Add/Remove because I see it there (our clients are installed via an MSI installation object on our network). When I...

Jeff,

Thanks for the detailed reply..this is a big help!!

Randy

Hi Jeff,

This is a largely 'from scratch effort', so currently no triggers in place.

Thats good news as I don't need Rpting Svcs. Maybe I'm missing something obvious, but Add/Remove Programs only shows a 'BIDS' workstation component for SQL2005 which lumps BIDS and Rpting...

Our client tools were originally installed via a pre-built MSI installation object. In our Program Files Group within item MS SQL Server 2005, we have 'Analysis Services', 'Configuration Tools', 'Performance...