How to Trigger a Job on MSDE from SQL Server

Hi,
Can i have "Jobs" on MSDE .
If yes, then i want that jobs to be fired from SQL Server.
Actually what i want is to have one SQL Server, and MSDE on all other
machines. And the central SQL Server would take care of when a perticual job
is to be exicuted.
Can i do this. Will "Linked Servers" help.
Regards,
Raj Dhrolia.Please don't post independently to multiple groups. See my reply in
microsoft.public.sqlserver.tools
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Raj Dhrolia" <rajdhrolia@.hotmail.com> wrote in message
news:O7gGcu00DHA.4064@.tk2msftngp13.phx.gbl...
> Hi,
> Can i have "Jobs" on MSDE .
> If yes, then i want that jobs to be fired from SQL Server.
> Actually what i want is to have one SQL Server, and MSDE on all other
> machines. And the central SQL Server would take care of when a perticual
job
> is to be exicuted.
> Can i do this. Will "Linked Servers" help.
> Regards,
> Raj Dhrolia.
>
>
>

How to Trigger a Job on MSDE from SQL Server

Hi,
Can i have "Jobs" on MSDE .
If yes, then i want that jobs to be fired from SQL Server.
Actually what i want is to have one SQL Server, and MSDE on all other
machines. And the central SQL Server would take care of when a perticual job
is to be exicuted.
Can i do this. Will "Linked Servers" help.
Regards,
Raj Dhrolia.Please don't post independently to multiple groups. See my reply in
microsoft.public.sqlserver.tools
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Raj Dhrolia" <rajdhrolia@.hotmail.com> wrote in message
news:%23YIWPu00DHA.2568@.TK2MSFTNGP09.phx.gbl...

quote:

---

> Hi,
> Can i have "Jobs" on MSDE .
> If yes, then i want that jobs to be fired from SQL Server.
> Actually what i want is to have one SQL Server, and MSDE on all other
> machines. And the central SQL Server would take care of when a perticual

---

job

quote:

---

> is to be exicuted.
> Can i do this. Will "Linked Servers" help.
> Regards,
> Raj Dhrolia.
>
>
>

---

How to trace trigger execution in SQL Profiler?

When I try to trace some SQL statement executions inside a Trigger by using 2005 SQL Profiler, I found even the trigger is fired, there's no any trace about it in SQL Profiler. How can I trace trigger execution in 2005 SQL Profiler?Hi,

have a look here: http://groups.google.de/group/microsoft.public.sqlserver.server/browse_frm/thread/c87621996c73012b

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de