Ninja's_RGR'us (1/18/2010)

---

With that many rows you may also consider 2 more things :

How many rows will be left after the delete? Sometimes it's just faster to figure out...

My guess, they ran the update that took 11...

I have to agree with Gail again. If you can provide us with more specifics, table DDL (CREATE TABLE statement(s)), sample data (series of INSERT INTO statement(s)) for then...

Should have seen this to begin with, here is what you need to do:

Change:

INSERT INTO Files (Dir, FilePath)

(

SELECT('O', filePath) FROM #Temp

)

To:

INSERT INTO Files(Dir, FilePath)

SELECT 'O', filePath FROM #Temp;

What is the exact error message you are getting.

ragie (1/16/2010)

---

sorry bout that Lynn.

i'm writing a sp where the goal is to get two output parameters: the fileid, and filepath. as you saw from the first post, i...

ragie (1/16/2010)

---

Thanx Lynn. i don't know why i didn't see that!

quick question, is it possible to do an INSERT SELECT like this:

INSERT INTO Files (Dir, filePath)

SELECT('O', filePath) FROM #Temp

it's...

Jeffrey Williams-493691 (1/15/2010)

---

And, just to make things a...

backup data base MyDB to disk = N'MyDB.bak'; -- remove space between data and base, only way to get this to post from work

restore database MyDBClone

from disk = N'MyDB.bak'

with...

Use RESTORE HEADERONLY, that will tell you what type of backup the native backup file contains.

Not really, your only choice is to run DBCC CHECKDB with repair_allow_data_loss option. The optimum solution would have been to restore from a previous database backup prior to the...

So you are saying that you have no previous backups made before getting this CHECKDB error, correct?

One, I don't use Redgate SQL Backup. Two, it looks like the error message basically tells you what you need to do.

One, SQL Server 2008 supports partitioned tables, you may want to read about them in BOL (Books Online, the SQL Server Help System).

Two, how is the ID determined?

Three, good luck....

The first step is to know the structure of the table. Oh, we don't. Can you post the DDL (CREATE TABLE statement) for the table?

Second step, what edition...