Progress
DataServer for
Microsoft SQL Server
Guide
Tuning Your Environment with the –Dsrv Startup Parameter
The DataServer (–Dsrv) startup parameter allows you to use special DataServer options to tune your environment. You pass these options as arguments to –Dsrv when connecting to a SQL Server™ database.
There are two versions of the syntax, as follows:
In this syntax:
Here is an example of how to use the CONNECT statement with the –Dsrv parameter:
Note that MAX_R is an abbreviation of MAX_ROWS. You can abbreviate option names as long as they identify parameters uniquely.
Both the syntax statements and the example show the use of the –Dsrv startup parameter in CONNECT statements. You can also specify –Dsrv options in a parameter file, on a program item command line, or in the Connection Parameters field in the Database Connect dialog box.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |