Data Missing In Database

Question

Data Missing In Database

shohelr2003

Hall of Fame

Points: 3535
More actions
May 15, 2014 at 4:46 am

#293308

Dear,
I use SQL Server 2008 R2 Standard Edition in our production database. Sometimes I find very strange thing that is I don't find some data from database query. But from the application end, functions regarding that data work nice.
For example, there is a function defined as "printInvoice" and it is allowed for user "abc". In my database, I do not find any info regarding "printInvoice". But user "abc" is using this function very efficiently. The basic is if any function is not defined in database, none can access it.
Then I restarted SQL Services. No Result. After that I restarted Production Server. Now I found the missing data. I was stumbled. Then where was that data?
Please let me know is there any system that data can be in hidden state or temporarily stored any where else?
Regards
Akbar

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 1

Data can be cached on the servers outside SQL Server, then the queries against SQL Server won't ever show that data. But that's the only thing I can think of unless you have some sort of security check within your database implemented through views, functions or stored procedures. There's no way to do row level security directly on the table itself, so it would have to be through code somewhere.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

free_mascot One Orange Chip Points: 27169 More actions · Answer 2

Provide more details about function. What kind of function it is? What it is doing? How it is connecting to the database? etc.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Lowell SSC Guru Points: 323518 More actions · Answer 3

also, HOW are you checking to see if a function exists or not?'

if you query sys.objects directly, or are using the SSMS GUI and expecting it to appear there? the GUI takes a snapshot of data, and is not automaticalyl update dwhen objects are created,dropped, etc.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

shohelr2003 Hall of Fame Points: 3535 More actions · Answer 4

Actually I run select * from table where condition but I don't get any rows. Then I restart my production server and execute the same query and find some rows. That is the thing I am not realising. Why is this happening?

Please help me.