So you're all set?

DTS still might be a good option...

PS this is sql 2008 forum so you might want to pick...

Yes drop the table and recreate it.

Looks like you're looking a little more at a project where SSIS...

ashok.faridabad1984 (5/31/2011)

---

Hi ,

Please explain then why execution plan is index seek for the below query in the same situation ,index created on the table is still non clustered :

select name,id...

Create a proc and exec the proc instead of 4 part truncate.

avir673 (5/31/2011)

---

It's not a nasty comment at all. I just don't understand the point of wishing people a Happy Memorial Day. What is so happy about it? Brave young people...

Dude simple math. You have 2 GB or ram. Most likely all of...

Works for me on sql 2005 with case sensitive server so the query is good.

Are you sure this is sql 2005 and not 2000-?

Can you run that query login in...

Here's another fun test.

Restore 1 small db. Then grow the files by 1 Gb in a loop untill it fails (either drive full or the previous error).

I googled the...

hxkresl (5/30/2011)

---

well, it appears to have worked for some columns but not for all. Some columns are missing a default constraint.

Do I need to add error handling?...

It's just a matter of ordering the output of the command... what have you tried and where are you getting blocked??

Take a backup of a small and try restoring it to the same driver / folder that is giving you the error.

That may also give you an opportunity to figure...

It's quite possible that those errors are due to waits for the db to autogrow. At some point it could also be due to physical fragmentation in the db.

I'd...

Not sure I understand the question. From here on out it's just a matter of knowing which tables / columns need to be changed.

Is that where you need help?

Are you connected on the correct server for the restore?

Does the server have enough permissions to write on the disk(s)?