Re: Which Agent to use?

SQL Server 2005 Server Agent for SQL Server 2000 SP4

I never knew there was such a beast! Thanks!!
Harry

"Alberto Silva - Mobile Devices MVP"
<albertosilva@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CC372266-A35E-4974-9D7F-C8BD0BC26B30@xxxxxxxxxxxxxxxx
The thing about non-supported scenarios is that you never know when they
may fail, and there's no way to get support in such situations.

Officially...
- If you use SQL Server 2005 on the server, you must use the SQL 2005
Server agents, and SQL Mobile 3.0 on the device
- If you use SQL Server 2000 SP4 on the server and SQL Mobile 3.0 at the
device side, you have to install the SQL Server 2005 Server Agent for SQL
Server 2000 SP4

--

Alberto Silva
Mobile Devices MVP @pt
http://msmvps.com/AlbertoSilva

"Harry Simpson" <harry.simpson@xxxxxxxx> wrote in message
news:egtvteQNHHA.1276@xxxxxxxxxxxxxxxxxxxxxxx
I'm using RDA to grab data from a SQL Server 2005 database. Apparently,
at least in debug run on the device mode, it works great calling the CE2
dll - getting data back etc.

Do I need to be using CE3 agent or does it really matter?




.

Relevant Pages

  • Re: after system restore the agent does not start
    ... The restored server has exactly the same name as before. ... SQL Server Agent ... SQL Server Service uses the error log file e:\MSSQL\log\ERRORLOG, ...
    (microsoft.public.sqlserver.server)
  • Re: Publishing data while using same server as distributor
    ... server service and sql server agent. ... and this account must be a local administrator. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • RE: GPRS replication troubles
    ... 28557 = "The SQL Server CE database cannot be used for replication. ... and then re-create the database." ... the CE device by going to the URL for your Server Agent in Pocket Internet ... string "SQL Server CE Server Agent". ...
    (microsoft.public.sqlserver.ce)
  • Re: SQL Server 2000 failed to restart after NT Server reboot
    ... The event log only showed that the SQL Server was shut down and the ... server agent service was stoped by request at 11pm on Saturday. ... the SQL server might not be asked to restart by the ...
    (microsoft.public.sqlserver.tools)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
Loading