Monthly Archives: December 2011

The multi-part identifier ‘table.column’ could not be found

By looking at the picture below, the CO_STAFF does not include in the View.       Remove the CO_STAFF and left the CS_Name works for me.

Posted in .Net | Tagged , | Leave a comment

Install Canon LiDE 20 scanner with Windows 7 x86

I bought Canon LiDE 20 scanner in year 2000 if I remember correctly. Somehow it is still working with Windows 7 x86.   Download the driver from canon site lide20lide30n670un676un1240uvst7031a_xpen.exe.   You will see your driver installed after running it. … Continue reading

Posted in Computers and Internet | Tagged , | 1 Comment

Property Owner is not available for Database ‘Database Name’

When you right click on the database in SQL Management  Studio and the error message below pop up. —————————————————————————————— Cannot show requested dialog. (SqlMgmt) —————————— Property Owner is not available for Database ‘[OMS]’. This property may not exist for this … Continue reading

Posted in .Net | Tagged , , | 1 Comment

Search multiple tables using Dataset

1. Create a View in the database. 2. Create a Dataset in the video example below the dataset name is by default Dataset1. 3. Drag the View to the Dataset (from Northwind sample database). 4. Create WebForm. 5. Add one … Continue reading

Posted in .Net | Tagged , | Leave a comment

Collapse all the files in Visual Studio 11 solution

Look at Visual Studio 2010 below. Unfortunately there is not a way to collapse them.   There is a collapse button in VS 11 allow you to do this.

Posted in .Net | Tagged , | Leave a comment

The database db is not accessible. (ObjectExplorer)

If you have the following error with trying to open MS SQL database. The database db is not accessible. (ObjectExplorer) Login as another sysadmin user delete the user login who encountered the error message and recreate them.

Posted in .Net | Tagged , | Leave a comment

Import data to Master Data Services (MDS)

It is not necessary to import the data into staging table if you want to display them in MDS Explorer. 1. Find out what is the table to storing the Entities in table tblEntity. For this example the table is … Continue reading

Posted in .Net | Tagged , | Leave a comment