Visual Database Tools Usage Considerations

The following issues may affect your usage of the Visual Database Tools.

Saving Queries

To save queries designed in Visual Database Tools Query Designer, you must use SQL Query Analyzer.

To save queries designed in Query Designer

1. Design the query.
   
   
2. In the SQL Pane, select the query statements, right-click, and then click Copy.
   
   
3. In SQL Server Enterprise Manager, on the Tools menu, click SQL Query Analyzer.
   
   
4. Right-click in the Query window of SQL Query Analyzer, and click Paste.
   
   
5. On the File menu, click Save As to save the query.

Note  Although Query Designer provides menu options for saving, these options are disabled.

For more information about SQL Query Analyzer, see the Overview of SQL Query Analyzer.

OLE DB Provider

The Microsoft OLE DB Provider for SQL Server is implemented as a dynamic link library (DLL) on the client machine and a set of stored procedures on the server.  Unless both parts are installed, the OLE DB provider will not function correctly.

• Sqloledb.dll is the DLL.
  
  
• Running Instcat.sql installs the stored procedures.

If you install a newer version of Sqloledb.dll, but do not install Instcat.sql on each SQL Server machine running OLE DB, some OLE DB functions will return incorrect results.