Monday, February 13, 2012

ËùÓÐÖÐÎİæµÄSQL2000¶&

£Â£Õ£Ç£±¡¢
µ«µ±ÎÒʹÓÃÇëÇó¶©ÔÄÖУ¬¿ªÆôÁË·¢²¼·þÎñÆ÷ÉÏÔÊÐíÄäÃû¶©ÔĵŦÄÜ£¬ÔÚ³õʼ»¯ºÍÆôÓÃͬ
²½Á¬½Óʱʧ°Ü£¬²¢Í¨¹ý²é¿´×÷ÒµÀúÊ·¼Ç¼£¬¿ÉÒÔ¿´µ½ÓÐÈçÏÂÌáʾ³ö´í£º
Category:COMMAND
Source: ʧ°ÜÃüÁî
Number:
Message: exec dbo.sp_MSset_subscription_properties @.publisher = N'NS',@.publisher_db = N'shop40', @.publication = N'shop40',
@.subscription_type = 2, @.allow_subscription_copy = 1, @.queue_id = N'',
@.update_mode = 0, @.attach_version = 0x5a206a87057bac4aa7e89af7bd45fde8,
@.queue_server = N''
ÁíÏÂÒ»²½ÖèÒ²ÌáʾÒÔϳö´íÐÅÏ¢£º
Ϊ¹ý³Ì»òº¯Êý sp_MSset_subscription_properties Ö¸¶¨µÄ²ÎÊýÌ«¶à¡£. ²½Öèʧ°Ü¡£
¾­²é·¢ÏÖmasterÊý¾Ý¿âÖÐsp_MSset_subscription_properties µÄ´æ´¢¹ý³Ì£¬ÐÎʽ²ÎÊý
µÄÊýÄ¿Óëʵ¼Ê²ÎÊý²»Í¬£¬sp_MSset_subscription_properties ´æ´¢¹ý³ÌÖ»Óа˸ö²Î
Êý£¬¶øexecµ÷ÓõÄʱºò¾ÍÓоŸö²ÎÊý½øÈ룬ÆäÖжàÁË@.queue_server Õâ¸ö²ÎÊýÊÇÔÚ´æ´¢
¹ý³ÌÖÐûÓеġ£
£Â£Õ£Ç£²¡¢ÁíÍ⣬ÎÒͨ¹ý²éѯ·ÖÎöÆ÷Ö±½ÓÖ´ÐÐ
exec dbo.sp_MSset_subscription_properties @.publisher = N'NS',@.publisher_db
= N'shop40', @.publication = N'shop40', @.subscription_type = 2,
@.allow_subscription_copy = 1, @.queue_id = N'', @.update_mode = 0,
@.attach_version = 0x5a206a87057bac4aa7e89af7bd45fde8
µ«·¢ÏÖÌáʾÒÔϳö´íÐÅÏ¢£º
¶ÔÏóÃû 'MSsubscription_agents' ÎÞЧ¡£
¾­²é·¢ÏÖ
distributionÊý¾Ý¿âÖв¢²»´æÔÚMSsubscription_agentsÕâ¸öÊý¾Ý±í¡£
µ«¸ù¾ÝÒÔÏÂÁ´½ÓËù˵µÄ£º
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ms-table_9wxf.asp
The MSsubscription_agents table is used by Distribution Agent and triggers
of updateable subscriptions to track subscription properties. This table is
stored in the subscription database.
µ«ÎÒÊý¾Ý¿âûÓÐÕâ¸ö±í¾Í²»ÄܽøÐÐÏà¹ØµÄ²Ù×÷ÁË£¬ËùÒÔ·³Çë½øÐмì²â²é´í£¬²¢Ìṩ²¹¶¡
³ÌÐò¡£Ð»Ð»£¡
£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½
¸½ÎÒSQL ServerµÄÐÅÏ¢
Chinese SQL Server 2000 Enterpise Version + Sevice Pack 3ayous in wrong country chump!
--
Bob M.
"Genius W.H. Chow" <genius-sendmoreinfo@.21cn.com> wrote in message
news:e9aNT5GcEHA.1652@.TK2MSFTNGP09.phx.gbl...
> £Â£Õ£Ç£±¡¢
>
µ«µ±ÎÒʹÓÃÇëÇó¶©ÔÄÖУ¬¿ªÆôÁË·¢²¼·þÎñÆ÷ÉÏÔÊÐíÄäÃû¶©ÔĵŦÄÜ£¬ÔÚ³õʼ»¯ºÍÆôÓÃͬ
> ²½Á¬½Óʱʧ°Ü£¬²¢Í¨¹ý²é¿´×÷ÒµÀúÊ·¼Ç¼£¬¿ÉÒÔ¿´µ½ÓÐÈçÏÂÌáʾ³ö´í£º
> Category:COMMAND
> Source: ʧ°ÜÃüÁî
> Number:
> Message: exec dbo.sp_MSset_subscription_properties @.publisher => N'NS',@.publisher_db = N'shop40', @.publication = N'shop40',
> @.subscription_type = 2, @.allow_subscription_copy = 1, @.queue_id = N'',
> @.update_mode = 0, @.attach_version = 0x5a206a87057bac4aa7e89af7bd45fde8,
> @.queue_server = N''
> ÁíÏÂÒ»²½ÖèÒ²ÌáʾÒÔϳö´íÐÅÏ¢£º
> Ϊ¹ý³Ì»òº¯Êý sp_MSset_subscription_properties Ö¸¶¨µÄ²ÎÊýÌ«¶à¡£.
²½Öèʧ°Ü¡£
> ¾­²é·¢ÏÖmasterÊý¾Ý¿âÖÐsp_MSset_subscription_properties
µÄ´æ´¢¹ý³Ì£¬ÐÎʽ²ÎÊý
> µÄÊýÄ¿Óëʵ¼Ê²ÎÊý²»Í¬£¬sp_MSset_subscription_properties ´æ´¢¹ý³ÌÖ»Óа˸ö²Î
> Êý£¬¶øexecµ÷ÓõÄʱºò¾ÍÓоŸö²ÎÊý½øÈ룬ÆäÖжàÁË@.queue_server
Õâ¸ö²ÎÊýÊÇÔÚ´æ´¢
> ¹ý³ÌÖÐûÓеġ£
> £Â£Õ£Ç£²¡¢ÁíÍ⣬ÎÒͨ¹ý²éѯ·ÖÎöÆ÷Ö±½ÓÖ´ÐÐ
> exec dbo.sp_MSset_subscription_properties @.publisher =N'NS',@.publisher_db
> = N'shop40', @.publication = N'shop40', @.subscription_type = 2,
> @.allow_subscription_copy = 1, @.queue_id = N'', @.update_mode = 0,
> @.attach_version = 0x5a206a87057bac4aa7e89af7bd45fde8
> µ«·¢ÏÖÌáʾÒÔϳö´íÐÅÏ¢£º
> ¶ÔÏóÃû 'MSsubscription_agents' ÎÞЧ¡£
> ¾­²é·¢ÏÖ
> distributionÊý¾Ý¿âÖв¢²»´æÔÚMSsubscription_agentsÕâ¸öÊý¾Ý±í¡£
> µ«¸ù¾ÝÒÔÏÂÁ´½ÓËù˵µÄ£º
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ms-table_9wxf.asp
> The MSsubscription_agents table is used by Distribution Agent and triggers
> of updateable subscriptions to track subscription properties. This table
is
> stored in the subscription database.
>
µ«ÎÒÊý¾Ý¿âûÓÐÕâ¸ö±í¾Í²»ÄܽøÐÐÏà¹ØµÄ²Ù×÷ÁË£¬ËùÒÔ·³Çë½øÐмì²â²é´í£¬²¢Ìṩ²¹¶¡
> ³ÌÐò¡£Ð»Ð»£¡
> £½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½
> ¸½ÎÒSQL ServerµÄÐÅÏ¢
> Chinese SQL Server 2000 Enterpise Version + Sevice Pack 3a
>

No comments:

Post a Comment