database maintenance

[lmo]

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?

 

[Luther]

we are sharing a bcm database with 50 users.  when we look at the pc ofthe
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 bestway
to automate dbcc shrinkfile on each user's computer?  vbs script, sqlcmd?  
does anyone have a sample?

You could look into the Scheduled Tasks applet in Control Panel. Have
it run sqlcmd.