I can understand storing some types of files in DB. 
like images or special needs files. 
I had worked in the past on projects where we would store whole application...

I haven't worked with SQL on this level for the last 3 years so some things may have changed, BUT isn't the biggest difference between "Select into" and "insert into...

keyurgondalia (9/8/2015)

---

If I have more than one table than is it good to use View. Means I have 20 tables and I have to delete data from them. Kindly give...

Jonathan AC Roberts >> I never sad otherwise.

it's just some times it is not optimal to run this kind of process manually on a LIVE database and think that...

on one of the places I worked a few years back, we had similar situation.

although we had an update/upgrade windows from 12AM to 6AM once or twice per month...

Michael L John (8/17/2015)

---

andre.quitta (8/17/2015)

---

You may also free up some space with a more aggressive archiving approach to your data, or install archiving at all.

I've seen a number of legacy...

I have a better question.

what if you go through all of this trouble and still need more space?

let say you know what you are doing, and before putting...

I think other people here have merits in pointing out the shortcomings of your system in terms of it's infallibility 🙂 ,

but

here is a function for you...

Steve Jones - SSC Editor (3/13/2015)

---

Eric M Russell (3/13/2015)

---

My point earlier was that this form of comment is useless; it's basically just re-stating in engligh the functional operation of a...

I am with you all the way on this one.

I have been saying this for years, even though I have rearly been affected by this myself. most of my work...

august.tomelleri (7/17/2013)

---

As long as your table is not too large, you can use the generate scripts feature to create a copy of table along with all the data. This...

agreed, and thanks.

I do tend to take things a bit more literally,

ignoring the fact that question might just be educational.

At present time I mean 2008.

We did not moved to 2012 yet 🙂 so I am not sure what options are exists for it...

it's strange that no one asked a fairly obvious question(s) as

#1. why exactly OP needs to backup single table?

#2. what is the reason for such need and how it...

OK, I think I got it. so I will post my finding here for some one to use in the future, as it was not obvious to me and...