By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,892 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

can you launch a crystal report from a sql trigger

P: n/a
and if so does anyone know where I can find some code examples?

thanks

Mar 21 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
eighthman11 wrote:
and if so does anyone know where I can find some code examples?

thanks


Can you explain what you mean by "launch"? A trigger has no UI so
no-one could see a report "launched" from a trigger. In principle you
could invoke some process external to SQL Server but that would
generally be a very unwise thing to do from a trigger. Especially if
that external process accessed the same table that fires the trigger.

You can run .NET code from a trigger in SQL Server 2005 although I have
yet to see a good example of a use for that feature.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/m...S,SQL.90).aspx
--

Mar 21 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.