Sep 29, 2008 · How can I get the list of available databases on a SQL Server instance? I'm planning to make a list of them in a combo box in VB.NET.

21 I want to get a list of all of the user databases from an mssql server instance. What's the best way to do this? I know I can select from sys.databases, but I don't see any way to filter out system …

Is it possible to list information about the files (MDF/LDF) of all databases on an SQL Server? I'd like to get a list showing which database is using what files on the local disk. What I tried:...

May 25, 2010 · How can I get all the database names in a sql server instance using tsql? Asked 15 years, 6 months ago Modified 3 years, 2 months ago Viewed 109k times

Aug 13, 2011 · 289 I would like to write a query on a sql 2008 that will report all the users that have access to a specific database, or objects within the database such as tables, views, and stored …

Jan 18, 2010 · Replace by -U username -P password for SQL Server authentication. -S SERVER\INSTANCE: The instance of SQL Server to which to connect. If you don't know the name …

As I know I can get the databases from SQL Server using sys.databases, however it's listing offline databases also. I keep checking for a flag which shows database online/offline status.

Sep 18, 2013 · 108 I am going to get the list of all users, including Windows users and 'sa', who have access to a particular database in MS SQL Server.

I am looking for T-SQL code to list all tables in all databases in SQL Server (at least in SS2005 and SS2008; would be nice to also apply to SS2000). The catch, however, is that I would like a single

Feb 25, 2016 · I need to pull out the list of stored procedures which are available in my instance. I used the following T-SQL statement to get the stored procedures in a given database. select * from …