which SQL SERVER r u using ? becoz

In SQL Server 2008 Reporting Services (SSRS), only the Report Server service account requires database access; in SQL Server 2005 Reporting...

U CAN REFER THE FOLLOWING ATTACHMENT

You can check your SQL server performance with any specific tool that will also help you to enhance your sever performance ,capacity management ..there are software available for free...

Lepide Event Log Manager am currently using.... the tool provides a simplified platform to centrally archive, consolidate and monitor network-wide Windows and W3C event logs

In this case u may refer this link to solve ur query

[/url]

This should get you what you are looking for. I don't know if there is a better way (I'm sure there is tho) but this seems to work OK for...

There must be an open transaction on table which means there is a lock on table

u can follow these steps

check which query is lock the object u r trying...

SQL Server databases have three types of files:

Primary data files

The primary data file is the starting point of the database and points to the other files in the database. Every...