* I need to delete all rows of all tables.

I want to use the delete. 😀

Hi Eirikur,

What if I want to delete the rows of a table per batch like for example I want to delete first 500 records so that it will not eat...

Hi Eirikur!!

Thank you so much! It worked! 🙂

hi Eirikur!!!

Yes, that is correct but not drop the table only delete the rows of each table.

here are the sample:

CREATE TABLE dbo.AllTables

(

DatabaseName nvarchar(50),

TableName nvarchar(50),

...

Hi Koen,

I'm trying to restore the backup on my test server but im getting an error. ..mdf is claimed by adv. The WITH MOVE clause can be used to...

Those will work..

http://msdn.microsoft.com/en-us/library/ms175495(v=sql.100).aspx

Btw, You can select which SQL Version you are using by selecting "Other Versions"

hth

Thanks guys! 😀

Thank you! 🙂

sorry, what I meant was.. to truncate the destination table first.

Is there a parameter I can use in bcp to truncate or format the destination table before inserting the data?

Thanks

WOW!! Thank you very much for the replies! I appreciate it so much! 😀

Thank you, Guys! 😀

Thank you! :hehe:

Thank you, Yes, Compat level is 2000. How can I see average fragmentation on my indexes without changing the compat level of the database?

Thanks

Thank you! I used ACE for that one.

Now, I'm getting an error using this code:

select * from OpenRowset('Microsoft.Jet.OLEDB.4.0',

...