I have a SQL user on a 2K server that has an invalid default database
(dbname in syslogins is NULL).  I have both Enterprise Manager (EM) and
SQL Studio Management Studio (SSMS) installed.  I can set this attribute
in EM, however when I try to set it in SSMS I receive the following
error message:

"Cannot show requested dialog.  Property DefaultDatabase is not
available for Login '[login_name]'.  This property may not exist for
this object, or may not be retrievable due to insufficient access
rights.  (Microsoft.SqlServer.Smo)"

I can set the default database using sp_defaultdb using either EM
(really Query Analyzer) or SSMS.

Versions:

Enterprise Manager: v8.0
SQL Server Management Studio: v9.00.1399.00

Bill Curnow (" BillCurnow"@newsgroups.nospam) writes:
If you haven't, file a bug on http://lab.msdn.microsoft.com/ProductFeedback/

Erland Sommarskog wrote:

I was hoping to have someone confirm my findings before I filed the bug
report, but it looks like I'm not going to get that luxury.  Filing...

Bill Curnow (" BillCurnow"@newsgroups.nospam) writes:
Nah, the hour was late, and your scenario looked pretty clear, so I
had confidence that you were right and Mgmt Studio was wrong.

DTS Designer error
ToString UDT
how do you edit query results in results pane of Management Studio
problem with SQL 2000 Enterprise Manager display
Problem Viewing SQL2000 Tables Definition chm