Printable View
Hello Guys-
After transferring data from Access to SQL server I have some little problem. I am quite novice in SQL server. In SQL server everything is fine but when I am trying to see the data it is not showing any data rather than it gives me a error"unspecified error.....query" something like this...but if i use select query it gives me data. ANy one has any solution?
Sohel
Are you saying that you can query your tables OK but can't see the DATA in SQL SERVER MANAGER ?
If so, it's because the only way to see the DATA from SQL SERVER MANAGER is to right click on the table and select the option open table... -> return all row OR the other menu.
If you open the QUERY ANALYSER of SQL SERVER, you will be able to type in your SELECT and other stuff...
Hope this is what you wanted but I doubt it...