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 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,...
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...
Hi everyone, I've just started work in a new company where all their SQL servers have been installed with codepage SQL_Latin1_General_Cp1_CI_AS...
Hi folks, I have a large number of merge replication agents that I need to disable. Rather than using Enterprise Mananger to disable each one in...
Separate names with a comma.
