Showing posts with label ihave. Show all posts
Showing posts with label ihave. Show all posts

Sunday, February 19, 2012

How to clear the Conflict tables from database

Dear Friends
I have created a Mearge Replication with name TEST for database DBTEST I
have deleted the same Replicaiton but now in my Database DBTEST i see the
tables with name Conflict_TEST_TableName
How i can clean the same.
Your guidance will enable me to solve the problem.
Thanks and best regards
Shailesh.
Shailesh,
you can drop these tables using query analyser.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

How to check which port that SQL Server currently using?

Hi, I'm trying to connect to MS SQL server using PHP Pear DB package. I
have 2 SQL server running on different machine. 1 is using SQL Server
2000 Standard Edition and the other is SQL server from .NET SDK.
I can connect to the standard edition but not to SQL Server from .net
SDK. Did they use different port? if it is, what is default port for SQL
server from .net sdk? or how to check which port did my sql server is
using right now.
thanks
To view or even specify the port an instance is usin use Server Network
Utility -
http://msdn.microsoft.com/library/de...rver_2epl.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"ricard" <ricard_notrealmail@.example.com> wrote in message
news:uv3x7rhlEHA.2340@.TK2MSFTNGP11.phx.gbl...
> Hi, I'm trying to connect to MS SQL server using PHP Pear DB package. I
> have 2 SQL server running on different machine. 1 is using SQL Server
> 2000 Standard Edition and the other is SQL server from .NET SDK.
> I can connect to the standard edition but not to SQL Server from .net
> SDK. Did they use different port? if it is, what is default port for SQL
> server from .net sdk? or how to check which port did my sql server is
> using right now.
> thanks