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 |
|
reddymade
Posting Yak Master
165 Posts |
 Posted - 2007-01-19 : 14:36:40
|
| I am using the following select * from Tab_pcsEmailsum;Even though there are records it is not showing anythin.I same query i use on my machines database it does bring all records. it is a simple query but i don't know what is gone wrong.I am using sql server 2005. i also logged in as sa with full rights.are there any attributes i can check.Please help thank you very much for the information. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-19 : 14:49:24
|
| Are you using the same schema?Peter LarssonHelsingborg, Sweden |
 |
|
|
reddymade
Posting Yak Master
165 Posts |
Posted - 2007-01-19 : 14:56:44
|
Hello Peso, Sorry my Bad.I don't understand SQL server 2005 even though you delet the records they still appear in the table.those are the deleted records in the table , when i do select * from tablname:Is it possible to change the attributes of sql server once the record is deleted from table. to remove the record completely.Thanks.quote:
Originally posted by Peso
Are you using the same schema?Peter LarssonHelsingborg, Sweden
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-19 : 15:10:14
|
| reddymade,You are doing something wrong if the data isn't being deleted when you issue a delete. Please post your code.Tara Kizer |
|
|
|
|
|
|
select query not populating