Showing posts with label limitations. Show all posts
Showing posts with label limitations. Show all posts

Tuesday, March 20, 2012

Non-English Characters in Table/Stored Procedure Names

Could you tell me what are the limitations/concerns regarding Non-English characters being used for Table/Views/Stored Procedure Names?

I have been studying that very topic, my web site is built on 12 languages at present, and storing documents with UTF-8 encoding in SQL text fields works well. Its a bit tricky though with HTML tags embedded.|||

See the topic below for more details:

http://msdn2.microsoft.com/en-us/library/ms175874(SQL.90).aspx

|||Thanks!

Saturday, February 25, 2012

No. Of Subscribers in Transactional Replication...

Hi,

I am Using Transactional Replication with Updatable Subscriptions. Is there any limitations in the number of subscribers (Servers) used for this type of replication?

I have a scenario of configuring this replication in 60 Subscribers(Servers). And the replication should be in the Continuous running mode. Will Transactional Replication with Updatable Subscriptions work in this scenario? Or is it meant to work for less than 10 subscribers?

Please reply asap.

Thanks in advance.

Regards,

Swapna.B.

Hi Swapna,

This question has been answered in the following posting.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=754018&SiteID=1

60 subscribers should be fine for transaction replication. However, you should go over the "Considerations for Using Updatable Subscriptions" in following article.

http://msdn2.microsoft.com/en-us/library/ms151718.aspx

Gary

|||

Hi Gary,

Thanks a lot.

Regards,

Swapna.B.