So what formula did you come up it to figure out the saved space?

I'd like to personally applaud Farrell for getting off his training wheels and using a set based approach VS his old usual bulldozzer approach (even if he found this solution...

Alright, let us know how this turns out.  Can't offer more support at this point !?

Probabely because the bulk insert is executed in a different context.  That's the only explenation I can give.  However it's only a hunch and I have no proof to back...

Application =  "portfolio mgmt software"

Does it have a central datasource or does it use a local database?

Very simple way :

Add a column IsUpdated

SET rowcount 50

while @@rowcount > 0

begin

update dbo.table set IsUpdated = 1, YourCol = 'Whatever' WHERE IsUpdated = 0

end

SET rowcount 0

USE DbName

GO

DBCC UPDATEUSAGE(DbName)

exec dbo.sp_spaceused

You can also use the taskpad view of the database in EM.  You should get an idea of how much free space you now have.

Can we see the exact code you are using for xp_fileexists?

Normally only the application should be updated to reflect the new data source.  After that assuming all the permissions are set correctly, the aplication should be accessible to everyone.

How long did you expect it to take?

How long did it take when you did a test upgrade on a test server?

And I don't have any other suggestions besides profiler......

INSERT INTO Table(Field) SELECT CASE WHEN @Var1 > @Var2 THEN @Var1 ELSE @Var2 END AS Field

As far as I know, you cannot do this without resorting to dynamic sql.  Why do you want to do this?

I'll have to take you word on this one.  I have neer been confronted with that situation.  However it does seem to make a lot of sens

We need the DDL of the tables and view(s) involved.  Along with the DML of the insert statement.  The exact error message may also be helpfull.

TIA.

No need to brag about that !