>Hi,
>I'm using "create sql view ...." to create a sql remote view
>every time when I run the procedure. I found that the size of
>database will growing larger even when I use the same view name
>every time. How can I create a fresh new view which will overwrite
>the old one? I have tried to reduce the database size by packing it.
>But I can't do it always because it must be used exclusively.
>Do you have any idea on this issue ?

Create it in the temporary database.