How to use Upgrade Advisor
Using Upgrade Advisor
This section will provide you a brief about How to upgrade advisor
1.) Go to Start –> All Programs –> Microsoft SQL Server 2005 –> SQL Server 2005 Upgrade Advisor, open upgrade advisor
Posts Tagged ‘upgrade advisor’
Installing Upgrade Advisor
This article will explain you in brief how to install upgrade advisor before installing SQL 2005
1.) Insert Sql 2005 setup CD DVD into drive and wait for auto menu to pop-up.
Overview of Upgrade Advisor Utility
Microsoft SQL Server 2005 Upgrade Advisor is a tool you can use to prepare for upgrades to SQL Server 2005. Upgrade Advisor analyzes installed SQL Server 2000 or SQL Server 7.0 components, and then generates a report that identifies issues that you must or should address to before or after upgrading to SQL Server 2005.
Amit Bhatt
| #
Hi Deepak,
Thanks for such a nice article.
You missed one thing to add in code:
@article = ‘all’,
Hence the script will be like this:
EXEC sp_addsubscription
@publication = ‘mypublication’,
@article = ‘ALL’,
@subscriber = ‘Subscriberservername’,
@destination_db = ‘mydestinationdbname’,
@reserved=’Internal’
Error 18486 | Platformblog
| #
[...] SQL-Articles » Troubleshooting Login failed Error 18456This is one of the infamous error message (and number) that most of the DBAs …. 18486. Login failed for user ‘%.*ls’ because the account is currently locked out. [...]
Setting and Changing Collation – SQL Server 2008 « Blog
| #
[...] to sql-articles.comRead more: http://sql-articles.com/articles/dba/how-to-change-server-collation-in-sql-server-2008/#ixzz1pu2S8XW… Like this:LikeBe the first to like this [...]
VidhyaSagar
| #
Naveen,
I’ll check this out and get back to you.
balakiran
| #
Thanks man, Very simple & easy to understand !!!!