SQL Server Interview Questions
Questions Answers Views Company eMail

Can we drop user if user mapped to any logins

1 1613

How to transfer Logins from SQL Server 2000 to 2005

2 1552

Issues related in upgrading SQL Server 2000 to 2005 / 2008

719




Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 1556

what is the Ticketing tool used in Wipro technologies at Bangalore...???

Liquid Hub,

4788

find the 3rd max salary

10 4956

How to Handle the exceptions in Sqlsrver 2005??

Wipro, Value Labs,

3 4279

What is best institute to Learn DotNET And SQL in chennai?

912




Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

TCS,

2 2239

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

657

how do u find least salary in a table

4 2982

Delete duplicate records from the table?(Table must have unique id)

TCS, Thomson Reuters,

7 6885

Why we are using the sql language?. What is the purpose of using this?

2 1822

can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)

2 2061

How do you connect 100 files as a flat file sources in one package of SSIS?

2 2631


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What is best institute to Learn DotNET And SQL in chennai?

912


How can we call UDF(User Define Function) using C# code in ASP.net ?

4580


Why we need to use secondry database file? though, we can do same work using primary database file also.

4135


what is the Ticketing tool used in Wipro technologies at Bangalore...???

4788


how to do partition in sqlserver

1264






Call by value and call by reference in procedure and function, with NOCOPY.

98


Issues related in upgrading SQL Server 2000 to 2005 / 2008

719


what is checksum in sql server.........???

338


what is difference between view and Dip.

1137


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1192


your distribution database is full what will u do

907


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

616


can any body tell me how to know the password of current user in sql server

878


what are the critical issues you have resloved in your company

770


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

998