Discover our Clipsal Smart Home packages as seen on The Block 2018

in location

OR

I'm looking for

  • Wholesalers
    • Uncheck All Check All
  • EXPERTISE
    • Expand
    • Expand
    • Expand
    • Uncheck All Check All
  • Switchboard Manufacturers
    • Uncheck All Check All
OR

The best way to see what Clipsal electric products can do for your home is seeing them in action at a Clipsal Display Centre.

Product stock may vary according to location. If you're after a specific product range, please check with your chosen location before visiting.

10 Results
    Load More Load Complete
    Change Location

    Obtaining Information about all Databases in a SQL Server Instance

    Issue
    List of databases and their general settings.

    Product Line
    SQL Server

    Environment
    SQL Server Management Studio (SSMS)

    Cause
    For troubleshooting it may be necessary to look into SSMS in a broader detail. This query provides one row for each database in an instance of SQL Server, including system databases such as Master, Model, MSDB and TempDB.

    Resolution
    The database that contains information about all databases in an instance of SQL Server is sys.databases.  A select statement is required to obtain the result:

    select * from sys.databases

    Since all columns may not provide useful information for a specific problem, it may be better to restrict the number of columns by specifying which ones to be displayed.  Here is an example:

    select name, compatibility_level, state_desc, recovery_model_desc, page_verify_option_desc
    from sys.databases


             


    Click here to get a list of all columns with a description of each for SQL Server 2017 along with some examples.

     

    Didn’t find what you were looking for?

    Try Searching Again View Our Categories

    Need further assistance?

    Our Customer Care department provides total customer service solutions for our residential, industrial and commercial applications.

    Get Assistance