RE: nested triggers

From: Baisong Wei[MSFT] (v-baiwei_at_online.microsoft.com)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 03:51:05 GMT

Hi Trinity,

Thank you for using the newsgroup and it is my pleasure to help you with
you issue. Thanks for your good code that it make me easy to create the
tables in my database. You really make my job easier.

After I ran all your code and then I ran

select * from tcsintraTB_Categories
select * from tcsintraTB_Modules
select * from tcsintraTB_userpages

what I got are:
************************************
0 GENERAL
----------------------------------------------------
A GENERAL Test Description 1 1 1
A GENERAL Test1 Description 1 1 2
A GENERAL Test2 Description 1 1 3
A GENERAL Test3 Description 1 1 4
A GENERAL Test4 Description 1 1 5
A GENERAL Test5 Description 1 1 6
----------------------------------------------------
User1 Home 1000 1 2;3;4;5;6 1

IF I ran
delete from tcsintraTB_Modules

and then ran:
select * from tcsintraTB_Categories
select * from tcsintraTB_Modules
select * from tcsintraTB_userpages

The result sets are:
**************************************
0 GENERAL
----------------------------------------------------

----------------------------------------------------
User1 Home 1000 1 2;3;4;5; 1

Then, I restore all the values in the table and run
delete from tcsintraTB_Categories

then
select * from tcsintraTB_Categories
select * from tcsintraTB_Modules
select * from tcsintraTB_userpages

The result sets are
**************************************
0 GENERAL
----------------------------------------------------

----------------------------------------------------
User1 Home 1000 1 2;3;4;5; 1

Which is the same when you run 'delete from tcsintraTB_Modules' . As the
trigger in the first table 'tcsintraTB_Categories' will delete all the
records in the table2 'tcsintraTB_Modules', so the trigger DO NESTED, which
cause the change in the table3. So, I want confirm that, from you
description, when you just run 'delete from tcsintraTB_Modules' on your
table2 'tcsintraTB_Modules', is the result the same from mine? Could you
double check it?

One more things I have to say is, when I create the table3,
'tcsintraTB_UserPages', I got the warning message:
Warning: The table 'tcsintraTB_UserPages' has been created but its maximum
row size (16100) exceeds the maximum number of bytes per row (8060). INSERT
or UPDATE of a row in this table will fail if the resulting row length
exceeds 8060 bytes.
Warning: The table 'tcsintraTB_UserPages' has been created but its maximum
row size (16100) exceeds the maximum number of bytes per row (8060). INSERT
or UPDATE of a row in this table will fail if the resulting row length
exceeds 8060 bytes.

Also, I change the data in the the enterprise manager of
'tcsintraTB_UserPages' each time I reset the data in the table3.

Looking forward to you reply. Thanks.

Best regards

Baisong Wei
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

Relevant Pages

  • JMI_ITS_TEMP (Agent); Error number: 27160
    ... I have a problem with my replication. ... Warning: only Subscribers running SQL Server 2000 can synchronize with ... Cannot add rows to sysdepends for the current stored procedure because it ... in this table will fail if the resulting row length exceeds 8060 bytes. ...
    (microsoft.public.sqlserver.replication)
  • Re: varchar(8000) versus text field?
    ... declare @tstr2 varchar ... Warning: The table 'Table1' has been created but its maximum row size ... this table will fail if the resulting row length exceeds 8060 bytes. ... >> you'd better watch out for going over the max rowsize. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: maximum row size exceeds
    ... >exceeds the maximum number of bytes per row. ... This is a warning message, ... insert testit (pk, vc1, vc2) ...
    (microsoft.public.sqlserver.clients)
  • question on warnings recieved after running sp_repladdcolumn and sp_repldropcolumn
    ... Warning: The table 'GeneralInventory' has been created but its maximum row ... UPDATE of a row in this table will fail if the resulting row length exceeds ...
    (microsoft.public.sqlserver.replication)
  • Re: webshots
    ... uploading (exceeds their max dimension). ... >i have probably posted this in the wrong newsgroup, if so,sorry. ...
    (microsoft.public.windowsxp.general)
Loading