| Other SQL Server Interview Questions |
|| Asked @
|A successfully created SSIS package in SQL Server 2005 runs
fine in MS BIDS and Integration Services. But gives error
when run through an SQL-Job. What are the possible reasons?
|Can a stored procedure call another stored procedure. If yes
what level and can it be controlled?
|When you first load SQL SERVER you will startup with what
|How to a Query to copy data from on table to another table.
|Create Index myIndex On myTable(myColumn)
What type of Index will get created after executing the
|Anyone please explain me the concept of Serialization?
|Define Check points and End Points?
|How to delete duplicate records from a table?(for suppose in
a table we have 1000 Records in that we have 200 duplicate
Records , so ,how to findout that duplicate Records , how to
delete those Records and arranged into sequence order? one
more thing that there is no primary key at all)
|How to Rebuild Master database in sql server 2005.
|How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
|How do we get month name in SQL Server 2000, Oracle, MS Access?
|Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)
|For more SQL Server Interview Questions Click Here |