SQL 6.5 to SQL 7 Trigger problem  
Author Message
Drow





PostPosted: Thu Nov 02 21:44:12 CST 2006 Top

SQL Server >> SQL 6.5 to SQL 7 Trigger problem

Hi,

When I transfer a SQL Server 6.5 database to a SQL Server 7.0, it's fine for
most tables in that database.
However, those Triggers in the SQL Server 6.5 were not transferred to the
SQL Server 7.0.
Would someone give me some advice?
Thanks for help.


Jason

SQL Server154  
 
 
Hari





PostPosted: Thu Nov 02 21:44:12 CST 2006 Top

SQL Server >> SQL 6.5 to SQL 7 Trigger problem Hi,

How did you upgrade from SQL 6.5 to SQL 7.0. If you use the upgrade wizard
then it must upgrade all objects
with out any issues. If you do not want to do upgrade again then script the
trigger from SQL 6.5 and execute in SQL 7.0.

Then query both SQL 6.5 and SQL 7.0 for all user objects in sysobjects table
and confirm all objects were transferred.

Thanks
Hari






> Hi,
>
> When I transfer a SQL Server 6.5 database to a SQL Server 7.0, it's fine
> for most tables in that database.
> However, those Triggers in the SQL Server 6.5 were not transferred to the
> SQL Server 7.0.
> Would someone give me some advice?
> Thanks for help.
>
>
> Jason
>
>