Database objects include all tables, views, stored procedures, extended stored procedures, triggers, rules, defaults, and constraints. The sum of the number of all these...

Use this script in query analyser on the database where you want to shrink your transaction log.

Change the @databasename to your database name

declare @fileid as int

declare @databasename as nvarchar(500)

set @databasename='MyDatabaseNAME'

Select...