SQL Server Agent?


Z

Zorian

Hi, someone here was playing with the SQL Server Service Manager application
(in the tray below right) and now I am confused. Should the SQL Server Agent
be on or off? How about Distributed Transaction Coordinator - on or off (or
play/stop?)?

Finally, if I wanted to see the actual database and get in there and edit
fields in raw SQL format...is there any way to do that with the SQL server
app installed with POS or is there some app missing that would allow me to do
that?
 
Ad

Advertisements

O

ozzie

As long as the server service is running then that should be all you need.

I'd advise against editing the database directly unless you REALLY know what
you are doing in there. It is designed weirdly, and much of that design
seems to be aimed at keeping it proprietry.

but if you like living on the edge, sql management studio would be the way
to go.
 
R

root

If you have a default install:

SQL Server - running
SQL Server Agent - stopped (used for automating db maintenance tasks etc..)
DTC - stopped
 
G

Glenn Adams [MVP - Retail Mgmt]

You can run SQL Statements in RMS Store Operations Administrator.
Connect to the database then Query/New. It's brain dead compared to
Query Analyzer or pretty much any other SQL Query tool, but it gives you
basic functionality. You can also use the commandline OSQL utility -
search MSDN or Google for details...

Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
(e-mail address removed)
 
Z

Zorian

Glenn, how do you do that? Is RMS Store Operations Administrator the same as
Store Operations Manager because I don't have the Administrator. And in my
Manager program I did not see any way to connect to database and run Query.
Thanks.
 
Ad

Advertisements

O

ozzie

You'd have Administrator if you have Manager, just go to the same directory
that has the somanager.exe file, and look for soadmin.exe...
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Agents 1
Estate Agents 1
Agent problem 4
Agents fee 14
International "estate agents"? 3
Manchester Estate Agents 3
Estate Agents etc 13
Estate Agents Terms 4

Top