Recent content by pcawdron

I have a VB.Net program with three separate, stand-alone forms displayed as tabs. Each form as an update button. When a user clicks one button I need it to fire the events of all three forms so data entered on any one of those forms is captured as though the user clicked update on all three...

I'm thinking about getting the primary page to open a second, hidden page that is a very small asp file, with a script that causes it to refresh every few seconds, but a straight flow of data would be much better. Any ideas how www.globulos.com does it? They must be leveraging some advanced...

Is there any way to pass variables from one client to another via the server? I'm thinking about developing a javascript game that passes variables back and forth in real time between two different clients across the internet. Any ideas? Regards, Peter

Awesome... thanks....

Sorry to ask such a dumb question, but I'm new to Oracle. How can I view the SQL behind a Logical VIEW using SQL Plus? Thanks, Peter

OK... thanks... I was stabbing in the dark on versions because I couldn't find any documentation on what number matched up with which SP Cheers, Peter

I found this on the Microsoft site, and it allowed me to clearly identify which versions we have been using http://support.microsoft.com/default.aspx?scid=kb;en-us;264474 Old, crashed SQL Server = 8.00.534 New, SQL Server = 8.00.194 Remarkably, then, it's simply that I hadn't applied SP3 to...

Thanks for the tip about msdb, unfortunately it produces the same error, it is.... SQL-DMO - The backup of the system database on device... cannot be restored because it was created by a different version of the server (134218262) than this server (134217822). RESTORE DATABASE is terminating...

We've had two SCSI HDD fail on our SQL Server 2000 absolutely bring it to its knees. No data could be recovered, it's allllllllll gone. I've set up a new server, win 2000. Installed SQL Server 2000, with SQL Slammer patches applied (exactly the same patches were aplied to the old server)...

I think this is what you're after.... http://www.webwizguide.info/asp/faq/date_time_settings.asp regards, Peter

Absolutely brilliant, thanks for the tip, it works beautifully Cheers, Peter

I have a form as part of my active desktop that allows users within the company to search for another employees phone number. It works well but when the form submits instead of updating the desktop it launches a new instance of internet explorer. Anyway to get it to update the active desktop...

Thanks for the tip, I'm looking at Triggers and IIS ADO connections to make sure everythings disconnecting properly. The thing that troubles me is why are the handles so high? How can you monitor something like this? Or, more appropriately, how can I kill inactive handles that are clogging...

Our SQL Server is running like a dog. I can't see why, but when I look at the win2000 process information it shows SQL Server taking 34,000 handles!!!! Any ideas? Process information for xxxx: Name Pid Pri Thd Hnd Mem User Time Kernel Time Elapsed Time Idle 0...

Thanks for the input, looks like the 1-way hash will handle the problem nicely. Oh, yes, you're right, if someone has got that far into the database they could do anything they want. What we're trying to avoid is a situation where someone would become aware of a UID and PWD and then go back...