February 2017

Why get unable to initialize when run Access 97?

I have been puzzled with this problem for months and unable to resolve it until today.

What causes 404 or Not Found error message on your site?

1. The most common cause of this error is you delete the public_html folder which is your website root folder that contains your website files and folders.

Transparency the easy way!

Until GIMP come along making a picture transparency is a very time-consuming effort! One of the old paint program that let you erase to transparency but it is hard to find now a day!

SharePoint 2010 allow_page_locks issue

When you install SharePoint 2010 you might discover that you can't use the SQL maintenance to clean up your indexes. You will get message like "failed to reorganize indexes due to page level locking is disabled"

Microsoft URL Rewrite 101

Microsoft URL rewrite module is extremely easy to use not like Mod_rewrite!

MSSQL store procedure to convert from XML to table

Below is the actual code so you can just copy and paste to create the store procedure.

MSSQL store procedure to Describe Schema from fields list in XML

Below is the actual code so you can just copy and paste to create the store procedure.

MSSQL function get a list of fields of a particular table from system table

Below is the actual code so you can just copy and paste to create the store procedure.

MSSQL Undocumented Extended Stored Procedures

MSSQL Undocumented Extended Stored Procedures

Hyper-V backup script

This script can backup your Hyper-V to a specific folder with an optional list of VM from a file or it can get a list from Hyper-V directly and can rotate backup set based on the optional parameters.

Pages