Help get this topic noticed by sharing it on Twitter, Facebook, or email.

shrinkfile procedure

I need to run the shrinkfile procedure but I keep getting syntax errors.

I've been using this method to run other stored procedures but its not working with shrinkfile.

Any ideas ??

declare @x int; exec @x=SHRINKFILE('name_of_logfile', 0, TRUNCATEONLY); select @x

Error is: Incorrect syntax near 'name_of_log_file'.
1 person has
this question