Show Databases ?
-
Hi All, I am trying to display a list of databases in SQL Server 2005. When I used to use MySQL I used a SHOW DATABASE which returned a list of databases. With SQL Server 2005 this command is not accepted. Can I perform the same list in SQL Server ? Fritzables.
-
Hi All, I am trying to display a list of databases in SQL Server 2005. When I used to use MySQL I used a SHOW DATABASE which returned a list of databases. With SQL Server 2005 this command is not accepted. Can I perform the same list in SQL Server ? Fritzables.
exec sys.sp_databasesis a stored procedure that will list all the databases for you..."I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
-
exec sys.sp_databasesis a stored procedure that will list all the databases for you..."I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
Thanks Paul. Fritzables.