Tag Info

New answers tagged

0

Regarding running reports from an Availability Group secondary server, you will need to license that instance of SQL Server. Since the AG requirements require identical equipment, your secondary's licensing cost will reflect the primary server's licensing cost Using the secondary server strictly for High Availability/Disaster Recovery does not require ...


0

SSRS has a number of configuration files, including RSReportServer.config. Both Shared Schedules and Shared Data Sources are good things to create since they help you manage your configuration without giving each and every report it own schedule. View this as saving you some work. Of course, independent Schedules and Data Sources will likely be needed ...


0

Found My Answer from a Blog Almost similar :) !!! DECLARE @UserName VARCHAR(200) = 'UserName' SELECT Rol.RoleName,Us.UserName ,Cat.PATH,Cat.[Name] ReportName, CASE Cat.Type WHEN 1 THEN 'Folder' WHEN 2 THEN 'Report' WHEN 3 THEN 'Resource' WHEN 4 THEN 'Linked Report' WHEN 3 THEN 'Data Source' ELSE '' END AS CatalogType ,Cat.Description FROM Catalog Cat ...



Top 50 recent answers are included