Send SSRS subscription files to (Secured FTP) SFTP
We have set up subscription for customer which used to send mails to the customers periodically. Recently one of the...
2011-07-14
3,880 reads
SSRS 2005 Data Driven Subscription and Temporary table
Few days back I was setting up data driven subscription for a SSRS 2005 report. The command / query which populates...
2011-06-24
1,500 reads
SSRS Error: Cannot read the next data row for dataset Dataset1
This error , Cannot read the next data row for dataset Dataset1, is thrown for many reasons, at least I have seen...
2011-06-15
5,136 reads
SSRS Error: Unable to connect to remote server error
One fine day when I tried to connect to one of my staging report server I got the
“Unable to connect...
2011-05-26
5,334 reads
SSRS Error: A connection to the database is required for all requests and processing
This error
The report server cannot open a connection to the report server database. A connection to the database is...
2011-04-29
20,040 reads
SSRS 2005 Error: The Declare cursor SQL construct or statement is not supported
Few days back I downloaded a SSRS 2005 file from one of our internal report server and started modifying it....
2011-04-12
2,886 reads
SSRS: Empty dataset and Tablix Control
The behaviour of the tablix is that whenever the associated dataset is empty, it will not show any detail row....
2011-03-15
2,647 reads
Data Driven Subscriptions for SSRS Report with Parameters from multiple data sources
Just to give the context of the problem I faced recently.. our application is very data intensive, GB of data received...
2011-02-21
647 reads
Troubleshooting SSRS subscription failures
Of-late one of our SSRS 2005 report subscriptions started to fail regularly with the error message
Failure sending mail: Timeout expired....
2011-01-07
2,912 reads
Blogs
T-SQL Tuesday #191 Round Up
By Steve Jones
I hosted this month, late as it turns out, but we still had a...
Come See Me at the PASS Data Community Summit
By Brian Kelley
I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...
SQL Clone at Scale with Striped Backups
By Steve Jones
I had a customer recently reach out to ask if SQL Clone would work...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Managing unused indexes
While doing some housekeeping activity on several old but large production databases, I come...
Cloud Performance Considerations
How important to SQL Server is the speed of the SSD and network latency?...
Question of the Day
Striped Backup File Limits
In SQL Server 2022, how many backup files can I have in a striped backup?
See possible answers