Hi Gail,

I mean table that contains dropped column(s) and/or table that contains modified column(s) (e.g. to increase its...

Hi Matt,

Thank's for your quick answer.

Let's say I really need to dynamically detect these tables : "... tables that have "dropped columns" or tables that uses more row space than...

Hi Erland,

Stored procedures behaves the same.

I just noticed that when I look at the proterties of these views (in SSMS) being connected as a sysadmin user, the views appears not...

Thank's a lot for this answer.

Have a nice day.

Carl

Solved! I finally found that launching SSIS with the RUN AS ADMINISTRATOR enabled me to connect with the rigth credentials.

Weird that this behavior of SSRS is different from the one...

Hello Grant,

No, I won't do a full backup of the same database every 2 minutes.

I will check every two minutes if there is a database to backup. 99.9% of the...

Hi Bru,

I will call a remote stored procedure, using a linked server. This procedure will give me the database name to backup.

Than I will do a execute ('BACKUP DATABASE '+@name...').

This...

This is what I expected.

Thank's a lot Bru and I hope you have a nice day.

Regards.

Carl

Hi Jason,

We have solved our problem by adding a test on @@TRANCOUNT and raising an error when <> 0 at the end of each script we execute.

"Auto commit" on close...

Ok, thank's Kenneth.

Have a nice week.

Carl

Hi understand your point Kenneth but in the context of script execution (using the -i option), both tools should warn the end user in this case. At least we should...

Hi Andre,

I like the idea of adding some "generic" code to each conversion script.

Using @@TRANCOUNT is a good idea in this case. 🙂

Best regards.

Carl

Hello Andre,

Will the use of a TRY/CATCH block help me to detect a missing COMMIT TRAN in a script?

From what I tested, the answer is no. But maybe a missed...

Hello Andre,

Yes, good idea.

It is an approach that is very different from what is done here rigth now but it could help in this particular case.

Best regards.

Carl

What do you mean by "here" ("Missing here")?

Since sqlcmd does not return an error in our case, I don't think your solution will work.

Best regards.

Carl