Grant EXEC permission on all stored procedures in SQL Server 2005

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

Realtek audio problem on Intel Desktop board DG31PR

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

How to know when GoogleBot last visited my website

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

Google presents Google Sitemap Generator

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

How to add a value to asp:Checkbox control and retrieve it on postback?

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?