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.
3 Ways to format the percentage
Format (Value, "##.##") & "%"Formatpercet(value,2)Right Click the textbox à Properties à Format à N2
Orders of Report Parameters
In SSRS, the report parameters have their orders and dependences, which means sometimes the wrong order of parameters could brings error for the report. Specifically, it presents the error as follow:...
Using report parameters to pass values from Subreport to Main Report
Would like to pass values from Subreport to Main Report in SSRS ? It is not supported in 2005, however, i found a way to realize it through using report parameters.To simplify it, the scenario is as...
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...
MOSS WebParts webcast from MSDN
A useful webcast tutorial for Sharepoint Webparts from MSDN, which includes step-by-step tutorial for webparts creation, deploy. http://www.microsoft.com/italy/msdn/eventi/webcast/video/s...