Database Publishing Wizard

As I need to deploy a system to SQL Server 2000 from my development environment, I come across this free apps which seems suit all my need.

Database Publishing Wizard

The Database Publishing Wizard enables the deployment of SQL Server 2005 databases (both schema and data) into a shared hosting environment on either a SQL Server 2000 or 2005 server.

ref: http://www.codeplex.com/sqlhost/Wiki/View.aspx?title=Database%20Publishing%20Wizard&referringTitle=Home

Hard Disabled Add-in

Just before I wanted to leave office, I found that a VSTO SE add-in cannot be loaded.
As the add-in is still under development, this is my first priority to fix it,
or else, I can do nothing next week.

After a keep querying google for solution, the following pages return ... so it is time to leave office and take a rest.

Google
Error

We're sorry...
... but your query looks similar to
automated requests from a computer virus or spyware application. To protect our
users, we can't process your request right now.
We'll restore your access as
quickly as possible, so try again soon. In the meantime, if you suspect that
your computer or network has been infected, you might want to run a virus checker or spyware remover
to make sure that your systems are free of viruses and other spurious software.
We apologize for the inconvenience, and hope we'll see you again on Google.

Finally, I found that the add-in is hard-disabled because of a previous crash.
To solve it : Lauch Excel > Help > About > Disabled List > uncheck your add-in > Done !

Rounding issue

There are so many ways of Rounding.
And the Round() function is not implemented in a consistent fashion even among different Microsoft products.

ref:
http://en.wikipedia.org/wiki/Rounding
http://support.microsoft.com/?kbid=196652
http://msdn2.microsoft.com/en-us/library/ms131275.aspx

FIRST POST

Welcome All,

Thanks for Alfie's idea, we have created this TechnoForge.

Sharing Knowledge, Sharing Skills

Happy Coding.
ACow

Hello World

The many are smarter than the few.
This blog is to share idea, experience and knowledge.

Happy coding , happy blogging.