"rikesh patel" <tri***@rukp28.freeserve.co.uk> wrote in message
news:ubgD8RnxFHA.3124@TK2MSFTNGP12.phx.gbl...
> Hi
>
> I have many reports running from a SQL Server DB, from Crystal Enterprise
> reporting system.  However I have noticed some performance degradation,
> and
> I noticed that my TempDB had ballooned in size.  Is there a way to reset
> this?  I tried Shrink, but this did not reduce the size of the DB?
>
> Kind Regards
>
> Ricky
>
> (SQL2K-SP3A/WIN2K-Client/WIN2K-Server/Crystal Enterprise 9.0)
>
>