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?
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 liv> Hi, someone here was playing with the SQL Server Service Manager application
If you have a default install:
SQL Server - running SQL Server Agent - stopped (used for automating db maintenance tasks etc..) DTC - stopped
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 C> Hi, someone here was playing with the SQL Server Service Manager application
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.
"Glenn Adams [MVP - Retail Mgmt]" wrote:
Have something to add? Share your thoughts — no account required.
Ask the community — no account required