Thanks Jeff,

Thank you

After running dbcc spaceused, I ran the sp_spaceused now there is no negative numbers

SP_spaceused

Results:

Database_name database_size ...

Do you want me to move the E drive to passive node and check if I can see something?

is this any thing related to NOT installing any cumulative updates after...

Thank You

I followed the steps we discussed.

1.To avoid this error:Msg 1940, Level 16, State 1, Line 2

Cannot create index on view 'dbo.ANLResourceHits'. It does not have a unique clustered index....

yes, the E drive is a clustered resourece.

Here its showing total paging file size for all drives as 2046MB.If we move these 2046MB size paging files from C drive to the 'E',we can see 2046MB on E...

Thank you,

I did the following:

Right click on My computer then drill down to

System Properites

Advanced (tab)

Performance - Settings

Advanced (tab)

Change

here,

Drive: ...

Hi,

I followed below steps:

1. Script out the database .In management studio, Database->tasks->Generate Scripts->In the wizard choose database and script all objects in the selected database->next->'In choose script option' page everything...

Thanks Edogg....

Dead lock occured again. I have couple of questions:

1.In this dead lock, SPID 90 is automatically killed by SQL Server right?

2.what is the dead lock duration ?(Here, I can...

Thanks Manu,

After executing the commands, I got the below results

select suser_sname(owner_sid)As JobOwner from sysjobs

where suser_sname(owner_sid)<>'sa'

Result:

ABC\admin

ABC\admin

ABC\admin

ABC\admin

Here ABC is the Server name, from which Iam transfering the jobs to other server...

Hi,

here is the script to find the datafile size and logfile size.But it is giving for the database in which we run it.

Could you plz make it work for all...

is there any script to get an alret whenever a deadlock occurs?

Hi Gail,

here, are the two stored procedures involved in the deadlock OR the two tables with object ids

select object_name(1224065284)

select object_name(1775657719) were involved in the deadlock?

I checked fragmentation of...

thank you very much...

The procedure abc_Activity_Inquire is in different database whose dbid is 12. the dbid =9 is a different database, which does not have the procedure abc_Activity_Inquire .

is...

how can we know in which database the dead lock has occured from the information I got from error log?