What you should do is create An instead Of trigger for update, so when you try to update the view, depending of what records you try to update, the trigger...

Well i think that is 8 kb per each io write operation. I couldn't find any help yet.

And what about StandBy Servers?

Check that the sql service account can't still start the services.

Any difference within the 3 instances? Wich one did you installed last?

Wich SQL version? Please post more info.

The SQL Server Service account must be member of the Local Administrator Group of your Pc. All the locals administrators map directly to the Sysadmin role in SQL Server.

For example,...

No you can´t not. Maybe you should buy Log Explorer or check for another log tool.

I Think there is not. With profiler you could check the queries and filter some users. But it's not the same.

I don't think so. Maybe you will have to recreate the profiles in sql server. After upgrading, post the comment to what happend so we can learn a bit more.

...

If you can't backup the databases ten you should attach them once you reinstall sql. After that open the DTS packages from the files.

Do you have the data and log files in the disk (.mdf and .ldf)? If you have them after you reinstall SQL you can attach the database with those files.

...

You connect with the COM component ADO. You can build a COM dll an use it with the application.

SQL manages the deadlocks by it self. Kills one of the locking transaction. It decides this by the most cost significant transactions and the most time running transaction.

So there's nothing...

A thread of SQL saves the transactions in buffer cache to the transaction Log(log file on disk). this is automatic, an SQL decide when to execute the thread depending on...