SqlServer-QA.net

What is the most required task when a DBA required to perform upgrade from previous versions? Complete understanding of the databases that are required to upgrade. Technical reference of upgrade path from previous version to the current one. Testing of all aspects of that upgrade tasks. Documented information of upgrade path and ...

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

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 EditionNotification Contents: New and Major Modifications The identity column of the destination table does not contain the same identity values as the ...

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 for a specific object within the SQL Server database, also this you can easily enter the full ...

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 new 'Server Alert' snap-in for SQL Server Management Studio from Danny in SQLBlogcasts will do the rest of job ...

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 initializeName Microsoft SQL Enterprise ManagerCLSID : {00100100-1816-11D0-8EF5-00AA0062C58F} Tried ...

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 similar behaviour within their Management Studio (SSMS) screens (using desktop) when trying ...

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 an internal operation to complete. If you regularly encounter this delay ...

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 per file, and it is still available within SQL Server 2005 using Management Studio. To ...

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 the issues with Service Pack2 for SQL 2005. In general you can take help of ...