Posted by Lyle H. Gray on 09/29/98 11:33

"Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in
news:XCYjf.22885$D13.17492@newssvr11.news.prodigy.com:

>> Any idea why some of these logins can't see the databases?
>
> I don't have a SQL 7 instance handy but I believe EM uses the
> HAS_DBACCESS function to show/hide databases any database listed by
> the query below should be listed and available to the user.
> Conversely, databases not returned by the query ought not to be listed
>
> SELECT
> name
> FROM master.dbo.sysdatabases
> WHERE has_dbaccess(name) = 1

Here I might have something.

When I execute this query from my own (SA) login, I get a full list of
the databases, as I would exepct. When I run it from one of the logins
in question, I get a list of the databases that that login should have
access to as a user, but I also get the following message:

ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 13 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

The process number would obviously change each time, but I expect that
what is happening is that the error stops Enterprise Manager from
displaying the database list.

I'll see if there's any information about this in the KB.

Thanks for the help,
Lyle

[Back to original message]