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.
| Author |
Topic |
|
Big2
Starting Member
2 Posts |
 Posted - 2009-04-02 : 04:55:31
|
| Hi,I have a table that has this row (which is visible when I open the table):131363 25749 23/03/2009 00:00:00 6.3900 Standing Order 90 23/03/2009 10:03:00But when, for example, I run SELECT * FROM Tbl_TableName this row is not brought back. The reason I found this problem is that I have a Microsoft Access frontend and when i run the query in there it shows, but if i run the query in SQL 2005 Management Studio the record is not pulled back.Is there any known issues with this? Does anyone have any ideas of what it could be?Thanks |
|
|
Big2
Starting Member
2 Posts |
Posted - 2009-04-02 : 05:01:58
|
| Sorry just noticed, silly me, i had the wrong database selected at the top and not the live, how embarassing! :) |
 |
|
|
|
|
|
Simple SELECT query missing rows?