Sorry, SJ, but that works only for a Tablix, not a Matrix.

Step 3 on the link you provided is this:

3) Select the first Static...

Even without the total column there is no static header to click on to set the KeepWithGroup/RepeatOnNewPage properties.

When I attempt to set the KeepWithGroup/RepeatOnNewPage for the total column, the...

Never figured out the root cause - didn't have time to continue digging into it.

I deleted and recreated the backup maintenance plan and it runs successfully now.

Gremlins.

One cause for this is when you have the "Generate a text file report" option check in the maintenance plan and have two or more subplans. For example, I have...

I thought so. But the data that was being returned wasn't really reflecting that. So instead of questioning the design, I questioned what I thought I knew.

Unfortunately, the person...

That is correct. But that isn't the issue.

How do I determine which filegroup a table is in using DMVs?

Here is what I have for indexes:

selectdistinct t.name 'TableName',

i.name...

OK, here's a one-liner for you:

SELECT DATEPART(dd, DATEADD(dd, -1, CAST(CAST(@Month+1 AS VARCHAR(2)) + '/1/' + CAST(@Year AS VARCHAR(4)) AS DATETIME)))

Here is the link to the Microsoft certification site for SQL: http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx?#tab1 .

You will want to take the 70-433 exam first for the SQL Server 2008 Database Developer MCTS certification....

The service broker wasn't hung up. It was attempting to send but didn't have access to the .NET directory.

However, I found the problem. Someone else installed SQL.

The SQL...

Oh yeah - and don't try reinstalling .NET Framework 2.0. The message is "This product is already installed as part of the operating system" and exits out of the install....

It occurs when trying to send a test email. Right-click on Database Mail, click on Sent Test E-Mail, and enter an address. Everything else is already populated.

This is so...

Sorry to add a post that does nothing to answer your question or productively contribute to the problem you are trying to solve, but it is just too difficult to...

Never said "optimal". It absolutely is horrid. However, when you are working with a...

Yes, you can. It's not pretty, easy to maintain, or fun to look at. But, if used correctly, can be used to increase performance. In most cases, though, it isn't...