oops..

Forgot the Commit Tran at the end......You get the essence of it...

Begin Try

Begin Tran

Alter table Table1

alter column column1 varchar(max) not null

End Try

Begin Catch

Rollback

End Catch

This works.

If you are worried, try it in Development. You do have backups dont...

In TABLE C does the combination B_ID and A_ID need to exist on table B ?

As a general rule, FK's should not impact the way you query the DB. It...

Thank you for all the possible solutions. I will try them all out to see which is more efficient.

thanks

Michael.

There are currently 8 Datetime columns.

If there is no easy way to do this, I am planning to calculate the minimum datetime for every record as it is inserted/updated.

Michael.

You must be missing a Begin \ End block after an IF statement.

Can you post the Code ?

Difficult to give advice without it...

Thanks mate . much appreciated. I will try it in the morning.

cheers...

What is not working with this proc. It should still run in SQLServer 2005...

Use stored Procs to select data and have those procs write to an Audit table\log

I thought the answer has been given. The error happens during the execution of the dynamic sql !!!!!!!!!!

OK. This must be a joke. People who want to stand on a soap box should go to a political meeting or a revival meeting. This stuff does not belong in...

Could you provide more information on your transaction control. Do you have explicit transaction?. Do all the Insert\delete happen under the same process id? Also, did you look at BOL under...

You may create a SP to perform this. Then grant execute access to the specific users.

Michael.

I cant believe they got it wrong as the correct answer. I have been doing it as in Answer B since SS2K came out and it is the correct way....

You cannot copy/move the DB files while they are attached to SqlServer. You will get a violation error.