Re: How to I get a list of databases?
- From: Dave Navarro <dave@xxxxxxxxxxx>
- Date: Mon, 23 Jul 2007 17:46:40 -0500
But don't you have to have permission to access master.dbo.sysdatabases?
I am wondering because if I connect to my ISP's SQL server using
Enterprise Manager, EP will only show me the databases that I own or
have permission to access.
Since I don't have admin rights to their server, I'm wondering how EP
was able to deduce which databases I can access.
--Dave
In article <OYvBBwVzHHA.4928@xxxxxxxxxxxxxxxxxxxx>, reb01501
@NOyahoo.SPAMcom says...
Dave Navarro wrote:.
How can I get a list of databases in an SQL server that I have
permissions for?
You can get a list of databases by querying the master.dbo.sysdatabases
table. Depending on the version of SQL Server you are using, there are other
ways as well.
Then, to determine which ones you have permissions for, I guess you would
need to loop through the list of names and attempt to open a connection to
each one in turn, catching the error if it fails.
That's because ADOX is geared to work with a single database at a time: its
I have used ADOX to get a list of tables in a database, but I can't
find any sample ADOX code for getting a list of databases on a server
that I can access.
top-level object is the Catalog, i.e., database.
- Follow-Ups:
- Re: How to I get a list of databases?
- From: Bob Barrows [MVP]
- Re: How to I get a list of databases?
- References:
- How to I get a list of databases?
- From: Dave Navarro
- Re: How to I get a list of databases?
- From: Bob Barrows [MVP]
- How to I get a list of databases?
- Prev by Date: Re: How to I get a list of databases?
- Next by Date: Re: How to I get a list of databases?
- Previous by thread: Re: How to I get a list of databases?
- Next by thread: Re: How to I get a list of databases?
- Index(es):
Relevant Pages
|
