PRB: SQL Enterprise Manager Requires Uppercase for Linked Server Name

• Microsoft SQL Server version 7.0

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 version 7.0 provides 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 : kbole SSrvAdmin SSrvEntMan SSrvStProc
Version : winnt:7.0
Platform : winnt
Issue type : kbprb