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. I've ensured to install relevant FULLTEXT...
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 documented process in BOL. How about downgrade...
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 Backup tool: "Restore failed for Server '<ServerName>'...
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 with database mail when the user is intended to use...