Hi all thanks for ur all respond but what is bothering me is the space that has been assigned 300 gb and the data is not using that 300 gb...

the mentor of this blogs please help:-)

Koen Verbeeck (10/3/2013)

---

Your caps lock seems to be broken.

On topic: you can query the SSRS Webservice to get the report in HTML format. I'm no Cold Fusion expert, so it's...

GilaMonster (9/30/2013)

---

Not enough information to help. Exact statement that is being blocked. Exact statement (not batch) that is causing the blocking. The Wait time. The exact lock types. The object...

GilaMonster (9/30/2013)

---

Ok, so something (unknown) is causing something else (unknown) to be blocked for (unknown) duration with (unknown) lock types requested and (unknown) lock types held on (unknown) objects.

Good luck...

Gila,

the wait time is 1 minute minimum for a blocking email(alert) to be triggered and i get like more then 5 blocking email.:-)

thanks

Ivan

according to the blocking email it sometime select statement or update statament

IS BLOCKING POSSIBLE If I run INDEX REORGANIZE job ??????

john every time the query is different and i know u making a point of another task or session running @ that point of time every day same time...

IF the blocking occurs more then 1 i get the email alert with a attachment containing all the session query with each and every details what blocked which query blocked...

well gila i have the details of which all others query was running @ that point of time but alter index reorganize is the head of the blocking chain.

john

yes i have automatic blocking alert also with the details which is causing the blocking with query and time and etc .

but here my question is when i...

Well that is not the issue over here plz read my question throughly and then reply.

yes that is what i am asking i am getting blocking email when ever this job is running so asked you all to help me to find a solution .

below is the script that i use to reorganize the index

DECLARE @Database VARCHAR(255)

DECLARE @Table VARCHAR(255)

DECLARE @cmd NVARCHAR(500)

DECLARE @fillfactor INT

DECLARE @Statement NVARCHAR(300)

SET @fillfactor = 90

DECLARE DatabaseCursor...