SQL Server Interview Questions
Questions Answers Views Company eMail

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


6 5437

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

2 2653

How will u get 5 years back record?

5 5696

What is a materialized view?

3 5532

What is MSDE?

2 2424

How can you see what type of locks used?

1 2984

What is transcation?Plz give One example?

2 2697

Plz tell about backup&recovery?

3 2572

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

3 14132


Karur Vysya Bank KVB,

3 6961

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 5424

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 7668

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


5 7069

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

1 2627

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

2 2323

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?


how to use DTS package in 2000,2005,2008 in sql server


You are doing log shipping due to some reasons it is failing. How you will proceed from there


your distribution database is full what will u do


What is RMS migrations?


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 ...


How we create SQL Server 2005 Reporting Services ? Give me Sample


role of sql sever 2005 in database rather than any other database


whats the maximum size of view state??


wat wil hapn if we give the both read and deny read permission to user?


Tell about MOM Tool(Microsoft Operator Manager)?


on line cluster can we make if yes tell me the procedure


Delete duplicate rows without using rowid.


Scalability, Availability, Integration with internet, etc.)?