If you have a large number of stored procedures in your SQL Server 2005 and you have to give EXEC permission to a database user on all of them then the best way to do it is by running the following SQL SELECT ‘ GRANT EXEC ON ‘+ name +’ TO <database_user> ‘ from sys.procedures … Read moreGrant EXEC permission on all stored procedures in SQL Server 2005
Joomla 1.5 has come a long way since Joomla 1.2. Earlier if you had to customize a module you had two choices: 1. Edit code in the actual module file. 2. Write custom code to implement the functionality. Choosing either of the two steps would involve more time and in the end it also invited … Read moreCustomize menus in Joomla 1.5
I had recently bought a Core to Duo machine and installed Windows 2003 on it. I had some hesitation installing Windows 2003 on it as people had said that is has limited support for various hardware. I picked the Intel DG31PR board as it was the most economical in my limited budget. After installing Windows … Read moreRealtek audio problem on Intel Desktop board DG31PR
PHP offers a new and fast way to parse XML files. This approach makes it easier to parse very large XML files in a couple of seconds. Here goes the code to parse a sample XML file. The XML in that file is also given below <!– The XML to be parsed with the code … Read moreHow to parse an XML file in PHP using XML parser
If you want to read all the files a zip file contains and extract those files to a location on your computer then you can do the following. First of all make sure that the zip package is included in your PHP distribution. I use Windows so Windows users can just uncomment the entry for … Read moreHow to read a zip file in PHP
If you want to know when GoogleBot visited your website recently you can use any of the following ways to do so 1. Go through your web logs which Apache/IIS generate for your website. Scan for GoogleBot. A very crude way indeed. 2. If you have signed up for Google Sitemaps then you can login … Read moreHow to know when GoogleBot last visited my website
Downloading a file is easy but what if you had to download a file through your page and save it on our machine. Well here goes. We use our friendly CURL library in PHP for this. You can use the following code to download and save the file on your machine <?php $ch = curl_init(); … Read moreHow to download a file using CURL in PHP
Since Google came out with the Google Sitemap tool many website owners who were having problems of getting their websites indexed on Google started using it. However, Google Sitemap required website owners to submit their website sitemap in XML format. As most of them were not technical they turned to their technical support team or … Read moreGoogle presents Google Sitemap Generator
To be frank I used to think that ASP.NET menu control was complex and hard to use. Boy was I wrong!!! ASP.NET provides a menu control which allows you set all its visual properties and menu items and voila start using them. Not only that you can create a theme for it and with a … Read moreHow to create and use menu in ASP.NET?
The <asp:Checkbox> is one of those controls in ASP.NET which does not have a default Value property in which you can store a value and retrieve it upon postback. This becomes a problem in cases where the value has to be saved into the database or an action depends on the condition of that value. … Read moreHow to add a value to asp:Checkbox control and retrieve it on postback?