Sign in
MSDN Blogs
Microsoft Blog Images
More ...
Microsoft SQL Server Tips & Tricks
Tips and Tricks for the SQL Server Enthusiast
RSS for posts
Database Engine
blogs
Analysis services
blogs
Reporting services
blogs
Integration services
blogs
Data access tech blogs
Database Engine videos
Analysis services videos
Reporting services videos
Integration services videos
Data access tech Videos
Common Tasks
Blog Home
Email Blog Author
About
RSS for comments
RSS for posts
Atom
Search
Tags
analysis services
Backup
Cluster
DBVideo
Encryption
Installation
OLAP
Performance
query plan
replication
Security
Setup
SQL
sql 2000
sql 2005
SQL 2008
SQL query plan
SQL Server
SQL Server 2000
SQL Server 2005
sql Server 2008
SQL Server 2008 R2
Transactional Replication
update statistics
Upgrade
Archives
Archives
May 2013
(2)
April 2013
(2)
March 2013
(1)
December 2012
(2)
June 2012
(7)
May 2012
(1)
April 2012
(3)
March 2012
(5)
February 2012
(4)
January 2012
(3)
December 2011
(4)
November 2011
(3)
October 2011
(4)
September 2011
(1)
August 2011
(5)
July 2011
(3)
June 2011
(6)
May 2011
(10)
April 2011
(1)
March 2011
(1)
February 2011
(6)
January 2011
(3)
December 2010
(4)
November 2010
(2)
October 2010
(4)
September 2010
(9)
August 2010
(4)
June 2010
(4)
May 2010
(15)
April 2010
(18)
March 2010
(18)
February 2010
(7)
December 2009
(8)
November 2009
(7)
October 2009
(10)
September 2009
(6)
August 2009
(13)
July 2009
(5)
June 2009
(15)
May 2009
(5)
April 2009
(15)
March 2009
(15)
February 2009
(8)
January 2009
(9)
December 2008
(5)
November 2008
(2)
October 2008
(10)
September 2008
(5)
August 2008
(2)
July 2008
(7)
June 2008
(4)
May 2008
(1)
April 2008
(1)
December, 2008
MSDN Blogs
>
Microsoft SQL Server Tips & Tricks
>
December, 2008
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Microsoft SQL Server Tips & Tricks
Log Reader Agent Fails with the Error “The Log Reader Agent failed to construct a replicated command from log sequence number (LSN)”
Posted
over 5 years ago
by
sequelguy
5
Comments
Recently we encountered a case where in the Log Reader Agent fails to run and the following error is reported in the Replication Monitor Error messages: The process could not execute 'sp_replcmds' on 'TXDAL01410'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011...
Microsoft SQL Server Tips & Tricks
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.'
Posted
over 5 years ago
by
sequelguy
1
Comments
Recently we have encountered a case where Merge Agent was failing to apply a transaction at the subscriber with the following error Error Message ============== The change for the row with article nickname 2336003 (test), rowguidcol {D46DF7AF...
Microsoft SQL Server Tips & Tricks
SQL Server 2005 Setup Failing to Install on Cluster with Unexpected Failure while Performing the SCC checks
Posted
over 5 years ago
by
sequelguy
1
Comments
We have observed a number of cases where the installation of the SQL server 2005 instance on the cluster fails with the following unexpected Failure Error Message while performing SCC checks. ERROR MESSAGE: ==================== There is unexpected...
Microsoft SQL Server Tips & Tricks
Did you know... Auditing using DDL Trigger in SQL Server 2005
Posted
over 5 years ago
by
sequelguy
1
Comments
In the daily life of an SQL server DBA, we get numerous questions regarding the auditing possibilities for the different actions being performed on the database by different users. So it always comes handy if we have some kind of code ready to start the...
Microsoft SQL Server Tips & Tricks
DID YOU KNOW…. When we create a database using “Create Database <database-name>” Database properties are not inherited from Model Database.
Posted
over 5 years ago
by
sequelguy
1
Comments
When we create the database using the Management Studio GUI, the size of the new database is the same as the Model Database and also the properties of the new database such as MAXFILESIZE, FILEGROWTH is inherited from the model database. However...
Page 1 of 1 (5 items)