sqlcmd -s <db server or instance> -q "exec sp_databases"
Examples:
sqlcmd -s localhost -q "exec sp_databases"
sqlcmd -s dbserver -u loginname -p password -q "exec sp_databases"
sqlcmd -s ./MSSQLSERVER -u loginname -p password -q "exec sp_databases"
2 comments:
I admire the valuable information you offer in your blog post. Keep up the good work.
Web Hosting Jaipur
You can also use free command line tool "SQLS*Plus" which is like an Oracle SQL*Plus for SQL Server.
To show all database you just use command "show dbs".
sqlsplus works with SQL Server 2008, 2005 and 2000 and very flexible with variables (&, &&), data formatting (set lines size, pagesize, etc), etc - much better alternative to sqlcmd or isql
I found sqlsplus at http://www.sqlsplus.com
Post a Comment