| **Navigation:**  SQL Drivers > MSSQL Accelerator >====== MSSQL Accelerator SQL Import Wizard--Login Dialog ====== | [[mssql accelerator overview.htm|{{btn_prev_n.gif|Previous page}}]][[coming future.htm|{{btn_home_n.gif|Return to chapter overview}}]][[mssql accelerator sql import wizard  import list dialog.htm|{{btn_next_n.gif|Next page}}]] |
|  ||

Clarion's Dictionary Editor Import Wizard lets you import MSSQL table definitions into your Clarion Data Dictionary. When you select the MSSQL Accelerator from the driver drop-down list, the Import Wizard opens the **Login/Connection**** **dialog. The **Login/Connection**** **dialog collects the connection information for the MSSQL database.

{{notebox.jpg|NoteBox.jpg}}

**If you are using a Trusted Connection (Integrated NT Security), you must establish a connection to the NT workstation running the MSSQL Server before you can connect to the MSSQL database and import table definitions. You can verify your connection by running the MSSQL ISQL_w Server utility installed with your MSSQL Client software.**

Fill in the following fields in the **Login/Connection**** **dialog:

| **Servername** | Select the workstation running the MSSQL database to import from. If the **Servername **list is empty, you may type in the name. See your DBA or network administrator for information on how the server is specified. |
| **Username** | For Standard Security, type your MSSQL Username. For Trusted Security (Integrated NT Security) no Username is required. See your server documentation or your DBA for information on applicable Usernames and security methods. |
| **Password** | For Standard Security, type your MSSQL Password. For Trusted Security (Integrated NT Security) no Password is required. See your server documentation or your DBA for information on applicable Passwords and security methods. |
| **Database** | Select the MSSQL database that contains the tables or views to import. If the **Database **list is empty, you may type in the name. See your server documentation or your DBA for information on database names. |
| **Filter** | Optionally, provide a filter expression to limit the list of tables and views to import. The filter expression queries the dbo.sysobjects table. The filter expression is limited to 1024 characters in length.**Tip: The filter is case sensitive, so type your filter value accordingly.** |

Following is a list of the column names (and their Clarion datatypes) you can reference in your filter expression. Generally, filtering on MSSQL system tables requires not only an intimate knowledge of the MSSQL system tables, but also of the MSSQL stored procedures. For example, to filter on table owner:

**uid = user_id('DBO')**

See your SQL server documentation for information on the MSSQL system tables and stored procedures.

| name | CSTRING(31) |
| id | LONG |
| uid | SHORT |
| type | STRING(2) |
| userstat | SHORT |
| sysstat | SHORT |
| indexdel | SHORT |
| schema_ver | SHORT |
| refdate | STRING(8) |
| crdate | STRING(8) |
| version | LONG |
| deltrig | LONG |
| instrig | LONG |
| updtrig | LONG |
| seltrig | LONG |
| category | LONG |
| cache | SHORT |

| **Next >** | Press this button to open the Import Wizard's **Import List **dialog. |