I think this is what you need:

SELECT

dbo.PURCHASE_ORDER.VENDOR_ID,

dbo.VENDOR.NAME,

dbo.PURCHASE_ORDER.ID,

dbo.PURC_ORDER_LINE.LINE_NO,

...

Is autoshrink enabled or is their a job that is shrinking the database?

The primary key clustered index based on an identity column should not fragment.

jcrawf02 (5/14/2010)

---

Chris Morris-439714 (5/14/2010)

---

Paul White NZ (5/14/2010)

---

You would have loved my first draft reply 😉

Celko is undoubtedly a reasonably bright...

Chris Morris-439714 (5/14/2010)

---

Paul White NZ (5/14/2010)

---

You would have loved my first draft reply 😉

Celko is undoubtedly a reasonably bright individual,...

cengland0 (5/6/2010)

---

Jack Corbett (5/5/2010)

---

I got it wrong because I didn't read the script. I read the text where it says you created a non-clustered index on LastName and the...

Steve Jones - Editor (5/6/2010)

---

Top Ten Posters in this thread (out of 15,100 or so)

Lynn Pettis 1533

CirquedeSQLeil ...

Is anyone else experiencing this problem?

Once you are connected what database are you connected to? Is it a user database or a system database (master, msdb, tempdb, model)? ...

I got it wrong because I didn't read the script. I read the text where it says you created a non-clustered index on LastName and the query used EmailAddress....

Have you tried using the IP Address to connect? Perhaps you are having DNS issues.

Stringzz (5/1/2010)

---

Great article! I have a question, is there a way to query the xml column and have the field names and values be cross-tabbed?

So here is my error detail...

Okay, what determines what subgroup an item belongs in? There has to be something in the data that identifies it or else you can't report on it.

What's your query...

Your table/tablix would have 2 groups, the Group (grouped on the group column) and then a second group under the first group (grouped on the subgroup column). You can...

What's the database you are connecting to? Is it set to autoclose?

I believe that xp_cmdshell is taking you out of the current security context which is causing your problem. I'm not even sure why you are using xp_cmdshell here.

Since this...

CirquedeSQLeil (4/28/2010)

---

Tom.Thomson (4/28/2010)

---

That's right.

And you got in fast there Jason, before I...