469,568 Members | 1,520 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,568 developers. It's quick & easy.

SQL MSDTC

I'm using msde. On the little icon in task tray, you have under current
service, a choice of mssqlserver, and another choice is msdtc. What is
msdtc? And what is sqlserver agent?
Jul 20 '05 #1
1 1670
JIMMIE WHITAKER (kp*****@worldnet.att.net) writes:
I'm using msde. On the little icon in task tray, you have under current
service, a choice of mssqlserver, and another choice is msdtc. What is
msdtc?
DTC = Distributed Transaction Coordinator. You need DTC when you are
running distributed transactions. That is transactions that involve more
than one server (and the other server does not have to be an SQL Server;
it could be Oracle), and you need two-phase commit. That is, both
servers must commit or rollback the transaction.
And what is sqlserver agent?


SQL Server Agent is a tool that permits you run jobs. These jobs can
run on a regular schedule or they can be one-offs that are only run on
demand. Even for a one-off you can schedule a job to run later, for
instance in the wee hours of night.

Standard usage of Agent in about any production system is to schedule
backups. But you can also use Agent for other things that are to run
regularly. An Agent job consists of one or more steps, and a step can
be a batch of T-SQL statements, but can also be a set of Windows
command-line commands. I think you can run Active-X too.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Gary | last post: by
6 posts views Thread by cylt | last post: by
1 post views Thread by sjoshi | last post: by
6 posts views Thread by =?Utf-8?B?UGF1bCBQcmV3ZXR0?= | last post: by
5 posts views Thread by =?Utf-8?B?QmlsbHkgWmhhbmc=?= | last post: by
1 post views Thread by =?Utf-8?B?QmlsbHkgWmhhbmc=?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.