Job Proxy management in running SSIS package job
In my project, I ceate an SSAS project and i need to find a way to periodically process the cubes automatically. The idea is that at first creating an SSIS package aiming at processing th...
Rename Database in SQL Server 2005
When renaming the database, it is required that taking the database offline or changed it to the 'single user' mode.
Default Database in SQL SERVER 2005
This morning when I open SSMS, it turns out the error saying that could not connect to the server. It's strange since yesterday it worked fine, and i just remember that the only modifi...