PRB: SQL Enterprise Manager Requires Uppercase for Linked Server Name (200796)


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q200796

SYMPTOMS

When using SQL Enterprise Manager to add a new linked server for distributed queries, you are required to use only uppercase characters for the linked server name. Any lowercase character you type will be entered as an uppercase character.

WORKAROUND

To work around this problem, use the sp_addlinkedserver stored procedure to create a linked server. This way, you can use both uppercase and lowercase characters for your linked server name and Enterprise Manager will then show the name of your linked server without converting it to all uppercase characters.

MORE INFORMATION

Microsoft SQL Server versions 7.0 and 2000 provide the ability to perform queries against OLE DB providers. This is done by using the OpenQuery or OpenRowset Transact-SQL functions or by using a query with four-part names including a linked server name.

You can use the sp_addlinkedserver stored procedure or SQL Enterprise Manager to set up a linked server.

For more details on setting up and using Distributed Queries, see the sp_addlinkedserver, OpenQuery, OpenRowset, and related topics in the SQL Server 7.0 Books Online.
Modification Type:MajorLast Reviewed:11/21/2003
Keywords:kbprb KB200796
©2003 Microsoft Corporation. All rights reserved.