Its sql server 2000

I found this error in my job history

User does not have permission to perform this action. [SQLSTATE 42000] (Error 15247)

or is there any way to shrink .

so plz tell me what can i do in this situation .Because there is no more disk space on drive .Please give me any tsql or any suggestion to solve...

Thanxx ,

John for ur reply but i just want to see that which processes are blocked from last 20 minutes I have another query as well but i am...

Yes msdb is online bcuase i can retrieve details from systemtables .I used this query to see failed jobs otherwise i need to go through ssms and send the...

I have login as sql admin

Hi,

I cant retrive from user tables .i will try to run this but i cat access

select * from dbo.sysjobhistory

still i got this error .

Server: Msg 208, Level 16, State...

Hi,

There is query which works with sql 2005 .

SELECT TOP 50

(qs.total_logical_reads + qs.total_logical_writes) /qs.execution_count as [Avg_IO]

...

Hi,

Thaxx but this query not showing long running queries its just showing how much time it taken i need long ruuning queries.

Regards

Jagpal singh

Thaxx,

ALZDBA for this script but it doesnt work with sql 2000

Regards

Jagpal singh

Hi,

Thaxx for ur reply but i just want to know that blocked processes and blocked users are same thing .

or i have this query to see blocked processes but it...

hi,

thaxx for reply i know these syntax but i need more information about this .

yes but i need another script like in which i can attach that detach file with one script .

Hi,

Really thaxx to everybody i have done what i need

select

BackupDate = convert(varchar(10),backup_start_date, 111),server_name,name,database_creation_date

, CAST((floor( backup_size/1024000000)) AS VARCHAR) + ' GB'as sizeinGB

from msdb..backupset...

hi,

thaxx to both of u really thaxx but still i got error from these queries .

There is an error in the query. Invalid object name '#temp'.