Sage Software's ACT! 2006 Contact Manager is a machine hog.

The install sets it to pre-load something on bootup including MSDE
which is what it runs on if you don't have the SQL Server Version.

On a notebook, even a fast processor, slow spinning hard drive etc. I
don't want MSDE running when I'm not running ACT! 2006, aka ACT! 8.

I have set MSSQL$ACT7 to Manual versus Automatic, so it doesn't start
with Windows, but have to remember to go in to Control Panel /
Services and manually start it before I try to start ACT8.exe.

Is there a way to create a shortcut or DOS Batch file that will start
MSDE, give it time to completely start and then start ACT8.exe ?

--

In message <plov52deqr6cbd63f6488u1pr541fokena@4ax.com>, JDJ
<jj@invalid.invalid> writes
[quoted text, click to view]

Yes. Create a pair of Batch files and use the NET START and NET STOP
commands to Stop / Start the services. I sure BOL covers this info as
well.

--
Andrew D. Newbould E-Mail: newsgroups@NOSPAMzadsoft.com

On Tue, 9 May 2006 01:53:06 +0100, "Andrew D. Newbould"
[quoted text, click to view]

BOL ??

I can see where a batch file would work.

What would be the Syntax of the NET START line...

NET START C:\Program Files\Microsoft SQL
Server\MSSQL$ACT7\Binn\sqlservr.exe -sACT7

If I'm' close do I need quotes anywhere?

????

Also I'm guessing I need to give SQL Server a little time to get
started (maybe not will have to test once I figure out the batch
file). DOS & .bat files were a long time ago...

WAIT....? command?

Thanks for your help
--