SQL Server Enterprise Manager Properties (Advanced Tab)
Use this tab to view or specify the following options.
Options
Login time-out (seconds)
Specify the number of seconds to wait before the instance returns from a failed remote login attempt.
Query time-out (seconds)
Specify the number of seconds that must elapse during the processing of a remote query before the query times out. The default is 0, which allows an infinite wait.
Packet size (bytes)
Specify the size of the Tabular Data Stream (TDS) packets. The default size of TDS packets is 4 kilobytes (KB).
Perform translation for character data
Perform a translation of character data between different client and server code pages. This option only affects data stored in Microsoft® SQL Server™ char, varchar, and text columns.
Open the console tree to the last active node
Specify that upon startup, the console tree will open to the last previously active node in SQL Server Enterprise Manager.
Reset All
Reset all of the options on this tab.