Item name |
Required / Optional |
Use of Variables |
Description |
Remarks |
Hostname |
Required |
Only environment variables are available. |
Enter the host name of database. |
|
Port number |
Optional |
Only environment variables are available. |
Enter the port number of database.
The number defaults to 1433. |
|
Database name |
Optional |
Only environment variables are available. |
Enter the database name. |
|
Use Integrated Windows Authentication |
Optional |
Not available |
Select whether to use Integrated Windows Authentication to connect.
- [Checked]:
Use Integrated Windows Authentication to connect.
- [Not Checked]: (default)
Connect using SQL Server authentication.
|
- Displayed when either 'SQL Server 2008' or 'SQL Server 2005' is selected as [Type].
|
User name |
Required |
Only environment variables are available. |
Enter the user name. |
- Disabled if [Use Integrated Windows Authentication] is checked.
|
Password |
Optional |
Only environment variables are available. |
Enter the password. |
- Disabled if [Use Integrated Windows Authentication] is checked.
|
Item name |
Required / Optional |
Use of Variables |
Description |
Remarks |
Specify the number of tables in the list |
Optional |
Not available |
Select whether to limit the number of tables listed or not.
- [Checked]:(default)
limit the number of tables names listed.
- [Not Checked]:
Table names listed are not limited. Fetches all of the table names available.
|
|
Number of tables |
Optional |
Available |
Enter a number of tables listed.
|
-
Enabled when [Specify the number of tables in the list] is checked.
-
Defaults to 500 if omitted.Defaults to 500 if omitted, or if the value specified is invalid.
|
Specify the number of procedures in the list |
Optional |
Not available |
available Select whether to limit the number of procedures or not.
- [Checked]:(default)
limit the number of procedures listed.
- [Not Checked]:
Procedure names listed are not limited. Fetches all of the procedure names.
|
|
Number of procedures |
Optional |
Available |
limit the number of the procedures listed.
|
-
Enabled when [Specify the number of procedures in the list] is checked.
-
Defaults to 500 if omitted. Defaults to 500 if omitted, or if the value specified is invalid.
|