BUG: SQL Admin. Displays Partial DB List if rowcount Is Active (124061)



The information in this article applies to:

  • Microsoft SQL Server 4.2x

This article was previously published under Q124061

SYMPTOMS

The Manage/Change Database... menu item of the SQL Administrator query window will only display a partial list of databases if a set rowcount command is active.

If you have issued a set rowcount command in a query window and when you click the Manage/Change Database... menu item, the number of databases listed will not exceed the rowcount limit.

For example, if a user executes,
   set rowcount 2
				
Then only two databases will be listed in the Manage/Change Databases... list of databases.

NOTE: This only affects the list of databases from the Manage/Change Database... menu item used to change the focus of the query window. Issuing set rowcount in the query window does not affect the other windows, such as the devices, databases, logins, remotes, or system windows.

WORKAROUND

Reset the rowcount to a number sufficient to list the databases, or change the focus of the query window with a use command:
   use pubs
   go
				

STATUS

Microsoft has confirmed this to be a problem in SQL Administrator version 4.2 for Windows and Windows NT. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Modification Type:MajorLast Reviewed:12/16/1999
Keywords:kbprogramming KB124061