Ramesh,

Following your scenario, here is my take:

1.will the schema chages will be propagaed to the subscribers automatically?

-- Yes, depending on your article properties. If you went by default, the existing...

It appears that your system tables (Msmerge_contents, MSmerge_tombstone and Msmerge_genhistory) have grown enogh to give you grief. As you want to reinitialize, here is what you need to do.

1. Alter...

Could you think of any server level or Query Analyzer level settings which would cause it to behave different on my side ? I am also curious to find out...

Sorry Vitaly that I forgot to mention to reboot after renaming the server. Connect to SQL Server using the new computer name after you have restarted the server. Then run...

Thanks for your response Brian.

I ran the test you showed. I see an entry in syscacheobjects for the first query, however, I do not see an entry for the second one. I do...

Here are the steps involved:

1. Rename the server in Windows.

2. Use sp_dropserver and sp_addserver. Refer to BOL 'Renaming a Server'

3. Refer to the following article too. http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b303774

4. Stop and...

Thanks to all for your responses.

I should have worded my question a little better. Aaron caught the drift of my question though. My question was specifically referencing ad hoc...

Of the three, the one that worked out best for us is 'Microsoft OLE DB Provider for Oracle' . We tried in vein to use Oracle Provider for OLE DB, however,...