sure sp_blockinglocks is written alright? (can't find it in the books online)

probably

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q237398&

The "Cannot start transaction while in firehose mode" error occurs when an OLE-DB provider attempts to perform a join transaction with results pending and while not in an...

With enterprise manager you can create scheduled jobs for sql agent.

(management->Sql Agent->Jobs->Create)

Sql Agent then runs it at the specified time.

Perhaps this:

http://www.dbforums.com/archive/index.php/t-958605.html

Have you tried uninstalling and than reinstalling the client components tools of sql server?

You'll need a third party program.

Ortherwise you could try to script out all views, stored procedures and run a text-difference analyzer on it.

See DENY in the books online to prevent insert rights for a specific user.

not sure but this mentions ex_raise2

http://support.microsoft.com/kb/825225

solved in SP4

Does any ends of the distributed query involves an windows 2003 OS or XP SP2 ?

this should help you started:

http://www.sql-server-performance.com/query_execution_plan_analysis.asp

in addition a new article about indexes:

http://www.sqlservercentral.com/columnists/lPeysakhovich/indexcreationguidelines.asp

and the follup up discussion

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=163&messageid=119673&p=2

I guess the installer comes from which language edition you bought from Microsoft.

1)If this is for use in a TRIGGER, I must mention that the triggers fires only once per command/set. So if inserted contains more than 1 ai_id (like 1,2,3)you will...

Rewrote you query a little to use join syntax for readability+performance

Delete dbo.table_A

FROM dbo.table_A A /*SERVER A*/

INNER JOIN dbo.table_C C /*SERVER A*/

ON a.edfoid = C.edfoid

AND  a.IsLInk = convert(bit,0) /*in case of...

sp_prepexec is explained a bit here:

http://jtds.sourceforge.net/apiCursors.html

Normally used by Ado (since it uses cursors to retrieve data)

Normally it would be like

sp_prepare..

sp_execute.. parameter query

sp_execute..parameter query

sp_execute..parameter query

sp_execute..parameter query

sp_unprepare

A one time query doesn't...

Does it happen at set times? Perhaps a job, heavy querie, network congestion got in the way.

Is it reproducable (same parameters, ....)?

You can still increase the timeout of the command...

Perhaps this:

http://support.microsoft.com/kb/q230393/