.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal

Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions

Which system procedure is used to find out lock details about the databases, it's table and procedures.

Posted By :Virendra Dugar     Posted Date :November 20, 2009    Points :10   Category :Sql Server 

You can also find related Interview Question to Which system procedure is used to find out lock details about the databases, it''s table and procedures.  below: 

Which system table holds the details of all the processes running on the Microsoft sql server?

The name of the system table is sysprocesses .

Select * from sysprocesses

Make sure you run this query in master database. (More...)

How can we find the open transactions details in sql server?

Yes, it is possible.

select * from sysprocesses where open_tran > 0

This query will provide list of all the open transaction details. (More...)

Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

For restoring the master db we have to stop the SQL Server first and then from command line we can type SQLSERVER -m which will basically bring it into the maintenance mode after which we can restore the master db. (More...)

I can't seem to find System.Windows.Forms.Integration, where do I find it?

The System.Windows.Forms.Integration namespace is defined in WindowsFormsIntegration.dll which currently ships in the WinFX SDK, not in the standard redist. Therefore, the file will be found in "\Program Files\Reference Assemblies\ Microsoft\Avalon\v2.0.50215?. (More...)

Where the login details are stored? in which db & table?

They get stored in master db in the sysxlogins table. (More...)

what is the use of sp_who System Stored procedure In Sql Server?

Provides information about current Microsoft® SQL ServerT users and processes (More...)

SQL Query to find the 4th highest Value in a Table.

Let us assume that we have Table with Student Name and Mark. We have to Find out 4th highest mark from here?


How to find how many instance is running in local system?

For 2000 :

Step 1 : Run-->CMD-->c:\isq -l


step 2 : use master(QUery Analyzer)

Exe master..xp_cmdshell 'isql -L'

For 2005 :

Step 1 : Run-->CMD-->c:\osq -l


step 2 : use master(Query Analyzer)

Exe master..xp_cmdshell 'isql -L' (More...)

how to find the table name in sql server database?

select * from INFORMATION_SCHEMA.tables where table_name like 'tblname%' (More...)

how to find column name from sql server table?

select * from INFORMATION_SCHEMA.Columns where column_name like 'colname%' (More...)

How to find out Second highest salary from a table?

select max(salary) from emp where salary not in(select max(salary) from emp) (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend