SqlServer-QA.net

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise EditionNotification Contents: New and Major Modifications How to register Microsoft Filter Pack IFilters with SQL Server 2005 and with SQL Server 2008http://support.microsoft.com/kb/945934/en-US

Another common question on the forums, may be not a frequently performed task and as a DBA you should discourage in performing such actions. Microsoft SQL development team has already documented the information over the KBA 303774 and for the server name changes yes, you can change the name of an instance as long as the server is not ...

As you may be aware SQL Server installation (70 & 2000) will automatically install the sample databases pubs and northwind, if you aren't using them or not a training institute then simply drop them. Whereas this behaviour is changed in SQL Server 2005 as the Northwind and pubs sample databases are not installed by default in ...