Very useful -- thanks!

Here we have so many databases in SOL server 2000
Now we are manually using this command
DBCC SHRINKFILE (POS_LOG, 2)
Where POS is the Database name
so it will reduce the ldf file size
I want a T-SQL to reduce the size of all the ldf files available in my sql server (all databases) for very week .

I have 5 db's on the server.. how to shrink all at a time.

Also how to create batch file so it may run weekly auto.

Best Regards,

Farhan

You can use the master database to write a script which will call the command for all the database. This should solve the problem for having to call them one by one. If you still have problem contact me at sujitdey1@gmail.com

Can u explain me --
suppose we want to issue a book in our table and total no of books
we have 20.
when we issued book, and then books are not available
A trigger should be fired, and display a error messge..
plz help me

Hi

Before executing the query, call the a select statement with the same where clause and check if the book is already there or not, If the book is not there then show and message do what ever you want. If the book is there than only procede with the rest of the logic

Hi All,

We have a database which was around 259 GB. This is the datafile size - actual data in it was 211 GB, with around 48 GB free. Since it was taking much disk space, we decided to Shrink the file. So, we are running this -

DBCC SHRINKFILE('DataFile',215000)

While it is running now, we are seeing that the usage for data is decreasing. From 211 GB it has now come to 208 GB. The free space it is around 50 GB. I dont understand this behaviour. I believe ShrinkFile won't delete any data, but if that is the case, why is the size of usage decreasing? Anything going wrong here?? Please provide some ideas.

Thanks a lot,

Manoj Deshpande