truncate table [admin].dbo.DB_CARDS
IF OBJECT_ID('tempdb..#tmp') IS NOT NULL
    DROP TABLE #tmp
IF OBJECT_ID('tempdb..#tmp2') IS NOT NULL
    DROP TABLE #tmp2
create table #tmp (
	SERVER_NAME sysname NULL,
	DATABASE_NAME sysname,
	DATABASE_SIZE int,
	REMARKS	varchar (254)
)
insert into #tmp(DATABASE_NAME,DATABASE_SIZE,REMARKS) exec sp_databases 
delete from #tmp where DATABASE_NAME='tempdb'
update #tmp set SERVER_NAME=@@SERVERNAME
select  SERVER_NAME
	,DATABASE_NAME
	,suser_sname(owner_sid) as db_owner
	,DATABASE_SIZE
	,sys.database_id
	,user_access
	,user_access_desc
	,sys.is_read_only
	,sys.is_auto_close_on
	,sys.is_auto_shrink_on
	,sys.state_desc
	,is_in_standby
	,recovery_model_desc
	,page_verify_option_desc
	,is_auto_create_stats_on
	,is_auto_update_stats_on
	,is_fulltext_enabled
	,is_trustworthy_on
	,is_query_store_on
	,is_published
	,is_subscribed
	,is_merge_published
	,is_distributor
	,service_broker_guid
	,is_broker_enabled
	,log_reuse_wait_desc
	,file_id
	,file_guid
	,type_desc
	,data_space_id
	,mf.name [file_name]
	,physical_name
	,mf.state_desc [file_state]
	,mf.size [file_size]
	,max_size [max_file_size]
	,growth
	,is_media_read_only
	,mf.is_read_only [file_is_read_only]
	,is_sparse
	,is_percent_growth
	,admin.dbo.get_last_backup_date(DATABASE_NAME) as LastBackupDate
	,admin.dbo.get_last_backup_path(DATABASE_NAME) as LastBackupPath
into #tmp2 from #tmp tmp 
left join sys.databases sys on tmp.DATABASE_NAME=sys.name
left join sys.master_files mf on sys.database_id=mf.database_id

insert into admin.dbo.DB_CARDS ([SERVER_NAME]
      ,[DATABASE_NAME]
      ,[db_owner]
      ,[DATABASE_SIZE]
      ,[database_id]
      ,[user_access]
      ,[user_access_desc]
      ,[is_read_only]
      ,[is_auto_close_on]
      ,[is_auto_shrink_on]
      ,[state_desc]
      ,[is_in_standby]
      ,[recovery_model_desc]
      ,[page_verify_option_desc]
      ,[is_auto_create_stats_on]
      ,[is_auto_update_stats_on]
      ,[is_fulltext_enabled]
      ,[is_trustworthy_on]
      ,[is_query_store_on]
      ,[is_published]
      ,[is_subscribed]
      ,[is_merge_published]
      ,[is_distributor]
      ,[service_broker_guid]
      ,[is_broker_enabled]
      ,[log_reuse_wait_desc]
      ,[file_id]
      ,[file_guid]
      ,[type_desc]
      ,[data_space_id]
      ,[file_name]
      ,[physical_name]
      ,[file_state]
      ,[file_size]
      ,[max_file_size]
      ,[growth]
      ,[is_media_read_only]
      ,[file_is_read_only]
      ,[is_sparse]
      ,[is_percent_growth]
      ,[LastBackupDate]
      ,[LastBackupPath]) select * from #tmp2