your required/expected output ?

try this

select

t1.resource_type,

db_name(resource_database_id)as db_name,

t1.resource_associated_entity_id,

t1.request_mode as lock_requested,

t1.request_session_id as spid_of_waiter ,

t2.wait_duration_ms,

(select text from sys.dm_exec_requests as r --- get sql for waiter

cross apply sys.dm_exec_sql_text(r.sql_handle)

where r.session_id = t1.request_session_id)...

@jason,

can u suggest me...

tempdb with size 200 gb .it seems that server might be production or higher region-ed.so restart should be avoided. are you managing tempdb well like multiple files on multiple disks...

Shrinking a Data File brings considerable percentage of Logical Fragmentation and I don’t recommend it.

i would recommend you to study how to manage data files.

anyways Shrinking database can be...

Some shots you need to try

1. Either free some space or change the disk drive where the backup log is being created.

2. How much estimated size would be of...

i am bit confused why only testing mail went well if properties/settings are not good enough.

anyways try below

To set up SQL Server Agent Mail to use Database Mail

...

i dont really find any relevance to first insert these id values . you can populate the destination table irrespective of this column...

i don't get exactly what you are try to get here. please elaborate additionally please give same data with create and insert script to get quicker result.see my signature below

Try with LOOP logic

"catch" works when logic/code under "Try" get failed.

Which table you are talking about ? T table cant have data until we have PK satisfied data. and by design error table population also wrong as every time Sp...

@karthik,

see below code

alter proc p1

as

begin

BEGIN TRY

truncate table error_log

BEGIN TRAN

insert into t

select 1

union all

...

IF this...

Try this

--########## Common Significant Wait types with BOL explanations ##################--------------

-- *** Network Related Waits ***

-- ASYNC_NETWORK_IO Occurs on network writes when the...