Thanks for that Satya. It doesn't appear to include the bug that we've come up against, but I'll apply it anyway. I was told that the specific bug...
Apparently this is an active bug and will be fixed in SP3. The only workaround suggested was to split up the publication into 3 separate...
Thanks Dinesh. I experienced performance problems in SQL 2000 when splitting the publication into multiple publications, so I'm not keen to do that...
I've found a way round this by using sp_revokelogin 'BUILTINAdministrators' instead of trying to remove the group via Enterprise Manager. It works -...
Hi, I did change all the database owners using sp_changedbowner. And SQL Server is running under a domain user account. But BUILTINAdministrators is...
After a little more research, I can answer my own question. Apparently there is a specified limit of 256 articles in a merge replication...
Hi all, I've upgraded a SQL 2000 SP3 merge replication publisher to SQL 2005. One publication on this server has over 700 articles and this...
Hi folks, Thought I'd update on the results of the Microsoft investigation for any interested parties: The problem is that the Upgrade Advisor has an...
Thanks Satya, but I have considered the impact of the replication changes and I don't think they apply to this problem. It's very strange. If I run...
I' get the same message whether replication is running or not. Time to contact Microsoft I think...
Hi all, I am attempting to upgrade a Windows 2003 SP2 Enterprise Edition, SQL 2000 SP4 Standard Edition server to SQL 2005. The server has 2 user...
Hi Folks, I've consulted the following doc and the upgrade path SQL 2000 Std (x64) -> SQL 2005 Std (x64) is not mentioned:...
Hi folks, I have a requirement to disable access for the BUILTINAdministrators group to a SQL 2000 SP3a standard server. I have removed...
Hi, Can anyone recommend a product that will examine an Active / Passive clustered SQL server and report on any SQL security vulnerabilities? I...
Hi all, I have a SQL Server 2000 SP3 Active/Passive cluster. I have a requirement to tighten up security and would like to remove the...
Hi all, Can anyone tell me if there is a way in T-SQL to alter an identity column in a table so that the NOT FOR REPLICATION option is set? thanks,...
Hi all, I had a replication problem on one of my SQL Servers. Replication failed continuously with a variety of timeout errors and these errors...
Hi all, I know there is a dodgy way of increasing the number of errorlogs available for SQL Server. Can someone remind me how to do it? thanks,...
You can export the following registry file, save it as a a .reg file and then import it into another machine:...
Hi, I've set up local alerts on all my SQL Servers to send mail to the DBA whenever the alerts are raised. The problem is that if SQL Agent mail...
Separate names with a comma.
