Can you explain the role of each service?
Answer / guest
SQL SERVER - is for running the databases SQL AGENT - is for
automation such as Jobs, DB Maintanance, Backups DTC - Is
for linking and connecting to other SQL Servers
Is This Answer Correct ? | 0 Yes | 0 No |
How to turn on the mssql api module in php?
What is an example of a foreign key?
How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)
10 Answers Cognizant, Infosys,
how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?
16 Answers Accenture, IBM, Marlabs,
What is a trigger and its types?
How to use column default values in insert statements in ms sql server?
How to delete database objects with "drop" statements in ms sql server?
What will happen if a column containing char type data is changed to the nchar data type?
What are the steps you will take to improve the performance of a poor performing query?
SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.
Explain “not null constraint” in sql server?
Explain few of the new features of sql server 2008 management studio