Duplicate post - please reply to:

http://www.sqlservercentral.com/Forums/Topic887195-392-1.aspx

Paul White NZ (3/19/2010)

---

BrainDonor (3/19/2010)

---

It's even more fun to solve with a...

Definitely - I'd hate to wait for this code to complete against a large table. I just saw it as an...

That was interesting.

CREATE TABLE mytbl2

(

c1 sysname

);

GO

INSERT mytbl2 VALUES ('Discount is 10-15% off');

INSERT mytbl2 VALUES ('Discount is .10-.15 off');

INSERT mytbl2 VALUES ('total count is 100 of total employees');

INSERT mytbl2 VALUES ('100...

I've just experienced a problem with enabling Filestream for SS 2008 and I eventually removed the SS2000, 2005 and re-installed 2008 (I wasn't using the other versions anyway).

In my situation...

The Wall (3/9/2010)

---

Thank you. I did not need to know this answer as I much as I need to prove it in writing, so that little time is spent...

It is correct that your grid shows nothing when a null value is entered - a null is an unknown value and can cause no end of fun if not...

Steve Jones - Editor (3/2/2010)

---

Well this was interesting. Had someone ask for their account to be closed here since the questions haven't been good the last month and the quality...

It was a more polite way of saying 'obviously'...

BrainDonor

A little bit of testing shows that it takes the recovery model from the 'model' db (oddly enough). But of course, you don't know if anyone ever changed that...

BrainDonor.

Not that I'm aware of. However, if it was deliberately set to Full Recovery shouldn't...

If the database was switched from Simple to Full recovery and a backup has never been run it is possible that it isn't in Full recovery mode at all.

http://msdn.microsoft.com/en-us/library/ms178052.aspx

BrainDonor.

http://msdn.microsoft.com/en-us/library/ms187088.aspx

BrainDonor.

Can we have a look at that batch file? I assume your SQL is extracting directly from some tables and creating the export, but would like to see the code.

What...

erin.peachey (2/19/2010)

---

HI

i am pretty new to SQL and what you can and can't do so please help me if you can.

I'm trying to take a value from a colomn, devide...