SQL Server query to find all current database names

by

Here is a query for showing all databases in one Sql engine

Select * from Sys.Databases

More Related Contents:

  1. incorrect syntax near keyword where [closed]
  2. nvarchar concatenation / index / nvarchar(max) inexplicable behavior
  3. How do I create a unique constraint that also allows nulls?
  4. How do I get list of all tables in a database using TSQL?
  5. Storing images in SQL Server?
  6. How to convert SQL Server’s timestamp column to datetime format
  7. Escape a string in SQL Server so that it is safe to use in LIKE expression
  8. SQL time difference between two dates result in hh:mm:ss
  9. Storing files in SQL Server
  10. SQL Server: Difference between PARTITION BY and GROUP BY
  11. Dapper.NET and stored proc with multiple result sets
  12. “order by newid()” – how does it work?
  13. Import ‘xml’ into Sql Server
  14. Query times out when executed from web, but super-fast when executed from SSMS
  15. T-SQL Dynamic SQL and Temp Tables
  16. Efficient ISNUMERIC() replacements on SQL Server?
  17. How to determine total number of open/active connections in ms sql server 2005
  18. Login to Microsoft SQL Server Error: 18456
  19. Adding a query hint when calling Table-Valued Function
  20. Find non-ASCII characters in varchar columns using SQL Server
  21. Violation of UNIQUE KEY constraint on INSERT WHERE COUNT(*) = 0 on SQL Server 2005
  22. How can I determine in SQL Server if a dateTime range overlaps another
  23. Intermittent ODBC connection failures
  24. SQL Server Query – groupwise multiplication
  25. SQL Server recursive query
  26. Getting week number off a date in MS SQL Server 2005?
  27. Set database collation in Entity Framework Code-First Initializer
  28. How do you open an SDF file (SQL Server Compact Edition)? [closed]
  29. What are row, page and table locks? And when they are acquired?
  30. Bootstrapping SQL Express from WiX?

Leave a Comment