Make use of COLUMNS_UPDATED()

http://msdn.microsoft.com/en-us/library/ms186329(SQL.90).aspx

MJ

During the installation, there is no opportunity to select the database instance before the setup program runs the checks and so therefore the installer must assume that the installation will...

Is this resolved?

MJ

Is this resolved?

Mj

Try scheduling a agent job which capture ping server results to a table and see if it has any time out entries when the connection timeouts an application side.

MJ

I can easily copy defaults property by making use of copy sql server objects task in dts.

http://msdn.microsoft.com/en-us/library/aa933510(SQL.80).aspx

MJ

DO you really want to make use of encryption? If not then recreate your endpoints with encryption=DISABLED.

MJ

Is it resolved? Whats the data type of the source column tht is causing problem in excel?

MJ

Thanks for sharing the solution.

Manu

Is this resolved?

MJ

Try using sp_dbremove for that database.

http://msdn.microsoft.com/en-us/library/ms187980.aspx

MJ

I think reconfiguring is an way out here.

MJ

Then you dont need that second log file for this database.

MJ

Try running profiler with filter in textdata for this table.

MJ

Use xp_cmdshell for running the followng command:

DTSRun /S "server name" /N "dts name" /W "0" /E

MJ