The merge process was unable to create a new generation at the 'Subscriber'.

The replication monitor shows no errors, and the agent appears to be stuck on "Uploading data changes to the Publisher."

After 30 mins the agent fails with the following message.

The merge process was unable to create a new generation at the 'Subscriber'.

I tried "update sysmergepublications set [generation_leveling_threshold] = 0"
on both Subscriber and Publisher, still it didn't work.

Then I tried "select count (*) from dbo.MSmerge_contents" and "select count (*) from dbo.MSmerge_genhistory" on the Subscriber

The both query was running indefinely with no results, instanly I realised there is some Locking problem.

In desperation I restarted the Subscriber Database Engine and started the Agent.

Magic! Replication was successfull.

SQL Server Reporting Services 2005 Date format Bug

Hi,

Change the Culture in Report.aspx to

<%@ Page language="c#" Codebehind="Report.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.ReportWrapperPage" EnableEventValidation="false" Culture="en-GB"%>

Report.aspx file path :

C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\Pages

How to : Solve " Server is not configured for DATA ACCESS " error in SQL Server 2005.

Execute the below query :

exec sp_serveroption 'SERVER NAME', 'data access', 'true'

And finally Restart the MSSQLSERVER Service.

How to : Change Instance Name of SQL Server 2005

Here are the steps to perform the change:

1. Open SQL Server Management Studio and click New Query.

2. Type Select @@ServerName to verify that the server name is correct or incorrect. In this example, I changed the Windows 2003 from WIN2K3R2EE to SQL Server.

I did not change the name in SQL Server 2005. It will still return the old name. Let's fix it.

3. Next, type sp_dropserver ‘WIN2K3R2EE’

4. You are now ready to add the correct name by typing sp_addserver ‘SQLSERVER’. local

5. Restart sql server and the sql server agent by opening a command prompt and typing net stop mssqlserver and net start msssqlserver. To stop and start the sql server agent, type net stop or start sqlserveragent.

6. Click New Query in SQL Server Management Studio and type select @@servername to verify everything is correct and you have successfully changed the sql server name.