Click here to Skip to main content
15,867,870 members

Comments by Amaan23 (Top 30 by date)

Amaan23 18-Jul-14 3:32am View    
Thanks, this is something new which i was not aware. Let me check and try out.

Still have doubts on above as my table(Time Attendance Table In and Out info) will have approx 50 events getting inserted in table in 2 min.

Well lets see. Thank you for your help.
Amaan23 27-Jun-14 5:54am View    
Thanks,

Initially i have used ' GRANT select on' Command but for some strange reason SQL server was playing hide and seek.

After executing this command i logged in with that user i was able to access all the tables..so i thought i was making some mistake.... later when i discuss with my friend. He advice to log off close SQL server management and then log in with new user and check................. and it worked fine...


Thanks for your help. Must appreciated.
Amaan23 23-Jun-13 9:07am View    
sorry for delayed reply, i was out of city.

I tired this but still no luck. once we have order by time, it takes lot of time to execute it.

Thank for your help
Amaan23 17-Jun-13 7:25am View    
Yes i can write Stored procedure to the database
Amaan23 15-Jun-13 14:52pm View    
Thanks for your reply.

I have no control over the table or hardware thats why i cannt use MSMQ :(

My scope is only to connect and get the newly row(event) and display it on web page. -- Live events

Thanks