Recent content by rrajarat

I kind of knew that but was hoping I was wrong. Thanks.

I accidently restored a day old backup onto the my live DB. How can I undo this ASAP???

Well I don't know if this is progress but I was able to get my shopfloor PCs to react the way they do when the issues occur (whatever they may be). I simply took my server of the network and predictably the vb apps accessing the DB were very slow. Now my question is can a networking...

mrdenny, This issue happened again last night and this time there were only 2 apps running that would access the DB. They are both used to record production, so there will be an insert from 2 PCs (same app on both) every minute (this is average). Again I wasn't in the office to run some...

I tried sp_who2 and DBCC InputBuffer() and found that the processor that are blocking each other don't even access the same table. Strange thing is this happened yesterday when I was out of the building and when I got in in 15 min nothing was accessing the DB (lunch time so no production). I had...

thanks for the reply mrdenny. What is sp_who2 and how do I use it? Also how do analyze the information I get back?

I have a small (~90MB) database that my production is recorded on and every 5 minutes this info is put into a txt file and sent via FTP to another offsite Server. Then the record that have been sent get flagged. The last couple of days my server timesout on the update and after trying the...

Thanks Hypetia, I thought of your idea but was hoping for an infinite loop.

I am using the media player control in vb6

This may be very simple but I can't seem to figure this out. How do I loop/repeat a video in WMP 9 until the user hits stop or changes the video?

Thanks sleipnir214, that worked great. Have a star

I am looking into tracking all the down time that occurs on the plant floor and making it available on our intranet site. I have asked my electricians to wire all the machines up and have connected to a PC with RSLogic and RSLinx. I want to eventually use RS linx or RSview to write machine...

I am not sure if this will be done in PHP be but I want a webpage to be freshed every 5 minutes. Is this possible? If yes, how will I do this. Thanks

I have a page with a form the user fills out (start date and end date). Based on this the SQL 2000 db is queried and the results are graped below the form as an image. I then add a button to dump the raw data that was graphed into an excel file. The problem is that when I send the data to excel...

i have a barcode slot reader with a ps2 keyboard wedge connector. The problem is that I don't want to have a keyboard at the pc. So when the pc gets rebooted the barcode reader doesn't work. Is there any way to get around this? Have I just wasted money on 2 readers?