you can use version control tools like MS Visual Source Safe,

ClearCase ...

it is not a better advice to write a DDL Trigger on Production Server.

please correct me if i am...

i mean to say comparing with SQL 2000

selecting serverproparty('collation') will return defaulr SQL_Latin1_General_CP1_CI_AS (if i am not wrong).

but As 2005 introduce Schema feature which becomes

Case-Sensitive combination of schema and tablename.

which...

Thanks for reply chirag.

I have used the word "default" in the question.

Regards

Manoj

Hadrian,

alternate way is..

create table #tbsize (dbname sysname, dbsize dec(15))

declare @b-2 numeric(12,2) select @b-2 = low from master.dbo.spt_values where number = 1 and type =...

TRy This Commands:

DBCC shrinkfile (filename, expected size in MB , notruncate)

After Executing Above Next Step:

DBCC shrinkfile(filename, expected size in MB , truncateonly)

Hope your problem will solve.

regards

Manoj

i think we should have SP3 before release of 2008.

Regards

Manoj

SELECT * INTO New_Table_Name From Old_Table(View) will definately work properly over here.

Regards

Manoj

your log size is in GB while Data file size is in MB, it seems you are not taking backup of log.

if log backup is not necessry for you then...