When one transaction is trying to access a record, which is used by other

What is blocking in SQL Server? If this situation occurs how
to troubleshoot this issue

Question Posted / shyamsri83

2 Answers
5601 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / shyamsri83

When one transaction is trying to access a record, which is
used by other, then the first transaction has to wait,
untill the second transaction complete. This is called
blocking.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a trigger in sql server?

1165

explain different types of backups avaialabe in sql server? : Sql server database administration

966

Explain what are sparse columns?

988

What is the use of toad or sqldbx.?

1147

How do database indexes work?

1004

How to create view in stored procedure sql server?

1015

How to create hyperlink from returned sql query ?

1121

Explain the ways to controlling cursor behavior?

914

What do you understand by the data quality services in sql server?

944

Explain difference between cross join and full outer join?

1003

Can we insert data into a view?

1130

Differentiate between sql temp table vs table variable?

876

What is indexed view? How to create it?

989

How to find the login name linked to a given user name?

1007

What is amo? : sql server analysis services, ssas

1087