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)
July, 2009
MSDN Blogs
>
Microsoft SQL Server Tips & Tricks
>
July, 2009
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Microsoft SQL Server Tips & Tricks
How to impersonate the privileges to create a login using the Stored procedures using “EXECUTE AS” clause
Posted
over 4 years ago
by
Parikshit Savjani
1
Comments
As most of the times we do it in a simple way descirbed below. but when we try to do the same through stored procedure it fails. Just for information regarding impersonation:- http://msdn.microsoft.com/en-us/library/ms188354(SQL.90).aspx Solution...
Microsoft SQL Server Tips & Tricks
Upgrade advisor returns error while upgrading an instance of SQL Server 2000 to SQL Server 2005.
Posted
over 4 years ago
by
Parikshit Savjani
33
Comments
Problem description: Upgrade advisor returns error while upgrading an instance of SQL Server 2000 to SQL Server 2005. Cause: The error occurs because of a problem with BPACMD.EXE attempting to load BPAClient.dll. While upgrading the instance of SQL Server...
Microsoft SQL Server Tips & Tricks
Error: SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)SSMS
Posted
over 4 years ago
by
Parikshit Savjani
68
Comments
Ideally DTS Packages should be upgraded to SSIS packages as we move from sql 2000 to sql 2005/sql 2008. And one of the good articles which provides information on how to upgrade DTS packages to SSIS package is written by Jason Howell http://blogs.msdn...
Microsoft SQL Server Tips & Tricks
Tampering master.vmp file may result in losing all Analysis Services Databases:
Posted
over 4 years ago
by
sequelguy
0
Comments
The master.vmp file is the master version map that contains the GUIDS for all of the objects and the version of each object that currently exists on the server. When the server starts, it looks at the master.vmp file and attempts to find each of...
Microsoft SQL Server Tips & Tricks
Installing Hotfix on SQL Server may throw error 29538 and fail
Posted
over 4 years ago
by
sequelguy
0
Comments
In this case we were installing hotfix http://support.microsoft.com/?kbid=960089 Microsoft SQL Server 2005 Service Pack 2 Cumulative Hotfix 3077 The Hotfix Setup would rollback. You will see the below error in the Hotfix.log file 06/24...
Page 1 of 1 (5 items)