Viewing 15 posts - 16 through 30 (of 131 total)
I found a clue to what would work best for my scenario here:
http://www.sqlservercentral.com/Forums/Topic748432-146-1.aspx
I can create the read-only user in the primary, but disable or delete the login...
May 17, 2011 at 12:00 am
I am not currently moving logins but probably should. It would lessen the amount of configuration we would need to do in the event of an actual disaster.
I'll see...
May 10, 2011 at 3:14 am
Clever idea, thanks for your advice today.
April 28, 2011 at 2:18 pm
I'm using an Execute T-SQL Statement Task within a maintenance plan, is that what you are referring to or something else?
April 28, 2011 at 2:04 pm
One idea I had was to write a C# CLR stored proc that would take the print from your code and drop that into a .sql file and write it...
April 28, 2011 at 1:49 pm
Oh, that's nice, thank you. I was working off of some script from this post:
http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/66372/
However, I think yours looks better.
So, the only last piece of this...
April 28, 2011 at 1:44 pm
2008 R2 has an option to execute the data-drive subscription, "When the report data is updated on the report server".
March 2, 2011 at 1:13 am
If my memory serves me correctly, I think to get the AJAX spinner, you need to set AsynRendering="true".
March 2, 2011 at 1:08 am
SSRS absolutely sucks when it comes to clean exports to Excel. It loves to put in hidden columns and all kinds of other trash that makes the export useless to...
March 2, 2011 at 1:05 am
I do not believe this can be achieved with SSRS natively. We have the same scenario at my day job. We have employees mapped to roles and employees mapped to...
March 2, 2011 at 12:49 am
I just verified that it works in SSRS 2008 R2. However despite this, I have to wonder, did Microsoft intend for us to serve Excel files from the Report Server...
March 2, 2011 at 12:21 am
The solution to this specifically was to add the connection string to the SSRS services config file, which is what runs the subscriptions.
However, it became apparent to another member...
March 1, 2011 at 2:10 am
I've asked this before and also got no responses. It seems like such an obvious oversight.
March 1, 2011 at 1:58 am
I am also interested in the answer to this.
March 1, 2011 at 1:50 am
Yes, making username a hidden parameter will work, my team did exactly a couple of years ago with SSRS 2005 and an ASP.NET web application.
March 1, 2011 at 1:40 am
Viewing 15 posts - 16 through 30 (of 131 total)