SQL Server Interview Questions
Questions Answers Views Company eMail

how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.


6 5134

create index a on employee(dno) In this,which index was created?

2 2541

How will u get 5 years back record?

5 5503

What is a materialized view?

3 5362

What is MSDE?

2 2216

How can you see what type of locks used?

1 2843

What is transcation?Plz give One example?

2 2571

Plz tell about backup&recovery?

3 2364

How to find the date and time of last updated table?

3 13766


Karur Vysya Bank KVB,

3 6786

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?


8 5180

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...

Satyam, ADP, Tech Mahindra,

7 7391

which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM


5 6875

can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?

1 2480

can you any body tell me why are go for the rebuild the master database.what is the reason?

2 2193

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

How much memory that we are using in Logshipping Concept?


what exactly sql injuction.how to overcome.....


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i


what are the Prerequisites for Replication?


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?


How to trouble shoot if unable to connect SQL Server


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...


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


If user is owning any SQL Objects, can we drop that user




what is the sql equivaent of the dataset relation object ?


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.


ow to bring suspect mode datbase online from scratch