Looks to me that it's telling you that it can't drop the constraint because the constraint isn't there to drop. Try building the constraint by hand (to make sure...

- Do the two SQL server "see each other"? ARe you using linked servers or do you need something more asynchronous?

- Nothing forces you to do this once...

Tim OPry (11/27/2007)

---

.

By 'downstream', I mean all clients referred by a ClientID and all of their subsequent children/referrals. 'Upstream' would be the converse - since a client cannot also refer...

That's a presentation issue - let...

Yeah, really - what's the big deal about a few zeroes....:hehe:

The site was acquired by RedGate a while ago (between the time the article was published and now). That might have something to do with it...

Jeff Moden (11/27/2007)

---

Um... no, I don't think so... a Mega byte is a binary million bytes, not a binary thousand.

Convert from Bytes to KBytes by dividing by 1,024.

Convert from Bytes...

Jeff Moden (11/27/2007)

---

OMG! ROFLMAO! Just when I stopped laughing at this, I laughed again! Way too funny! Lordy, I love dry humor! Thanks for making...

Rob (11/27/2007)

---

Michael Earl (11/27/2007)

---

The answer to your questions is basically "No". Even in simple recovery mode, MS SQL writes to the transaction log. In simple recovery mode, it...

Jeff Moden (11/26/2007)

---

Matt Miller (11/26/2007)

---

...to which the right answer should NEVER start with...

"Yeah - I was playing with this new cool TRUNCATE feature in production, right before the end of...

Enterprise edition allows you to do this operation *online*; standard doesn't. Does that help (maybe there's some part not being included in the quote?)

Take a look here - see...

unless the hardware is IBM, in which case 1MB=1,000 bytes. (edit) I mean - Kbyte (duh), which means it could be any...

eschlange (11/27/2007)

---

I can't seem to get a clear answer from people on this, so I'm posing the question to you fine folks.

If I have a SQL Server 2005 db that...

Philip Horan (11/27/2007)

---

Hi Matt. Servers fully fault tolerant (well as good as they can be):

Redundant Fans / PSU / Processor.........

Each server has 8 HDD Bays. 2 Xeon QUAD Core...

It doesn't work with functions.

Just encapsulate the function in a stored proc and it will work fine.