You could also add an extra step to the backup jobs to xcopy the .bak file to another network location. If that fails you've still got the original file to...

To add a bit more info to this.... the .rdl.data file is the data file in question and we are running the reports from visual studio 2008 shell (BIDS). Network...

I don't know if this will help but I back up all my servers to a local disk on the same server each night then the next step in the...

How about a for (or rather for each datasource) loop that processes one datasource at a time and has some logic inside the loop for the differences? I often use...

Visio Professional also installs express I believe (I know older versions of Visio did) and so does installing the sql tools such as BIDS or Management Studio.

At least most...

Why not just go on the server and Start, Programs, SQL Server, Configuration Tools, Reporting Services Configuration Manager and see what's set up that way??

All the sql server databases - I'd be all day counting them - I haven't even managed to count servers yet! But I have to say a huge thank you...

Otherwise you could populate a master table and then copy that to the other two, enabling identity insert.

7-zip works very nicely in an execute process task in ssis - we rely on it every day.

For testing purposes make sure you install it in the same drive...

It's not just developers who have to take responsibility. When a piece of software is commissioned by a section of our business it has to go through user acceptance testing...

One domain behind a very tight firewall but I can SSMS all my servers even when they are in another country (well, Scotland - no comments about independence here :-)...

We're encouraged and supported to take relevant training generally a course per year or more if needed and usually get any books we request - an Itzik Ben Gan one...

I'll add another vote for Ola's method. Unless you know what you are doing and carefully configure your maintenance plans rather than just taking the defaults, you'll end up doing...

Uk law has certainly improved on this. Back in 1978 as a fresh computing graduate leaving university, I turned down a job with a software house mainly because I was...

The user may have been created as a login as normal and given database permissions but then if the server login was deleted the user would be left in the...