What are functions3 6337
how to get the automatic backup of the database in the sql server4 31624
What command do we use to rename a db?5 8336
Which command using Query Analyzer will give you the version of SQL server and operating system?3 12085
What is the STUFF function and how does it differ from the REPLACE function?2 16983
What is the purpose of UPDATE STATISTICS?2 9896
What is de-normalization and when do you do it?3 5414
Explain some DBCC commands?6 13910
What is the purpose of using COLLATE in a query?1 16163
How much memory that we are using in Logshipping Concept?
on line cluster can we make if yes tell me the procedure
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
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
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
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
If user is owning any SQL Objects, can we drop that user
Tell about MOM Tool(Microsoft Operator Manager)?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
application server is slow what may be the problem