I am running the following t-sql code while performing a refresh to TEST. The problem is the DBCC Shrinkfiles are done, but VC still thinks the task is running. I am currently running 8.2.3 VC. I purposely broke up the shrink with checkpoints to keep it from dragging for too long.

Thank you!

DBCC SHRINKFILE (N'Bairds_Build' , 128000)
CHECKPOINT
DBCC SHRINKFILE (N'Bairds_Build' , 123000)
CHECKPOINT
DBCC SHRINKFILE (N'Bairds_Build' , 118000)
CHECKPOINT
DBCC SHRINKFILE (N'Bairds_Build' , 115000)
CHECKPOINT
DBCC SHRINKFILE (N'Bairds_Build' , 113000)
CHECKPOINT
DBCC SHRINKFILE (N'Bairds_Build' , 110000)
CHECKPOINT

We have no experience of that specific command. Not sure why it hangs but it sounds like this would be better off in a stored procedure?

---

Ok, I can experiment with that. It is a stored procedure already, but I will see if I can come up with a notifier that will help VC know that it's done.

Thank you!

Ok, I can experiment with that. It is a stored procedure already, but I will see if I can come up with a notifier that will help VC know that it's done.

Thank you!

If it completes to early it means that your stored procedure spawn of the commands instead of waiting for them to complete.

---