I have a linked server and I'm having a tough time referencing it properly.<BR><BR>If I open SQL Management Studio and run a query on the server itself it works great.<BR><BR>However, I want to take ...

Distributed transactions are one of the more powerful and important functions within SQL Server. A distributed transaction is just like any other transaction within the SQL Server database, with a ...

So you decided to set up log shipping in order to establish a failover server, but what's next? Log shipping only takes care of keeping a user database in sync from one server to the other. In the ...

I've got a products table that uses a next product id to allow versioning of products, e.g.:ID Model List NextID 1 A 1.00 2 2 A 2.00 3 3 B 2.50 4 4 B 3.00 NULLWhat would the best way of returning the ...