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
Read More...
In Reporting Services there is a feature to Cache a temporary copy of the report that can be used to paste elsewhere. If the proper username has not been granted on Report Manager the user will get error "Credentials used to run this report are not stored".
Read More...
You may be aware about SQL Server 2005 Express edition is a free and simple to manage edition in 2005 version. It has an integratin with Visual Studio 2005 to make it easier to develop data driven applications with a redistributable option, well I'm not
Read More...
This is the question asked in MSDN forums, using SQLMAINT utility this can be achieved and also the output can be sent to a text file or HTML file. In case if the steps are defined in the DTS package then its best to use DTEXEC utility. Best to refer
Read More...