Since there are several different editions of SQL Server 2005, how can I find out which edition is installed? Is there a command or a menu item that can display this information? Help->About only gives the version number, not the edition name. I needed to find out whether the SQL Server 2005 on a machine is the Enterprise edtion or not.
Thanks,
Dandan
This works great. Thanks very much :)
Dandan
Under EM's Replication Monitor/Publishers/pub1/publisher1 there is a "Validate Subscriptions" option on the right-click menu. Since I see unexplained Replication Validation activity I think that the "Validate Subscriptions" option is turned on. But there is no "turn-off" button or way to say "stop." Does anyone know how this "feature" works?
Thanks
I would suggest that you script the publication out and look at it in Query Analyser.
It may not be obvious what the parameter is as sometimes the description we see in the GUI is far different from what the parameter might mean. You can always look up the parameters in BOL to make sure you understand them.
We have previously used this technique to set some of the less obvious options.
|||Thanks for your response. I did what you suggested and I see nothing suggestive of validation. It must be hidden elsewhere!
|||Does your agent job have a parameter -Validate 1 or -Validate 3?
Also check if any of your agent profiles have this parameter set.
