Browse by Tags

A tape device is not detected by SQL Server Management Studio in SQL Server 2005 or by SQL Server Enterprise Manager in SQL Server 2000

Published 12 June 8 2:1 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New A tape device is not detected by SQL Server Management Studio in...

Filed under: sql server, kba, management studio, backups, enterprise manager, tape

The identity column of the destination table does not contain the same identity values as the source table after you use SQL Server Management Studio to import data or to export data in Microsoft SQL Server 2005

Published 6 May 8 10:7 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, ssms, kba, import, management studio, export, identity key

Object search within Management Studio of SQL Server 2008

Published 12 March 8 3:56 AM | SSQA.net

Good news for the Development DBAs to have a fature of searching for a particular object within the SQL database. The newest feature to SQL Server 2008 version will be 'object search'! Until now even for me I used to refer to ThisArticle to search...

Filed under: sql server, database, 2008, management studio, object explorer, object search

SQL Server Management Studio snap-in - get alerted when executing a TSQL code!

Published 15 February 8 4:26 AM | SSQA.net

Do you like color-coded alert say when you are executing a TSQL script or code against a SQL Server instance, say if its a production server with 'red' indicator or 'green' when it is on testing platform! I have no doubt in stating the...

Filed under: sql server, management, ssms, download, demo, alert, sample, tsql, code, toolkit, management studio, snap-in

Snap-in failed to initialize, Name Microsoft SQL Enterprise Manager: CLSID : {00100100-1816-11D0-8EF5-00AA0062C58F}

Published 8 January 8 11:1 AM | SSQA.net

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...

Filed under: sql server, tools, enterprise, sql express, error log, management studio

SQL Server Management Studio - unable to see all the menus and unresponsive when managing SQL instances!!!

Published 18 December 7 3:1 AM | SSQA.net

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...

Filed under: sql server, microsoft, kba, support, management studio, desktop, pss, visual, laptop, ram

SQL Server is waiting for an internal operation to complete, message on SQL Server Management Studio

Published 17 December 7 2:49 AM | SSQA.net

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...

Filed under: sql server, performance, microsoft, users, sql express, service pack2, management studio, slow, delay

Using Management Studio unable to select "create one file per object"?

Published 17 October 7 4:6 AM | SSQA.net

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...

Filed under: sql server, ssms, script, 2000, service pack2, 2005, management studio, enterprise manager, generate

SQL Server 2005 how to copy database maintenance plans between the servers?

Published 15 October 7 8:54 AM | SSQA.net

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...

Filed under: sql server, backup, ssis, ssms, maintenance plan, service pack2, management studio

Export SQL Servers registration using Management Studio?

Published 3 October 7 4:5 AM | SSQA.net

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...

Filed under: sql server, ssms, best practices, password, 2005, management studio, servers, export, registered

How to set the Animation Speed and make best use of SQL Server Management Studio tool?

Published 1 October 7 8:12 AM | SSQA.net

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...

Filed under: sql server, performance, ssms, management studio, automation, loading, ie

Downgrade or revert or restore SQL Server 2005 database to SQL Server 2000 version

Published 20 July 7 3:21 AM | SSQA.net

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...

Filed under: sql server, ssms, database, upgrade, dts, management studio, degrade