edvard 19773 (5/23/2013)

---

No, i can't even open it in any text editor i have come across.

Its big!

I really do not think that anybody is using it for anything - But...

Yes, you will need to restore ReportServer and ReportServerTempDB. All of the report definitions are stored in the ReportServer in encrypted fashion. However, after you restore these DB's...

The script database name is defined for 50 chars. Your db names are longer so you will need to increase it. You may also have to enclose the...

I'm not sure I totally understand your situation - but a couple of approaches come to mind:

1) Use the report query to do the update. So you would take...

See this link

http://sqlserverbiblog.wordpress.com/tag/manually-starting-subscription/

The "Additional Information" section of that KB seems to indicate that the use of that driver IS supported for SSIS.

I think the next thing I might try is a script task that reads in a line at a time and then applies logic to parse the line. I'm...

You should be able to incorporate a Regex function to do this. Here is a sample:

•The Regex functions from the .NET Framework System.Text.RegularExpressions are useful for changing the format...

I have a similar report where the datasets and report format are exactly the same but 6 stored procs are called.

I created a non-queried report parameter where the...

You might want to try using the PSExec utility to invoke Excel on another workstation and do that piece of the processing after the data files are created. I...

One problem I have had on a few SQL 2005 boxes was that McAfee Enterprise AV was not allowing the EXE to send email. We had to establish an...

Most of the databases I work with are for vendor supplied systems, but it is not uncommon to see some 1:1 relationships between tables, particularly if a single table might...

We run both versions, but all of the reports hosted on ssrs 2008 are written in BIDS 2005.

One issue that we ran into concerns deployment of the ActiveX Client Print...

We have a reporting system that contains monthly snapshots of our core system database. Each snapshot is a database with a naming convention like Snapshot20111231. We frequently have...

george sibbald (11/9/2011)

---

with 2008R2 you get compression anyway with the native backup so stick with that.

For earlier versions of SQL I like Hyperbac (now a redgate tool) as you dont...