Amazon Recurring Payment Integration

How to get database list using sql command>

Below link more helpfull for get database list.

https://www.simple-talk.com/sql/database-administration/exploring-your-sql-server-databases-with-t-sql/


1.Basic Server Information

-- Server and instance name

Select @@SERVERNAME as [Server\Instance];

-- SQL Server Version

Select @@VERSION as SQLServerVersion;

-- SQL Server Instance

Select @@ServiceName AS ServiceInstance;

-- Current Database

Select DB_NAME() AS CurrentDB_Name;

-- Note the tempdb system database is recreated every time the server restarts

-- Thus this is one method to tell when the database server was last restarted

SELECT  @@Servername AS ServerName ,

        create_date AS ServerStarted ,

        DATEDIFF(s, create_date, GETDATE()) / 86400.0 AS DaysRunning ,

        DATEDIFF(s, create_date, GETDATE()) AS SecondsRunnig

FROM    sys.databases

WHERE   name = 'tempdb';

GO

2.Linked Servers

EXEC sp_helpserver;

--OR

EXEC sp_linkedservers;

--OR

SELECT  @@SERVERNAME AS Server ,

        Server_Id AS LinkedServerID ,

        name AS LinkedServer ,

        Product ,

        Provider ,

        Data_Source ,

        Modify_Date

FROM    sys.servers

ORDER BY name;

GO

3.List All Databases

EXEC sp_helpdb;

--OR

EXEC sp_Databases;

--OR

SELECT  @@SERVERNAME AS Server ,

        name AS DBName ,

        recovery_model_Desc AS RecoveryModel ,

        Compatibility_level AS CompatiblityLevel ,

        create_date ,

        state_desc

FROM    sys.databases

ORDER BY Name;

--OR

SELECT  @@SERVERNAME AS Server ,

        d.name AS DBName ,

        create_date ,

        compatibility_level ,

        m.physical_name AS FileName

FROM    sys.databases d

        JOIN sys.master_files m ON d.database_id = m.database_id

WHERE   m.[type] = 0 -- data files only

ORDER BY d.name;

GO

4.Last Databases Backup?

SELECT  @@Servername AS ServerName ,

        d.Name AS DBName ,

        MAX(b.backup_finish_date) AS LastBackupCompleted

FROM    sys.databases d

        LEFT OUTER JOIN msdb..backupset b

                    ON b.database_name = d.name

                       AND b.[type] = 'D'

GROUP BY d.Name

ORDER BY d.Name;

SELECT  @@Servername AS ServerName ,

        d.Name AS DBName ,

        b.Backup_finish_date ,

        bmf.Physical_Device_name

FROM    sys.databases d

        INNER JOIN msdb..backupset b ON b.database_name = d.name

                                        AND b.[type] = 'D'

        INNER JOIN msdb.dbo.backupmediafamily bmf ON b.media_set_id = bmf.media_set_id

ORDER BY d.NAME ,

        b.Backup_finish_date DESC;

GO