Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

0 Answers  

---

How to run sql server 2005 books online on your local system?

0 Answers  

---

Explain what is log shipping?

0 Answers  

---

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

0 Answers  

---

What is an execution plan? When would you use it?

0 Answers  

---

---

How to download and install microsoft .net framework version 2.0?

0 Answers  

---

What is the STUFF function and how does it differ from the REPLACE function?

2 Answers  

---

What happens when transaction log is full?

0 Answers  

---

What is the purpose of indexing?

0 Answers  

---

Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

5 Answers   TCS,

---

What happens on checkpoint?

0 Answers  

---

Explain the advantages of merge replication?

0 Answers  

---