Monday, October 31, 2011

Sql Server script failed for storedProcedure property TextHeader is not available for storedProcedure. This property may not exists for this object, or may not be retrievable due insufficient access rights. The text is encrypted

PROBLEM:
When trying to open stored procedure or other object with Sql Server Management Studio you get the error "Sql Server script failed for storedProcedure property TextHeader is not available for storedProcedure. This property may not exists for this object, or may not be retrievable due insufficient access rights. The text is encrypted"
You are trying to do that by right click on the stored procedure -> "Script Stored Procedure as" -> "CREATE To" -> "New Query Editor Window"

SOLUTION:
The stored procedure is not encrypted, the error is because there is no grant permission "VIEW DEFINITION"

Right click on the database -> properties -> permissions. Choose the relevant users or roles, go to the bottom of the permissions "Explicit " tab. There you can see the "View definition" permission. You should grant it.



If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!


Thursday, October 27, 2011

Windows Serial Key Finder

PROBLEM:
How do I find my Windows serial key?

SOLUTION:
The Magical Jelly Bean Keyfinder is a freeware utility that retrieves your Product Key (cd key) used to install windows from your registry. It also has a community-updated configuration file that retrieves product keys for many other applications. Another feature is the ability to retrieve product keys from unbootable Windows installations.


If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!


Database for Time Zone and Daylight Saving Time

PROBLEM:
You need time zone and daylight saving time database

SOLUTION:
The tz database partitions the world into regions where local clocks have all been the same since 1970. This map, taken from the 2009r edition of the database, is of all the regions outside Antarctica.



Home Page
http://cs.ucla.edu/~eggert/tz/tz-link.htm


.Net Library
A simple .NET API for the zoneinfo database (also known as the tz database or the Olson database).


If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!


IIS 403 - Forbidden: Access is denied

PROBLEM:
When trying to open URL with your browser you get "Forbidden: Access is denied". The web site is written with ASP.NET and deployed in IIS. You do not have a "Default.aspx" file in your ASP.NET project

SOLUTION:
Add Default.aspx page to your ASP.NET project
-OR-
Add your IIS default pages list (index.htm, default.aspx) the default project aspx page


If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!