Check your Truncate command and add

USE [SQL_Monitoring] -- if this is the DBname u specified,everything looks good else.

--clean up sp_who

--here uneed to add USE [SQL_Monitoring] else it will search under master DB by default

use [SQL_Monitoring]

Truncate table [SP_Who_Results]

--run SP_Who

--same for insert

use [SQL_Monitoring]

Insert into [SP_Who_Results]

This means the job wit that name is already been created...

u need to go under the jobs and run it to verify the reports if u get in ur email..

I figured out the issue

ALTER DATABASE [SQL_Monitoring] SET HONOR_BROKER_PRIORITY OFF-- It is not supported in SS 2k5 I commented it out.

and I removed ALTER DATABASE [SQL_Monitoring] SET COMPATIBILITY_LEVEL =...

I figured out the issue

ALTER DATABASE [SQL_Monitoring] SET HONOR_BROKER_PRIORITY OFF-- It is not supported in SS 2k5 I commented it out.

and I removed ALTER DATABASE [SQL_Monitoring] SET COMPATIBILITY_LEVEL =...

what version's of SS will support you did not mention I am getting 2 errors...

Msg 102, Level 15, State 1, Line 2

Incorrect syntax near '90'. ( I changed it to...

Thanks ALZDBA, what exactly does this script do and what I have to fig out in it?

It consumes around 60gb and thing is we do not have any transactions which are 60gb my analysys says out tempdb is not flushing the commited transaction but recovery mode...

There are many reasons why your Db might be slow.,

chcek if there is any long running transaction using DBCC OPENTRAN ('DBNAME') , if u r DBA get ur dev and...

is ur agent running? was there any ad-hoc t-log backup ?

Thanks SSchap...and all you ...it was quite quite simple...

Yes all the objects are in the same server

Yes with common tables, attibutes..no need for data..

by the way we use sql 2k5

Hi ashish thanks for the reply...

can i have the steps please coz i dont see the option for with dataload and I am a newbee here..

Thanks