Answer / Rahul Sanger

To make a remote connection to a SQL Server database, you can use SQL Server Management Studio (SSMS) or ODBC/OLE DB Data Source configuration.n
1. SSMS:n- Open SSMS and connect to the local instance of SQL Server.n- Go to Object Explorer and expand the 'Connections' node.n- Right-click on 'Database Engine' and select 'Connect to Database Engine...'n- In the Connection Properties dialog, enter the remote server name or IP address, Authentication method (e.g., Windows Authentication), and other required details.n- Click 'Connect'.n
2. ODBC/OLE DB Data Source configuration:n- Install the appropriate driver for your operating system from the SQL Server website.n- Open the Data Sources (ODBC) applet in the Control Panel.n- Create a new System DSN or User DSN pointing to the remote database instance.n- Configure authentication and other required settings.n- Use this data source in your application to connect to the remote SQL Server.

What is the meaning of sql server?

1 Answers  

---

Is mysql better than sql server?

1 Answers  

---

How you can add messages to the nt event log from within a stored procedure?

1 Answers  

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1 Answers  

---

Explain the disadvantages of cursors?

1 Answers  

---

How to genrate automaticlly empid like gt001

4 Answers  

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1 Answers  

---

What are examples of triggers?

1 Answers  

---

1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?

3 Answers  

---

Explain about nested stored procedure?

1 Answers  

---

Explain filtered indexes benefits?

1 Answers  

---

How to find out name of all employees who has salary less than 200 Rs.?

8 Answers  

---