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)
September, 2008
MSDN Blogs
>
Microsoft SQL Server Tips & Tricks
>
September, 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... Accessing Linked server using Synonym can fail with an error 7359
Posted
over 5 years ago
by
sequelguy
1
Comments
Accessing Linked server using Synonym results in an error after we rebuild Indexes on the target server in SQL Server 2005. The Error Message is like below, Msg 7359, Level 16, State 1, Line 1 The OLE DB provider "SQLNCLI" for linked server "Domain...
Microsoft SQL Server Tips & Tricks
Facts about How SQL Server 2008 setup works... #3
Posted
over 5 years ago
by
sequelguy
2
Comments
Setup.exe can be patched dynamically on the fly One of the drawbacks of the sql server 2005 setup was that if there was any bug detected in the code of the setup.exe , the patching of the setup.exe was difficult and at times next to impossible. ...
Microsoft SQL Server Tips & Tricks
Some useful tips when working with the Service Broker in SQL Server 2005
Posted
over 5 years ago
by
sequelguy
1
Comments
With Service Broker, internal or external processes can send and receive guaranteed, asynchronous messages by using extensions to Transact-SQL Data Manipulation Language (DML). Messages can be sent to a queue in the same database as the sender, to another...
Microsoft SQL Server Tips & Tricks
Facts about How SQL Server 2008 setup works... #2
Posted
over 5 years ago
by
sequelguy
1
Comments
Salient Features of Sql Server 2008 (Katmai) Setup Minimize the MSI code for setup and use MSI code for what it does the best. In Sql 2005 entire setup process was coded using MSI code which uses the Windows Installer code and was found to be root cause...
Microsoft SQL Server Tips & Tricks
Facts about how SQL Server 2008 setup works...
Posted
over 5 years ago
by
sequelguy
3
Comments
In order to install, upgrade, uninstall, and patch the sql server 2008 instance on the system we need to call the setup.exe from the installation media. The setup.exe is an unmanaged code which checks the basic pre-requisites to launch the actual Setup...
Page 1 of 1 (5 items)