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
How to
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
Upgrade
Archives
Archives
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)
October, 2008
MSDN Blogs
>
Microsoft SQL Server Tips & Tricks
>
October, 2008
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Microsoft SQL Server Tips & Tricks
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
Posted
over 5 years ago
by
sequelguy
0
Comments
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...
Microsoft SQL Server Tips & Tricks
How to setup a SQL Server Replication between three servers in a typical scenario..
Posted
over 5 years ago
by
sequelguy
1
Comments
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...
Microsoft SQL Server Tips & Tricks
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
Posted
over 5 years ago
by
sequelguy
1
Comments
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: --------------------------------------------------...
Microsoft SQL Server Tips & Tricks
Did you know... The stats can degrade the performance if outdated but how to check when stats gets updated
Posted
over 5 years ago
by
sequelguy
0
Comments
Sometimes the query performance degrades due to the out of sync stats on the tables in the database. But how do we know it and how we do reach at the conclusion that the stats are the cause of the performance degradation. This is pretty well known but...
Microsoft SQL Server Tips & Tricks
Did you know… When we rename a domain group in Active Directory, we can have some issues related to the login in SQL Server
Posted
over 5 years ago
by
sequelguy
1
Comments
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...
Microsoft SQL Server Tips & Tricks
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!
Posted
over 5 years ago
by
sequelguy
0
Comments
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...
Microsoft SQL Server Tips & Tricks
Step by Step Procedure to Implement SQL Server Transactional Replication with Oracle as Publisher
Posted
over 5 years ago
by
sequelguy
3
Comments
/*** 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...
Microsoft SQL Server Tips & Tricks
SQL Server can perform slow after changing the Cost Threshold for Parallelism
Posted
over 5 years ago
by
sequelguy
1
Comments
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...
Microsoft SQL Server Tips & Tricks
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
Posted
over 5 years ago
by
sequelguy
1
Comments
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...
Microsoft SQL Server Tips & Tricks
The subscription fails to Sync with the Publisher and marked inactive even though the settings have been configured to “never expire”
Posted
over 5 years ago
by
sequelguy
1
Comments
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. ...
Page 1 of 1 (10 items)