Re: [Emerald] SQL Database Transfers

Dale E. Reed Jr. ( (no email) )
Mon, 16 Nov 1998 23:11:03 -0800

Glen Harvy wrote:
> I followed your instructions explicitly using SQL Enterprise Manager. I
> executed each "segment" separately and in the same order. By "segment", I
> refer to the instructions between each GO statement.
> There now exists a table called "CallDetails". I ran your scripts
> yesterday. The new table is empty.
> Since running your script, the Calls On-Line in Emerald no longer works.
> I appreciate the theory in the new table and have no problem with using it
> - if I can get it to work.

Most likely the new trigger did not get installed. Check your calls
table to see if you have an insert trigger named calls_insert on it.
When you run the create trigger portion of the script, what happens?


Dale E. Reed Jr. ( IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today |