Troubleshooting Linked Servers in SQL Server 2005 (3/5/2008)
Troubleshooting Linked Servers in SQL Server 2005
If you have problems with SQL Server 2005 linked servers, review this troubleshooting checklist
to find potential solutions.
1. Insta...
Working with Linked Servers (4/27/2004)
Working with Linked Servers
by Bill Wunder
Linked servers allow you to query virtually any OLE DB data source from T-SQL running on a SQL Server 2000 creating a tremendous backdrop fo...
SQL Server 2005 Linked Servers Optimization Tips (11/19/2008)
SQL Server 2005 Linked Servers Optimization Tips
Try to avoid using distribution transaction or minimize it using.
Because distribution transactions incur more overhead than general transacti...
Troubleshooting Distributed Queries Procedures (4/26/2006)
Troubleshooting Distributed Queries Procedures
SQL Server supports the following thirteen distributed queries procedures:
- sp_addlinkedserver - sp_indexes - sp_addlinkedsrvlogin - sp_linkedser...
Troubleshooting Linked Servers (5/19/2004)
Troubleshooting Linked Servers
If you have problems with linked servers, review this troubleshooting checklist to find potential solutions.
1. Check that you use the latest SQL Server service ...
Known SQL Server service packs problems (8/17/2005)
Known SQL Server service packs problems
Usually SQL Server service pack fixes all known bugs, but sometimes it can produce new bugs, which fixed by next service pack, and so on. In this article, y...
Linked Servers Optimization Tips (5/12/2004)
Linked Servers Optimization Tips
When you create a SQL Server linked server, use 'Microsoft OLE DB Provider for SQL Server' instead of 'Microsoft OLE DB Provider for ODBC'. The OLE DB Provider f...
Tips for using SQL Server 2008 Distributed Queries (7/14/2010)
Tips for using SQL Server 2008 Distributed Queries
Try to avoid using distribution queries or minimize it using.
Because distribution transactions incur more overhead than general transactions...
Troubleshooting SQL Server 2005 Management Studio (4/16/2008)
Troubleshooting SQL Server 2005 Management Studio
If you have problems with SQL Server 2005 Management Studio, review this troubleshooting checklist
to find potential solutions.
1. Insta...
Troubleshooting SQL Server Command Prompt Utilities (5/25/2005)
Troubleshooting SQL Server Command Prompt Utilities
If you have problems with SQL Server command prompt utilities, review this troubleshooting checklist to find potential solutions. This article c...