Ars Technica

SQL Server: linked server connection drops, sp doesn't notice?

I don't know if we have a config incorrect or what. We have a stored procedure that does some selects to import data from tables and views on a linked SQL Server. Lately, every once in a while, the ...
Redmond Magazine

Laying the Groundwork for Microsoft SQL Server 2008

In-Depth Laying the Groundwork for Microsoft SQL Server 2008 Redmond's new database server is a complex product often running mission-critical apps. You can't afford to not get it right. By Josh Jones ...
Ars Technica

SQL Server, Linked Server and a Timeout

I have a problem I cannot figure out. I am trying to update 2 fields (InvoiceNumber and Invoicedate) in a table on a linked server ([CLAIMS].DB.dbo.MFrameEClaims) with data from a local table. The ...
Redmond Magazine

Laying the Groundwork for Microsoft SQL Server 2008

The SQL team in Redmond has made good on its promise to deliver more timely releases of SQL Server. Now that SQL Server 2008 is being released this month, it's time for you to do your homework and ...