• Search for:

    Category Archives: MSSQL

    1. Home  - 
    2. Archive by category "MSSQL"
      3. ( Page6 )
    15 Aug, 2021
    T-SQL script to show table definition in SQL Server 0 (0)
    MSSQL , , ,

    Below query can be used to check table definition in SQL Server

    select db_name() as 'DatabaseName',
ss.name+'.'+so.name as ObjectName,
so.type_desc as ObjectType,
sc.name as ColumnName

,case
    when st.name IN ('char','varchar') then st.name+'('+case when sc.max_length<0 then 'MAX' else convert(varchar(10),sc.max_length) END+')'
    when
    … Read the rest
    11 Jul, 2021
    T-SQL script to get last restored date of SQL Server Database 0 (0)
    MSSQL , ,

    Below query can be used to find out database last restored date.

    SELECT [bs].[database_name] as [source_database_name]
,[rh].[destination_database_name],
[rh].[Restore_date],
[bmf].[physical_device_name] as [Backup_file_used],
[rh].[user_name] AS [RestoredBy],
datediff(minute,bs.backup_start_date,bs.backup_finish_date) as RestoreDurationMin,
CAST(bs.backup_size/1024.0/1024 AS DECIMAL(10, 2)) AS BackupSizeMB
FROM msdb..restorehistory rh
INNER JOIN msdb..backupset bs
    … Read the rest