ok.Thanks for replying. But is that safe?Is there not a risk of corrupting the database ? The database is currently about 7 Gigabytes

Also, when I run "database shrinking", either from...

hi

how do you cancel the shrinking process ? The cancel button is disabled. The only way I have found to do it is to close SQL SERVER Management Studio altogether.

tried copy/paste to notepad n copy/paste back. same prob.

As a last resort i will retype the whole code. But it contains

2185 lines!!!!!

At line 1319, there is only the word OR. Pls see snippet below.

---------------------- Snippet below ----------

ANDc.CreateDate<=(CAST((CAST (datepart(yyyy,getdate()) AS VARCHAR) + '-' + CAST (datepart(mm,getdate()) AS VARCHAR) + '-' + '01'...

I think there is a confusion here. Allow me to clarify...

After u suggested that I replace char(13) by char(10), I tried 2 things.

1. I made a php script to replace...

Thanks for the tip.

But how can I change char(13) to char (10)? They are both linebrakes and I cannot do a find and replace.

I have also tried pasting the code...