Browse by Tags

Full Text Search is installed, but not enabled to see at table-level

Published 26 July 7 4:38 AM | SSQA.net

It was long time ago I have used FULL-TEXT within our environment, recently I have been given a task to manage a full text SQL instance. Well to refresh my tasks I have installed Full Text Search component on Windows 2003 Server for SQL server 2000 instance...

Filed under: sql server, ssms, database, sql express, full-text, enterprise manager

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

Error message when you try to restore a database by using SQL Server Management Studio in SQL Server 2005 after you use the Backup tool: "Restore failed for Server '<ServerName>' (Microsoft.SqlServer.Smo)"

Published 4 June 7 7:28 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications Error message when you try to restore a database by using SQL Server Management Studio in SQL Server 2005 after you use the...

Filed under: sql server, restore, backup, ssms, database

Database mail issues with maintenance plans & scheduled jobs

Published 30 April 7 9:40 AM | SqlServer-QA.net (SSQA)

Database Mail Fails For SQL Server Agent Jobs / Maintenace plans - Why ? As you are aware Database Maintenance plans are better in SQL 2005 and more better now after Service Pack 2 release with a cumulative hotfix release. Still there are few problems...

Filed under: sql server, ssms, maintenance plan, solution, database, mail