I'm sure that could be arranged (tattoo).

Do you have an internal QA department?

Previous test cases for the application?

Are you able to go through the application given certain scenarios and receive expected results?

Most excellent suggestion Jeff. The update will need to happen at some point anyway with Text going away in a future release.

More options include altering the job so only Indexes that meet certain criteria are re-orged or re-indexed (frag % and number of pages are common delimiters). Make those criteria...

Now that you know the symptoms, you would probably be amazed at how frequently this pops up.

Did you update that same line every time it appeared in the code that Lynn provided?

Somewhere in your process it is trying to convert the $ back to an int.

I was rooting for the Packers too. 2 Reasons Elway and Broncos - don't like either of them much.

It was a weird sort of feeling too, being a Bears...

That has got to be a load of fun. At least she isn't a Mets fan 😉

john.arnott (12/16/2009)

---

CirquedeSQLeil (12/14/2009)

---

Alvin Ramard (12/14/2009)

---

GSquared (12/14/2009)

---

CirquedeSQLeil (12/11/2009)

---

By the time the thread hits 10,000 y'all will be flatlined, passed out drunk from all the bear being passed around - bwahahaha 10,000...

Now we need a database like that for basketball.

Ohh the fun we could have with Fantasy Baseball with this database.:cool:

Heh... Yankees fan?? Born Yankees hater myself. Respect the players (some of them) hate the franchise.;-)

As far as teams go, I was not raised in a Baseball home...

Use some app outside of SQL to password protect the file.

sp_send_dbmail [ [ @profile_name = ] 'profile_name' ]

[ , [ @recipients = ] 'recipients [ ; ...n ]' ]

[ , [ @copy_recipients = ] 'copy_recipient [ ; ...n ]' ]

[...

I've seen 2%, 5% and as much as 10% as the recommended low for this counter.

So if 4GB is well beyond 10% free, then you have adequate memory for your...

based on the available criteria:

Here's another method

SELECT ID,Serial,Narration,Reference

FROM statementmaster

Where isnull(Narration,1) = 1

And Serial like (case when serial = '700' then '700' else '%' end)