sql server express + query doesn't show records

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

sql server express + query doesn't show records

Author

Topic

LLMM
Starting Member

4 Posts

Posted - 2010-07-20 : 18:00:45

Hoi,
I using sql express 2005.

I have a table with 29000 records
when i make a query => select * from tableName,
it doesn't show me any records

when i select count(recordName) AS X From tableName
it show 0

i don't understand ? What i'm doing wrong ?
It is local on my portable.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-07-20 : 18:07:58

According to your queries, the table has no rows in it. What's likely happening is that your table with 29000 rows is probably in another database or owned by another user. Check through Management Studio and locate the correct object.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

LLMM
Starting Member

4 Posts

Posted - 2010-07-21 : 03:23:21

don't understand ?
my table is in the database i'm calling.
as i see in my object explorer.
And what do you mean to check in the Management studio ?
how i check it ?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2010-07-21 : 03:44:15

quote:
Originally posted by LLMM

Hoi,
I using sql express 2005.

I have a table with 29000 records
when i make a query => select * from tableName,
it doesn't show me any records

when i select count(recordName) AS X From tableName
it show 0

i don't understand ? What i'm doing wrong ?
It is local on my portable.