hi david

here is my sql statement.

delete from tab_cdtrack where cd_nummer=102018

when i test it in query analyzer its ok, but with isql no chance...

maybe you can help me out there.

urs

when i execute "my" script, then i get an error:

D:\>isql /S CeDe /U sa /P mwxloa -d CeDe_CD -b /m-1 /i D:\Tracks.sql

1> 2> Msg 170, Level 15, State 1, Server...

hi david

thanks for your script. where i have to put the .sql file?

kind regards

hi david

yes why not. do you have an example script to execute this statements in this file.

thanks

urs

hi phil

yes i like to execute the sql statements in this file.

could you help me with an example script?

thanks

urs

hi chris

no, we don't rebuilt it everytime. change tracking /update in background

we added a new column (not an index column) to the table and then the index has to rebuilt....

i realise it, when the website coming slow and slow. i check the database server and see that the population is started without any manipulation from me.

hi allen

there is no schedules for many times a day.

its really strange...

maybe there is another idea?

urs