Jason has the right idea as there is no way to use an expression to set a page break.

john.arnott (5/27/2009)

---

Hello, Expert Gurus!!!!

I need to know what "SQL" means.

Is an index the opposite of an outdex?

IF U DON"T KNOW, PLEAS DOn't AnSer me.

Urgent, urgent, urgent..... ...

Hello...Hello...Hello..Hello

GSquared (5/27/2009)

---

True enough, except for the horse part. You actually can make a horse drink, if you hold its nose underwater (I used to ride horses almost every day...

This article[/url] may be helpful. Be sure to check the discussion as well.

Any other errors in the event log or setup log?

The Default Trace tracks that Objects were altered, but not what the change was. Try this query:

SELECT

TE.[name],

I.*

FROM

sys.traces...

I'd go with 2008 as well. There were a lot of nice upgrades to SSMS in 2008 and as Grant said, the support life time is growing short for...

Pratibha_Pillai (5/27/2009)

---

Hi,

I came across default trace offered by sql server 2005.

1)Can it act as a substitute to DDL triggers?What's the difference between them?Also I didn't find any column in...

I'm not sure that you can guarantee exactly 10 groups per page because each group will expand/contract based on the # of rows in the group.

Can you give...

It would be easier to help if you provided the fields of the dataset and which fields belong in which groups.

Something like:

Orders Dataset:

OrderDate

SalesPerson

Customer

Product

InvoiceAmt

OrderDate = ColumnGroup1

SalesPerson = RowGroup1

Customer = RowGroup2

Product =...

Tom Brown (5/27/2009)

---

I just about...

Grant Fritchey (5/27/2009)

---

GilaMonster (5/27/2009)

---

I wouldn't mind giving it a shot, however it's ramping up to the busy time of the year, TechEd in Aug and PASS in Nov, and usually...

Lynn Pettis (5/27/2009)

---

GilaMonster (5/27/2009)

---

Grant Fritchey (5/27/2009)

---

Actually, I do know of a publisher that tackles those specialized little books. They've put out one on Profiler and one on execution plans. I...

Chapter 1 - It's like your Index Finger, it points to something