ASP.NET Error : The SELECT permission was denied on the object ‘table_name’, database ‘table_name’, schema ‘dbo’.

Error caused by the subject not Add Permission can be modified as follows.

1. Open SQL Server Management Studio.
2. Look at the Object Explorer (left).
3. Select the folder>> Security>> Logins.
4. Select the User to use. Right-click on the shortcut menu, select "Properties".
5. When the window see the Select a page (left side).
6. Select the Server Role to Check "sysadmin" Press Ok.

How to open the file of the ASP.NET Master Pages in Dreamweaver 8 Design view.

By the ASP.NET Master Pages is a Dreamweaver extension that master does not know if we will be the Open With Text Design can not be a way to make known Dreamwever master file extension is another way.

1. to go to "C:\Program Files\Macromedia\Dreamweaver 8\Configuration\DocumentTypes" If a Windows 64 bit, it changed its name to the Program Files Program Files (x86).
2. Find a file called "MMDocumentTypes.xml". Open a text editor program to edit the file
3. Once opened, then search for "ASP.NET_VB" and "ASP.NET_CSharp".
4. find the attribute named "winfileextension" notice will contain the value. aspx, ascx, asmx so we can add to the master. winfileextension = "aspx, ascx, asmx, master".
5. Close Dreamweaver and open a new again.

Good luck.



Reference : http://www.memo8.com/toolkits/archives/484