we are sharing a bcm database with 50 users. when we look at the pc of the
users, the local copy of the file grows to 1+GB. If we use dbcc shrinkfile
on the local user's pc, the size goes to about 200MB. What is the best way
to automate dbcc shrinkfile on each user's computer? vbs script, sqlcmd?
does anyone have a sample?