Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How can you see what type of locks used?

Answer Posted / ranjit

sp_lock to view type of lock applied

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between local and global temporary tables?

1127


What number sorts of privileges are accessible in sql?

1017


How many null values we can have in a unique key field in sql server?

933


How will you know when statistics on a table are obsolete?

1064


What is database replication?

1116


What is indexing and its types?

1000


What are the purpose of Normalisation?

1039


What is sql server replication? : sql server replication

965


Differentiate between a primary key and a unique key.

1050


Explain what are the restrictions that views have to follow? : SQL Server Architecture

1031


Explain the cursor lock types?

1029


How to enter date and time literals in ms sql server?

992


What is difference between foreign key and unique key?

997


What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

887


How to drop an existing table with "drop table" statements in ms sql server?

1067