Discussions

I got help from this site:
http://sadeveloper.net/forums/thread/17210.aspx

I want to know:
1) is there is some unique ID for a subscription to a publication (in SQL Replication)?
2) Can this ID be accessed on the subscriber and publisher databases?
3) Is there view/table/store procedure that will give me a list of subscribers at the publisher (that will also expose this unique ID.

This information will be very helpful for partitioning data in our enterprise system that we are developing.
I.e.: A remote site (subscriber) may have read/write access to its allocated data-partition, but only read-access to other data-partitions (obviously only if the particular user has permission to read the data in the partition). The main site (publisher) will allocate each data partition to a subscriber.
This 'unique ID' will help us allocating a data-partition to a subscriber.

I see that the stored procedure sp_helppullsubscription returns a 'subscription guid' column, but MSDN describes the column as 'Global identifier for the version of the subscription on the publication.', so I'm not sure (due to the word 'version' in the sentence) if this GUID will change each time the subscription is resynchronized (or for any other unknown reason)? Also, I cannot find an object that will return a list of subscribers (that include this 'subscription guid') on the published database.

Can't find any NCB files under my project files?

Normally if you use Intellisense in VS you get a short description of what the method does (including the help on parameters). This is obviously the information provided by the XML-comments you add to the class/method/property. However, this just stopped showing up in Intellisense the last few weeks and it is starting to annoy me (even the information of the .NET framework's classes are gone).

Does anyone know how to fix this?

Yes, I think this would work...

But the Application.DoEvents(); will just cause problems... Assuming this algorithm is called from a button-click, it (DoEvents) will enable the user to click the button a second time, thus entering the same method while the previous instance is still running…

Me and 9Guy in Cape Town

Mikyt wrote:

Hi! Charles!

Can I buy the Channel9 toy? http://channel9.msdn.com/Themes/AlmostGlass/images/top_left.gif 

That toy I can find in some videos. 

I like this kind of toy. 

I just sent Charles my address and MS sent me one...

http://channel9.msdn.com/ShowPost.aspx?PostID=255290#255290

Has it not got something to do with quantum physics (rather that being
"electric")?

5 years at my current job (retail application software comp). 20 days (per year) leave after 5 years! Only 15 days before that...

littleguru wrote:



mot256 wrote:Do you know of any setting, in VS2005, that will allow each "Find All References" you do, to open in a new tab? Thus, not overwriting the previous "Find All References" results you just got...

Isn't it always the same window that holds all results? There might be no way to do this.

With the normal find (and find-in-files) you can specify a different tab (in the same window) for every second find (you only have 2 tabs in this case to choose from, but it is already better than "Find All References")

It would be g8 if you could, say, hold down the Ctrl-key while selecting "Find All References" and it then places the find in a different tab...