Look outside the jungle, all answer must be just depending on each person {:-(

Sorry but your explanation is incompatible with the answer.

Hi,

The current compatibility level is 90.

Msg 209, Level 16, State 1, Line 1

Ambiguous column name 'PlanEnt'.

This is my check....

I try with SQL 2005 and that works perfectly.

It's normal because of multi-choice.

You must compute from the total for each individual choice.

remove your identity column output before the import operation

Yes it's no sense for a DB owner but in a database you are some other user and you can specify different right for each, therefore it's easier with the...

I think you need to create a batch and execute them after the installation.

If you have not other user group as the default (administrators,Users,...) It's already possible to create the login on the groups.

Which tools you use to create your file?

You must be carrefull with the cursor, In fact the performance can degrade if you use cursor frequently.

For me each transaction is independent therefore you must check each and rollback only the transaction failed.

Use a cursor :

SET NOCOUNT ON

DECLARE @vendor_id int, @vendor_name nvarchar(50),

@message varchar(80), @product nvarchar(50)

PRINT '-------- Vendor Products Report --------'

DECLARE vendor_cursor CURSOR FOR

SELECT VendorID, Name

FROM Purchasing.Vendor

WHERE PreferredVendorStatus = 1

ORDER...

You can try to use System.Data.SqlClient.SqlTransaction object and execute all sp into the same transaction context.

If you catch an error you can rollback all change into the transaction context.

You can use the System.Diagnostics.Debug object to send value into output windows (or console object if you work with a console project).

Or you can filled in a datatable.