Tag: TSQL

SRSS – Get list of Reports and Its Data sources and Datasets

admin 31.03.2013

I needed to get the list of my reports and what data source and dataset they use. use ReportServer; WITH XMLNAMESPACES ( DEFAULT ‘http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition’, ‘http://schemas.microsoft.com/SQLServer/reporting/reportdesigner’ AS rd ) SELECT distinct ReportName = name ,DataSetName = x.value(‘(@Name)[1]’, ‘VARCHAR(250)’) ,DataSourceName = x.value(‘(Query/DataSourceName)[1]’,’VARCHAR(250)’) ,CommandText = x.value(‘(Query/CommandText)[1]’,’VARCHAR(250)’) FROM ( SELECT C.Name,CONVERT(XML,CONVERT(VARBINARY(MAX),C.Content)) AS reportXML FROM ReportServer.dbo.Catalog C WHERE C.Content is …

Uncategorized
DataSet, DataSource, SQL, SQL Server Reporting Services, SRSS, SSRS, TSQL

SQL – Table comparison

admin 27.12.2012

For table comparison, i like to use Red Gate SQL compare. Great tool, but if you don’t have money for it, you can always try to write your own comparation script. You can then script it as function, and use it. It does not have, options like SQL Compare, but for now it will do …

column comparison, Columns, QUERY
Column comparison, Column difference, SQL, TSQL

TSQL – working with folders and output to file

admin 25.05.2012

This article shows how to create a folder for backup. The idea is to create folder with date part in its name, and then backup a specific database to that folder. First we need to create a parameters to save our SQL command in it. use master declare @sql1 nvarchar(max) declare @sql2 nvarchar(max) declare @var1 …

CMD, FILES, FOLDER, XP_CREATE_SUBDIR
bcp, queryout, SQL, SQL Server, TSQL, xp_cmdshell, xp_create_subdir