Disabling the logreader agent won't work - the log records will remain in the transaction log until the logreader stars up again and the deletes will still be sent to...

You cannot simply restore a reporting services database from another SSRS installation over the top of the SSRS database of another installation. This is because SSRS encrypts parts of...

What replication does when table already exists at the subscriber is defined by you. You have options that include:

- drop and create the table and then load data

-...

You need to add an action to the layer of the map that represents the states with the data you are showing. To do this, from the "Map Layers",...

You cannot restore a database to an old version of SQL Server. So going from SQL 2008 to SQL 2005 is not an option. You can only restore...

If you are using the same report parameter for SQL datasets and also for Analysis Services datasets, you will need to be aware of the differences in the syntax of...

I use metadata of various sorts to generate code as much as I can. This tends to reduce the likelihood of errors in your code (assuming you have valid...

Since 'pehPaydate' has a datatype of datetime, you can use the DATENAME function to return the month name - i.e. you won't need the case statement anymore. So...

A matrix report will only show the months that exist in the dataset used for the report. So, as you are finding, only 3 are currently appearing.

You will need...

Have a look at this TechNet article... http://technet.microsoft.com/en-us/library/ms186243(v=sql.105).aspx

It shows sample data and the results of a recursive CTE (I think that this is what you are after)

The overview does not say that the exam has been retired. It says that the MCTS Certification one of the certifications that 70-448 counts as credit to, ("Microsoft Certified...

My first thought is that the environment variable is not known to the process that is attempting to run the package (e.g. SQL Server Agent) - probably because the environment...

What edition of SQL 2005 are you using ? From memory, Standard Edition will not use an index on a view unless you specify the NOEXPAND hint

Exam 70-448 is not being retired on 31 July. However, some of the certifications that it counted towards are (I think that this may be part of the reason...

Cancelled - I don't think so. You will probably need to drop the subscription - not sure how helpful that will be. If you will need to initialise...