Hi Mate,

It has been long time. It was related to db trigger.

Please check db triggers in subscriber site.

Cheers

The problem was solved.

It was related server configuratin.

Thanks.

If subscriber db has database trigger, you get this type of error.

Remove database trigger and run initialisation and then create database trigger gain.

Yes, you are right.

This was the development platform and we haven't enough time.

Thanks.

Hi,

Thanks for your help.

I solved my problem, reinstalling SQL server 2005 as a new instance.

Thanks.

Vefa

It is only instance in my local computer.

I know configuration settings and checked lots of time.

SQL services runs, there is no problem. My problem is only I cannot connect...

SQL Services Account is local system. There is no any problem to run the service.

I tried to connect osql using command line. I got "Multi-protocol Connection" sql server does not...

Hi Steve,

Sorry, I did not understand, What do you mean?

I am not using linked server. It is a local server.

Thanks

I am using instance name. I can connect localhost\SQL2005 but, not connect C0001\SQL2005.

Vefa

I checked. That is correct. I can see as 'c0001\SQL2005'.

It still continue same problem.

In addition, After connecting to the SSMS using localhost, I cannot expand SQL Server Logs. I am getting...

Hi Andy,

You are saying this: "you could update a SQL 2000 server, set SQL2K compatibility, and still use the new behavior"

We are using SQL 2000 (sp4). We have 60,65,70,80 compatibility level,...

In the report parameters screen, Prompt proterties should be nothing. This will solve your problem.

Try this:

select COUNT(distinct ISNULL(col1,'')) from testing_bug