Microsoft KB Archive/200796

= PRB: SQL Enterprise Manager Requires Uppercase for Linked Server Name =

Article ID: 200796

Article Last Modified on 11/21/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



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.

Additional query words: kbDSupport SEM ent man entman upper lower case oledb link linkserver linkedserver

Keywords: kbprb KB200796

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.