Answer Posted / javed shaikh

HOW TO CHANGE THE MICROSOFT SQL SERVER 2000 PORT ON THE
CLIENT
1. Close the ILLiad Client and any Administrative
tools (Customization Manager, User Manager, etc.).
2. On each ILLiad Client machine, go to the ILLiad
program group and open the Client Network Utility under the
Networking folder.
3. On the right, under the Enabled Protocols, you
should see TCP/IP. Select it and hit the Properties button.
4. The Network Protocol Default Value Setup dialog
will ask for the Default Port for SQL Server (it will most
likely be 1433). Changing this entry will change the port
that ILLiad connects to on the ILLiad/SQL Server.
5. Change the entry and hit OK to close.
6. Hit OK to close and save the changes

Can a table be created inside a trigger?

921

---

What number aggregate functions are accessible there in sql?

1007

---

if no size is defined while creating the database, what size will the database have? : Sql server administration

933

---

what do you understand by change data capture?

935

---

can an order by clause be used in a creation of a view?

1100

---

How can sql server instances be hidden?

894

---

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2027

---

What is transaction server auto commit?

984

---

What are various ways to enhance the ssrs report?

921

---

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

893

---

Where is trigger in sql server?

990

---

How to start sql server browser service?

1066

---

Find columns used in stored procedure?

936

---

How many types of stored procedures are there in sql server?

952

---

what is a deadlock? : Sql server database administration

981

---