Is there anyway of researching the following (quoted from you) any further?

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{61738644-F196-11D0-9953-00C04FD919C1}

to the user...

You've said NOTHING about transaction volume. That seems to be the key to making this change and measuring the results. Nothing is as good as testing the changes...

aren't you already running a stored procedure under your osql -L? Just add these lines into the sproc.

OK. Maybe I'm misinterpreting the original mission here: The UPDATE statement is (copied from above):

--------------

update FSA_EXPORT_TEMP WITH (ROWLOCK)

set trading_partner = 'XXX'

where reporting_date = @reporting_date

and fsa_le = @fsa_le

and transfer_le...

Could it be the rewriting of a clustered index because of exceeding fill? The rewriting would cause heavy disk i/o and perhaps 'pause' the application until the index was...

Not all of us wearing DBA hats have always been DBAs.

Matey - easy is relative.

1. What prompted the removal of the table to begin with? A business requirement? An effort to speed up processing? Redesigning the...

Don't forget that the minute you go to update the database, you will corrupt any 'last-used' date stamp.

isn't there already a built-in round function? using what you already know for the precision, can't you specify that value in the round function?

One solution: build a table that will map customer 'A' to all the appropriate phone or cust ids. Then use that relationship coding to summarize in the way...

How big are the tables? How fast does the code have to run? What if you 'counted' the number of quarters that had a grade and then stored...

IF you insist on developing everything in both SQL Server and Access, aren't you really delaying the switching over to SQL Server? Make your life simpler - solve problems...

Hi Sherry -

Most of the security is managed within the application. We use SQL Server validation rather than incorporating the validation within Windows - in part because we have...

Seems to me that you are being ambitious, sending 19 parameters. How do you verify that the 19 values are all valid, prior to sending them to the SP?...

Seems to me that turning on underlying triggers will keep sql2k and sql2k5 consistent. Doesn't strike me nearly as serious as the fact that 64 bit sql2k5 doesn't support...