A few weeks back I was working on sync framework issue which i found worth blogging, we were using Win form application that uploads the data using ado.net sync framework v2.0, on the server side there is a WCF application to which the data is uploaded...

While doing a file Sync we may see error that the metadata store replica is already in use. This happens after the first file Sync operation succeeds , subsequent attempts for file Sync operations results in the above error. ...

I ran into an interesting situation when executing a Remote Stored Procedure on Linked Server using four part query. Vista-3139 which is a SQL Server 2005 instance is linked to the SERV2003\SQLDUMMY which is a SQL Server 2000 named instance. ...

We had a case recently where the Default instance of SQL Server was listening on a non-default port. Any guesses what happened when the client tried to connect to the Default instance using TCP? Reading KB 823938 will provide a clue but doesn...

Recently I was working with the legacy Execute DTS 2000 Package Task in SSIS and found that In the SSIS Control flow when you use an Execute DTS 2000 Package Task to run a DTS 2000 package, if the DTS package fails, the resulting error in SSIS can be...

We know that with the default setup of SQL Server (SQL Server 2000/2005/2008), the ‘Default’ instance listens on TCP port 1433. But we have seen that some customers prefer running SQL Server ‘Default’ instance on a TCP Port other...