Hello,

I have a database that will need to be modified, i.e. adding columns, stored procedures, etc.

I can't create a backup as the database is live and will be continue to be updated with customer data.

My colleges what me to create the updates in code which I have done. However, my real problem is how do I know if the database has been updated and is current version.

I will not be updating the data that has been entered, only doing things like:
Alter [tableName] add Salary money null
create procedure dbo.insertPayment .....


example

if(currentVersion) then
'No need to update
Else
'Updates are available
'Add column
'Drop column
'create procedure
'etc

Is there any method that I could use to detect if the database is current or not.

I hope I have been clear on this.

Using VS 2005 and SQL Server 2005

Many thanks in advance,

Steve