Tag Archives: SQl

SSRS SQL Server Reporting Services – SOLUTION – Error Message: The permissions granted to user are insufficient for performing this operation. (rsAccessDenied)

The aforementioned error may come up in several different circumstances: – Deploying / Running your Report Project From Visual Studio or Report Designer – Browsing to your Report Server URL http://servername/ReportServer – Browsing to your Report Manager URL http://servername/Reports In … Continue reading

Posted in Computers and Internet | Tagged , , , , , , , , , | Leave a comment

Microsoft SQL Server 2008 SQL Quirk – When Using TOP 1 In Query With Correlated Subquery

I found this quirk in Microsoft SQL Server 2008 T-SQL tonight – thought I’d pass it along to spare you the grief it gave me for nearly 2 hours: SELECT TOP 1 CAST(ad.id_acct_biztax_detail AS INTEGER) AS id_acct_biztax_detail       ,ad.dte_due_taxes       … Continue reading

Posted in Computers and Internet | Tagged , , , , , , , , | Leave a comment