You can shrink the database file by using the following method.
DECLARE @strDatabaseName nvarchar(255)
SET @strDatabaseName = "YourDatabaseName"
DBCC SHRINKDATABASE (@strDatabaseName, 0)
Working in both SQL 2005 & 2008.
For Your Information
How to shrink the tempdb database in SQL Server
BTW, after this comment
], I have created this Tip/Trick. Thanks to him.
Programmer | Dude | ||||||
About him & his blog? check out here
. Currently he's updating the site, he'll return soon there with more things*
In Codeproject, he posted a blogpost
& more than couple of Tip/Tricks
, hope he'll write more soon.
Favorite techs are MVC, WCF, Mobile, HTML5, CSS3, jQuery, etc.,
His hobbies are watching movies, CP, being alone, etc., But now he's working on something*