Microsoft SQL Server Tips & Tricks
Tips and Tricks for the SQL Server Enthusiast
Did you know... Merge Replication Fails with Error 'Unable to synchronize the row because the row because the row was updated by a different process outside of replication.'
Recently we have encountered a case where Merge Agent was failing to apply a transaction at the...
Author: sequelguy Date: 12/17/2008
SQL Server 2005 Setup Failing to Install on Cluster with Unexpected Failure while Performing the SCC checks
We have observed a number of cases where the installation of the SQL server 2005 instance on the...
Author: sequelguy Date: 12/16/2008
Did you know... Auditing using DDL Trigger in SQL Server 2005
In the daily life of an SQL server DBA, we get numerous questions regarding the auditing...
Author: sequelguy Date: 12/16/2008
DID YOU KNOW…. When we create a database using “Create Database ” Database properties are not inherited from Model Database.
When we create the database using the Management Studio GUI, the size of the new database is the...
Author: sequelguy Date: 12/10/2008
Did you know... Error: 29565 SQL Server Setup cannot upgrade the specified instance because the previous upgrade did not complete
We have observed a number of cases where the installation of SP2 succeeds on Active Node while it...
Author: sequelguy Date: 11/28/2008
Log Reader Agent Fails when the Sql server instance is failed over to Node 2
We have observed a number of case where we use sql server replication on a clustered instance of sql...
Author: sequelguy Date: 11/24/2008
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...
Author: sequelguy Date: 10/31/2008
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...
Author: sequelguy Date: 10/31/2008
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,...
Author: sequelguy Date: 10/31/2008
Did you know... The stats can degrade the performance if outdated but how to check when stats gets updated
Sometimes the query performance degrades due to the out of sync stats on the tables in the database....
Author: sequelguy Date: 10/26/2008
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...
Author: sequelguy Date: 10/26/2008
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...
Author: sequelguy Date: 10/16/2008
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...
Author: sequelguy Date: 10/16/2008
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...
Author: sequelguy Date: 10/14/2008
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...
Author: sequelguy Date: 10/05/2008
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,...
Author: sequelguy Date: 10/04/2008
Did you know... Accessing Linked server using Synonym can fail with an error 7359
Accessing Linked server using Synonym results in an error after we rebuild Indexes on the target...
Author: sequelguy Date: 09/23/2008
Facts about How SQL Server 2008 setup works... #3
Setup.exe can be patched dynamically on the fly One of the drawbacks of the sql server 2005 setup...
Author: sequelguy Date: 09/22/2008
Some useful tips when working with the Service Broker in SQL Server 2005
msAnalytics.ProfileId = 'D326'; msAnalytics.TrackPage(); With Service Broker, internal or external...
Author: sequelguy Date: 09/21/2008
Facts about How SQL Server 2008 setup works... #2
Salient Features of Sql Server 2008 (Katmai) SetupMinimize the MSI code for setup and use MSI code...
Author: sequelguy Date: 09/21/2008
Facts about how SQL Server 2008 setup works...
In order to install, upgrade, uninstall, and patch the sql server 2008 instance on the system we...
Author: sequelguy Date: 09/17/2008
Error 11032 Unable to install Windows Installer MSP while installing security patch KB 948109 on SQL 2005 instance
While installing security patch KB 948109 on SQL Server 2005, the installation of the patch may...
Author: sequelguy Date: 08/31/2008
How to change the keys for the Encryption for an already encrypted database
Have you ever wondered how to change the keys for the encryption for an already encrypted database....
Author: sequelguy Date: 08/10/2008
Upgrade of SQL Server 2000 instance to SQL Server 2005 fails with error similar to "Enforce password policy"
During the upgrade for the SQL Server 2000 to SQL Server 2005, the upgrade completes but with an...
Author: sequelguy Date: 07/31/2008
Maintenance Plans with “Backup Database Task” fails when the “Create a sub-directory for each database” option is checked
Maintenance Plans with “Backup Database Task” fails when the “Create a sub-directory for each...
Author: sequelguy Date: 07/27/2008
Error 29527 while installing security patch 948109 on SQL Server 2005
While installing security patch KB 948109 on the sql server 2005, the installation of the patch may...
Author: sequelguy Date: 07/24/2008
Regeneration of the Master Key fails when we try to take the backup of the Original Database and Restore on other instance of SQL server on other Machine
We have a production database in which the data is encrypted. The encryption follows the following...
Author: sequelguy Date: 07/16/2008
Unable to Install Security Patch 948109 to SQL Server 2005 Express Edition which is Installed along with ACT7 software
The ACT7 software installs sql server 2005 express edition along with the installation of ACT7...
Author: sequelguy Date: 07/16/2008
Which Vulnerability security patches needs to be installed for SQL Server 2000 and SQL Server 2005
There are new vulnerability security patches which have been released for sql server 2000,sql server...
Author: sequelguy Date: 07/11/2008
Security considerations for SQL Server installation on Windows Server 2008
Did you know that Windows Server 2008 installation, by default, enables the Windows firewall to be...
Author: sequelguy Date: 07/03/2008
Useful Documents while Troubleshootig Performance issues in the SQL Server 2005
The performance issue of the SQL Server can be anything from the connectivity issue of the...
Author: sequelguy Date: 06/25/2008
Installation of SQL Server Express Edition on Windows Vista while Installing Microsoft Office Accounting 2008
There have been a number of instances where the installation of the sql express edition on Windows...
Author: sequelguy Date: 06/24/2008
ERROR 29506 while installing the SP2 on the sql server 2005
While installing SP2 on the SQL server 2005, the installation may fail. Whenever the SQL server...
Author: sequelguy Date: 06/02/2008
How to Change the Dynamic Port of the SQL Server Named Instance to an Static Port in a SQL Server 2005 Cluster
In SQL server the default instance has a listener which listens on the fixed port which is TCP port...
Author: sequelguy Date: 06/02/2008
Use of Kerberos Authentication in SQL Server 2005
Kerberos is a network authentication protocol which can be used only with TCP/IP protocol. So if the...
Author: sequelguy Date: 05/06/2008
How to convert a standalone Instance of SQL Server into an Clustered Instance
For SQL Server 2000: Case 1: If the default instance of sql server is to be upgraded to default...
Author: sequelguy Date: 04/27/2008