Thanks for the answer.

No, I only want to suppress the information message because I want to create a script text from this script ... 🙂

Greets

pitcher

An idea could be to get the data into arch through linked server on arch pointing to prod. So you can look whether the tempdb of prod would decreasing. if...

Hi,

are you moving your data through linked server?

are you using dynamic sql to execute the batches?

have you examine the tables inside tempdb?

Greets

pitcher

Hi,

first of all in my opinion it is not necessary to shrink the log file periodically because in this case the hard disk would be more and more fragmented. But...

Hi,

have you check the performance of the statements of the app server with SQL Server Profiler to ensure that the statements are not the bottle necks?

The same you should check...