Stefan Krzywicki (3/23/2011)

---

Kit G (3/23/2011)

---

Ah, so nice to know that Boston has retained the title of "Worst City to Drive In". My dad went to MIT in the early...

$QLdb@ (3/23/2011)

---

hi

In this case,First u take backup of your database and then change the recovery model to simple

By which transaction log will not get save

After this you can delete the...

As others have stated, you can't turn off logging.

I wrote an article on deleting records. You should be able to find a link to it in my blog (link...

Besides Craig, are there any other Threadizens residing in Pheonix?

Well, SOX can be applied to smaller companies without requiring them to hire personnel they can't afford. SOX could require they establish those necessary policies and procedures.

TravisDBA (3/18/2011)

---

The "Separation of duties" is the big thing I see in SOX. No more "Jack of all trades" job descriptions. I see too many smaller companies not currently under...

And looking again, you aren't a newbie, so you really have no excuse for not providing us with what we needed to help you.

As of today for you: Points: 1,170,...

SUPER SQL STAR (3/16/2011)

---

Phil Parkin (3/16/2011)

---

That's it? You expect others to take the time to craft a technical response to a question...

Check out my blog (link below). I have a post where I compare hardcoding a function vs in-line tvf vs scalar function.

Lowell (3/16/2011)

---

Lynn Pettis (3/16/2011)

---

Your project, okay. I could provide you with code, but I'm not going to bother.

What you need is a delimited string parse function. Do a...

Your project, okay. I could provide you with code, but I'm not going to bother.

What you need is a delimited string parse function. Do a search of this...

Now there are some contridictions here that need to be clarified. You want to delete all the records from the table while new records are being added.

What would really...

What is the purpose of this function and how will it be used?

Also the datetime2 and datetimeoffset data types as well in SQL Server 2008.

Craig, I'll give you a third set of eyes if you want. I'll PM my email address shortly, have a meeting to go to first.