Problem with Database Restore

Last week, I restored a database from backup and was having the following error when trying to access the tables:

“The SELECT permission was denied on the object ‘extended_properties’, database ‘mssqlsystemresource’, schema ‘sys’”.

After some research, I found the next solution: Continue reading »

Error 29506 | SQL Server 2005 Management Studio Express

When i binged (yes I’m using bing ), i found the following fix:

• Search for Command Prompt in the Start Window (don’t press enter)
• Right click on the shortcut found and select ‘Run as Administrator’
• In the command prompt change the current directory to the folder where the SSMSEE installer is stored
• Enter the following command .SQLServer2005_SSMSEE_x64.msi if you are running Windows 7/Vista 64 bit
• Enter the following command .SQLServer2005_SSMSEE.msi if you are running Windows 7/Vista 32 bit
• Press enter to start the installation

Happy Sql Server Managementing

Resources: here

SQL Server 2005 | “Product level is insufficient”

The following error kept popping up when trying to import data from a flat file source of type CSV to be imported in a table in SQL Server:

The product level is insufficient for component source “filename.csv”

To solve this problem, you need to install the Service Pack 2 of SQL Server 2005 from this link.

If you find other solutions… please let me know

Return Array from Web Service using ScriptManager & Javascript

 This is used to call the Web Service using ASP.Net and Script Manager. Must be inserted in .aspx page. 

This is the script to call the web service method and print the result on the form: Continue reading »