Browse by Tags
All Tags »
management studio (RSS)
Few times I get such error Snap-in failed with a long CLSID string mentioned in the subject above. On this client machine previously I have SQL Server 2000 tools and recently installed 2005 version too, instantly error: Snap-in failed to initialize Name
Read More...
In addition to the blog post SSMS-waiting-for-an-internal-operation-to-complete I have faced additional problems such as all the menus aren't displayed within SQL Server Management Studio from the same laptop. Other users within our team has observed
Read More...
Interesting popup message on the down-right corner of my laptop when I'm performing SQL Server tasks against a 2005 version database using SQL Server Management Studio (SSMS), displays the message " Microsoft SQL Server Management Studio is waiting for
Read More...
One of the Developer complained that he is unable to create one file per object using Generating SQL Scripts within Management Studio. It is one of the good feature within SQL Server 2000 using Enterprise Manager where you can differentiate the objects
Read More...
How can you copy the database maintenance plans from one SQL Server instance to another SQL Server instance using 2005 version. Using the Database Maintenance plans has been increased since SQL Server 2005 is released, also lot more once Microsoft fixed
Read More...
If you are managing hundreds of SQL Server and you might have organised your Management Studio screen with relevant server groups under Server registration. In this case if a new starter has joined and required to assist you in monitoring all of the SQL
Read More...
SQL Server Management Studio (SSMS) is a powerful tool in SQL 2005 that is re-written from previous of SQL Server, that also reduces the flaky features from Enterprise Manager. How to set the Animation Speed and make best use of SQL Server Management
Read More...
Can somebody tell me, it is possible to convert a database developed in sql2005 back to sql2000? A common question now a days in the forums and newsgroups, as you are aware UPGRADE process is available to enhance SQL 2000 database to SQL 2005 as per the
Read More...
SSMS - save your passwords safely in dev. environment
Read More...
Few tips I would share with the community about usage of SSMS tool within your environment, you can get acquaintance with SSMS quickly by using these features: Use Open empty environment option to speed up the loading of SSMS, this is how you do: at SSMS
Read More...
Having a shortcut feature for a tool is handy to work quicker than clicking with a mouse on a PC, I always use Keyboard more than mouse and only when I feel lazy or not keen on the subject then will use mouse. As per the SQL Server 2000 Books Online I
Read More...
Updates to system catalogs are not allowed - a big subject and nothing but opening door to trouble by allowing direct updates or modifications to system tables in SQL Server 2005. If I remember correctly since the days of SQL 6.5 version Microsoft has
Read More...
You may be aware about SQL Server 2005 Express edition is a free and simple to manage edition in 2005 version. It has an integratin with Visual Studio 2005 to make it easier to develop data driven applications with a redistributable option, well I'm not
Read More...
When you have tested the application for SQL Server 2005 comtability and upgrade process then your UPGRADE task will be easy to manage. But if you have used the Diagrams within SQL Server during the previous version, then there is a problem and here is
Read More...
SQL Server 2005 table partitioning provides many improvements in terms of manageability and availability. This is an enhancement on taking the performance advantage on the aspects of manageability by allowing improvements to metadata only switch-in and
Read More...