Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How to connect to master..sysdatbases using VS 2005?

  
   Database Forums (Home) -> Connect RSS
Next:  Question on IDS 10 page size  
Author Message
William Johnston

External


Since: Jan 28, 2008
Posts: 1



(Msg. 1) Posted: Mon Jan 28, 2008 10:49 am
Post subject: How to connect to master..sysdatbases using VS 2005?
Archived from groups: microsoft>public>sqlserver>connect (more info?)
Hi,

Which login credentials should I use to connect to master..sysdatabases database using VS 2005?

Thanks,
William Johnston

 >> Stay informed about: How to connect to master..sysdatbases using VS 2005? 
Back to top
Login to vote
Ben Nevarez

External


Since: Jan 25, 2008
Posts: 25



(Msg. 2) Posted: Mon Jan 28, 2008 10:30 pm
Post subject: RE: How to connect to master..sysdatbases using VS 2005? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On SQL Server every login has access to master..sysdatabases. Basically, if
you are able to connect to SQL Sever you will be able to see sysdatabases.

Note that this could change if the VIEW ANY DATABASE permission (available
only in SQL Server 2005) have been denied or revoked to a specific user.

Hope this helps,

Ben Nevarez




"William Johnston" wrote:

>
> Hi,
>
> Which login credentials should I use to connect to master..sysdatabases database using VS 2005?
>
> Thanks,
> William Johnston
>
>

 >> Stay informed about: How to connect to master..sysdatbases using VS 2005? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Unable to connect to SQL Express 2005 from remote location - Hi. Hoping someone can help with this one. I've inherited a Machine running an App that is using Sql Express 2005. It mirrors a few other machine that are set up in a similar way. The only difference is, from what I can tell it has previously had MSDE...

problem to connect sql server 2005 from localhost (W2k3) - Hi ng! The facts: SQL Server 2005 is installed on a Windows 2003 server within a domain. Every XP-Clients can connect to SQL Server via ODBC without any problems. The problem From the localhost I cannot connect to SQL-Server, AND from 2 other W2K ..

Cannot connect to 64-bit SQL 2005 from a remote 32-bit com.. - I have 3 servers: computerA: 64-bit Windows 2003 Ent.Ed. SP2, with 64-bit SQL Server 2005 SP2 installed (let's say instance2005) computerB: 32-bit Windows 2003 Ent.Ed.SP1 with an MSDE 2000 SP3 computerC: 32-bit Windows 2003 Ent.Ed.SP2 does not have any....

querying a table in Master as a semaphore - We have a production database and a test database on different servers, but with the same name, and we want our programs to be able to tell which is which, so we created a table in Master on the production server only. It oughta be really easy to..

Can't Connect -
   Database Forums (Home) -> Connect All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]