What are functions3 5656
how to get the automatic backup of the database in the sql server4 31162
What command do we use to rename a db?5 7827
Which command using Query Analyzer will give you the version of SQL server and operating system?3 11749
What is the STUFF function and how does it differ from the REPLACE function?2 16399
What is the purpose of UPDATE STATISTICS?2 9276
What is de-normalization and when do you do it?3 5056
Explain some DBCC commands?6 13236
What is the purpose of using COLLATE in a query?1 15680
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What is RMS migrations?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
sql database suspect We have a sql database that is showing as suspect. How can we recover?
How can we call UDF(User Define Function) using C# code in ASP.net ?
What are the dis_advantages of stored procedures, triggers, indexes?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
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.
how to overcome kernel isssues
Tell about MOM Tool(Microsoft Operator Manager)?
System variable and temporary variables
how many no of arguments can be passed in procedures and functions
what exactly sql injuction.how to overcome.....
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
You are doing log shipping due to some reasons it is failing. How you will proceed from there