SqlServer 08: Query to list all databases in an instance?

sql-server sql-server-express sqlcmd
Dane O'Connor picture Dane O'Connor · Jan 18, 2010 · Viewed 64.1k times · Source

How do I list all the databases for a given sql server 08 instance using sqlcmd?

Answer

Heinzi picture Heinzi · Jan 18, 2010 
sqlcmd -E -S SERVER\INSTANCE -Q "sp_databases"

Related questions

How can I determine installed SQL Server instances and their versions?

I'm trying to determine what instances of sql server/sql express I have installed (either manually or programmatically) but all of the examples are telling me to run a SQL query to determine this which assumes I'm already connected to …

Read More
SQL Server after update trigger

I have a problem with this trigger. I would like it to update the requested information only to the row in question (the one I just updated) and not the entire table. CREATE TRIGGER [dbo].[after_update] ON [dbo].[MYTABLE] …

Read More
SQL Server Express CREATE DATABASE permission denied in database 'master'

After I change the option as UserInstance="False", then the error starts to happen. Because I want to use full-text search, the option change is required. BUT, it stopped to work. Is there any way to make it work again? …

Read More