how to make the tables are empty?

how to make the tables are empty?
in the database:
dbo._refpricepolicyofitem
dbo._refscrapofpackageitem
dbo._refshopgoods
dbo._refpackageitem

BECAUSE ANY INSERT-VALUES THAT I HAVE A media.pk2

NOTE: When you put the command to erase the lines and columns makes erased, but when I open them again filled with other lines appear ..:grr:



If you tell me how to put them to zero would appreciate it.

Thanks before hand.

what db u use !! Staticc DB !!

DB PERFECTION PVP

I truncate the vacuum with but when you open them again appears again what was in that dbo.

and besides I need to insert the primary command if you have not found any export tables of q put media.pk2 could say?

http://www.image-share.com/upload/1411/75.jpg

It achieves these tables empty but I can not insert the lines because I have the main command .. I want to add what I found in the perfection media.pk2 of new

Try to replace in sql code "RefPackageItem" to "_RefPackageItem"

I had not fixed by now if I served, I added the lines but not all lines of 2000 only 200 thousand, has no idea how I can do to add them all insert attempt?

excuse my English

can you upload all sql code?

not only load 200 lines


and there are actually over 200.

I notice it only loads the sql as 200 lines could do not have limits? use the sql 2008

when I go to edit says:

Edit top 200 Rows , know how to set to have no limit?

Tools >>>> Options >>>> Select " SQL Server Object Explorer
and in right window u will find
Value for Select Top <n> Audit records corr "200" Change 200 to 1000000
and
value for Edit Top <n> Rows command "200" Change to 1000000
value for select top <N> Rows command "200" Change to 1000000

hello man

add this line for code

USE [SRO_VT_SHARD]