To display information about Adaptive Server’s limits:
dbcc serverlimits includes the size of your server’s logical page size in its output. For example, enter:
dbcc serverlimits
Search for the string “logical page size” in the error log.
The global variable @@maxpagesize displays the server’s logical page size. At the isql prompt, issue:
select @@maxpage size ----------- 8192
