Instead of controlling visibility, use formulas for the value being display (either display the text required or empty string) and for the background colour (e.g. either "White" or "Gray")

I mean exactly that - don't update the report server database. If report manager is already hosed, you have limited ability to do anything that is supported. Start...

If all else fails, the RDL is stored in table Catalog in the ReportServer database.

The following SELECT is a start to getting at the RDL

SELECT

Name ...

When you deploy a report to reporting services, it is actually stored in the ReportServer database. If you need to get a copy of a report, the normal way...

This sounds like transactional replication is the best option provided that you have a scheme in mind for ensuring any unique constraints (including primary keys) do not cause any conflicts...

I got to the point where I was constantly fighting fires and never really getting anything "useful" done. So, I decided that I would stop fighting the fires. ...

My first question is "Why are you even needing to specify DOP (or any other hint) ?"

Generally SQL Server will do a pretty good job without any hints. When...

Whilst it might take a while, eventually you will get an error when you run out of disk space. So, I kinda think that the correct answer is most...

Not all that surprising, really. What reporting services is really doing is allowing you to access the parameter object for the parameter you are using. This object has...

In the report that is calling the subreport, check the value that is being passed in the parameter. By default, you get the first value only. The value...

The only way to do this using Analysis Services is to include all of the required columns as attributes of a dimension (this may be called a fact dimension or...

Try the following...

UPDATE dbo.House set [Location] = geography::STPointFromText('POINT(' + CAST([Longitude] AS VARCHAR(10)) + ' ' +

CAST([Latitude] AS VARCHAR(10)) + ')', 4326)

As far as SSIS is concerned, your SQL 200 source is just like any other data source. As long as you use the correct syntax for the data source,...

I would expect percentages to have values in the range 0 - 1 (with format of P2) or maybe a range of 0% - 100%. For numbers, I would...

Once a subscription has been initialised, you do not need any snapshots to be created. So, you can either disable the snapshot agent job or delete its schedule. ...