Viewing 15 posts - 31 through 45 (of 61 total)
Could be a rendering issue if you are doing any calculations, Conditional formating or grouping with totals in the report. Or if you have a embedded image. Take a look...
April 10, 2025 at 2:24 pm
Using SQL Queries on the ReportServer Database. The and tables in the ReportServer database store information about data sources and reports.
You can get the "New Datasource Link "from Datasource Table...
April 7, 2025 at 11:13 am
CREATE TRIGGER TriggerName
ON YourTableName
AFTER DELETE
AS
BEGIN
-- -- Check if any row was deleted (= 1 or True)
IF EXISTS (SELECT 1 FROM DELETED)
...
April 6, 2025 at 4:29 pm
Backup your SSRS Databaes(ReportServer and Report Server Temp DB and Any other DB needed) using Microsoft SQL Server Managment Studio:

And Backup your Encryption Key using...
April 3, 2025 at 7:09 pm
double post.
April 3, 2025 at 6:40 pm
You can set permisions per report or on entire folder. My hunch is you have permissions set on reports not the folder.



April 3, 2025 at 6:40 pm
Found this:
Use Key Vault Insights: Azure provides Key Vault Insights, a feature in Azure Monitor, to visualize metrics like request frequency, latency, and failures.
Monitor SQL Server Activity: If you're using...
April 3, 2025 at 11:23 am
I created the tables and results returned. Re-enter the refnum in both tables, you might have a space in there.



April 2, 2025 at 7:42 pm
SELECT DISTINCT refnum FROM RefSched;
SELECT DISTINCT s.refnum FROM supplier;
Check if values match. Maybe Data Type Mismatch? Since DESC is a reserved keyword in SQL Server, you should...
April 2, 2025 at 7:04 pm
--Check The Credential setup
SELECT name, credential_identity FROM sys.credentials WHERE name = 'YourCredentialName';
--Validate the Key Vault Key
SELECT name, key_algorithm FROM sys.symmetric_keys WHERE name = 'YourTDEKeyName';
April 2, 2025 at 4:00 pm
run both.
SELECT *
FROM sys.objects
WHERE name = 'fn_syspolicy_is_automation_enabled' AND type = 'FN';
SELECT msdb.dbo.fn_syspolicy_is_automation_enabled() AS IsAutomationEnabled;

April 2, 2025 at 12:34 pm
launch Sql Server Configuration Manager, Do you see SQL Agent running?
April 2, 2025 at 11:56 am
Your are correct regarding "Data for 2024-02-29 is left in place until 2027-03-01."
April 1, 2025 at 9:36 am
Viewing 15 posts - 31 through 45 (of 61 total)