Hi,

I executed the script from SSMS and captured a network trace with Network Monitor 3.4. I filtered the capture to capture only packets where the source our destination port was...

Hello,

I created a SP with the code I sent before and I also added a SET NOCOUNT ON at the beginning. This way the network traffic generated was very low....

Hello David,

I tried that, but it did not change anything. The DONE message is sent even with the NOCOUNT enabled.

Thanks for you help.

Thanks!

Hi Steve,

I started with a very simple test table and then I added columns using a "wrong" table as reference.

I did some research at Microsoft web site and did not...

I found the cause. All my tables have a timestamp column and this column is causing the script to be generated as vertical partitions would be in use.