-
Notifications
You must be signed in to change notification settings - Fork 111
Expand file tree
/
Copy pathPrintVersionInfo.sql
More file actions
17 lines (16 loc) · 1.34 KB
/
PrintVersionInfo.sql
File metadata and controls
17 lines (16 loc) · 1.34 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
DECLARE @txt NVARCHAR(MAX);
IF(OBJECT_ID('tempdb..#VersionInfoTable')IS NOT NULL)DROP TABLE #VersionInfoTable;
SELECT Version, ClrVersion, ClrSigningKey INTO #VersionInfoTable FROM tSQLt.Info();
EXEC tSQLt.TableToText @txt = @txt OUTPUT, @TableName = N'#VersionInfoTable';
RAISERROR('+-----------------------------------------------------------------------------------------------------+',0,1)WITH NOWAIT;
RAISERROR('| tSQLt Info: |',0,1)WITH NOWAIT;
RAISERROR('+-----------------------------------------------------------------------------------------------------+',0,1)WITH NOWAIT;
RAISERROR('',0,1)WITH NOWAIT;
RAISERROR(@txt,0,1)WITH NOWAIT;
RAISERROR('',0,1)WITH NOWAIT;
RAISERROR('+-----------------------------------------------------------------------------------------------------+',0,1)WITH NOWAIT;
RAISERROR('| SQL Server Info: |',0,1)WITH NOWAIT;
RAISERROR('+-----------------------------------------------------------------------------------------------------+',0,1)WITH NOWAIT;
RAISERROR('',0,1)WITH NOWAIT;
RAISERROR('%s',0,1,@@VERSION)WITH NOWAIT;
RAISERROR('-------------------------------------------------------------------------------------------------------',0,1)WITH NOWAIT;