Did you know… You will receive “Cannot open the PST because it is in use.” error when you configure SQLMail to use an internet mail server by using Outlook 2003

It is not recommended that you use Outlook 2002 or Outlook 2003 together with SQL Mail and with Internet mail servers that use SMTP or POP3. More info on this is available at http://support.microsoft.com/?id=897349 . Below is a practical workaround if you really need this to work. Plan here is to make sure SQL Agent…

0

How to setup a SQL Server Replication between three servers in a typical scenario..

Three Servers (Top, middle and Bottom) Data will flow from Top to the Bottom Server. Top to Middle Server (one way Replication) and Middle to Last Server (two ways Replication).   =================================================                                                  —->Top Server—-> Middle Server         Last Server                                                  <—- ==================================================   In order to get this replication topology done, we can use…

1

Did you know… Because of Collation settings for the database in SQL Server, you may not be able to navigate through the Database objects in Enterprise Manager

At times, when you try to open the tables within a Database in SQL Server 2000 Enterprise Manager, you may see below error(s):   1. Error while trying to explore table from Enterprise Manager: —————————————————————————————————– “Error: 2775: Code page 850 is not supported by the operating system.”   2. Error while trying to open tables…

1

Did you know… When we rename a domain group in Active Directory, we can have some issues related to the login in SQL Server

Sometime back I got to work on an interesting issue related to the login on the SQL Server replication.  The Active Directory group we used to grant access to a snapshot publication does not show up in the Publication access list anymore when viewing the properties of the publication. However, the AD group does show…

1

Did you know… SQL Server 2000 cluster Resource Fails to come online with error SuperSocket Info: Bind failed on TCP port 5184 reported in errorlog!

In order to change the Virtual IP of the sql server 2000 clustered instance we need to follow the following KB article http://support.microsoft.com/kb/244980 However If we try to change the Virtual IP by mapping the Virtual Server Name of the sql server resource to the New Virtual IP in the DNS alone then sql server…

0

Step by Step Procedure to Implement SQL Server Transactional Replication with Oracle as Publisher

/*** Note: Kindly follow the Instruction in each step ***/ /*** If you are using SQL Server 2008 Management Studio, Ctrl-Shift-M might not work. In that case go to “Query” menu and click on “Specify Values for Template Parameters” ***/ 1) Logon to ORACLE database as SYSDBA and follow the below steps a) Create Tablespace…

4

SQL Server can perform slow after changing the Cost Threshold for Parallelism

We have observed a few cases now where sql server has started performing slow after changing the Cost Threshold Of Parallelism server option of the sql server.   Ironically in such cases we observe that sql server is performing slow even when there is no high CPU utilization and no high I/O operations on the…

1

Did you know… The applications like Infopath may fail to submit data into table in SQL Server if the table is included in Merge replication

You are able to submit the data in the table using the application like InfoPath 2007 but when you go ahead and add the table in the Merge Replication Publication, the insert into the table using the InfoPath form starts to fail. This issue occurs when we have the application designed to insert data into…

1

The subscription fails to Sync with the Publisher and marked inactive even though the settings have been configured to “never expire”

We get the below error message when distribution agent tries to sync, Error: 14151, Severity: 18, State: 1.The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated. CAUSE:======When we check the Publication properties, we find that the options for subscription expiration are marked as “Subscriptions never…

1