Answer / Ashutosh Sarin

SQL Management Studio (SSMS) does not have a server name. Instead, SSMS connects to and manages various instances of SQL Server databases.nnTo specify the server name when connecting to an instance of SQL Server using SSMS:
1. Open SQL Management Studio.
2. Click on Connect in the Home tab.
3. In the Connect to Server dialog box, enter the server name or IP address and other connection details such as authentication type and database name.
4. Click Connect.

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

2 Answers  

---

What are the steps need to be take improve the speed of a SQLDATA Server?

2 Answers   IBM,

---

What are the five characteristics of good data?

1 Answers  

---

What do you understand by user-defined function in the sql server?

1 Answers  

---

How many types of functions are there in sql server?

1 Answers  

---

Where in ms sql server is ’100’ equal to ‘0’?

1 Answers  

---

What do you understand by sql server agent?

1 Answers  

---

What is the difference between delete and truncate statements?

1 Answers  

---

What is the use of sign function?

1 Answers  

---

What is a schema in ms sql server 2005?

1 Answers  

---

What are examples of triggers?

1 Answers  

---

What are recommended options to be used while using db mirroring? : sql server database administration

1 Answers  

---