Search results for query: *

Does anyone know if it's possible to run a query from a file? I'm trying to update a client database and don't want them to have to zip and send me the db. I'd rather send them a file that they run to make the update. It's a simple data change. Thanks, Jenny

Anyone know how I can send files via SSH from Coldfusion, to another server? Right now I'm using CFEXECUTE against a program called PSCP.exe. The program hangs when calling it from CFEXECUTE, though works perfectly when entering in the command line. It is a command line program, so no issues there.

Did you get anywhere on this Keyser Soze? Thanks, Jenny

Thanks Denny, The retore finally finished after 14 hours!! And you were right, there was 50 gig of free space, and 4 gig of info. The only why to finally delete the free space at the end was to change the recovery mode to 'simple', back up, change to 'full' and back up again. SImply shrinking...

Bill, Will the jobs/transactions fail, or simply overwrite the oldest ones? Thanks, Jenny

Ok, thanks Denny. I'm actually using a 160gig external hard drive to do the job, though so far it's taken over 30 minutes with no progress bar indication. According to the backup file list, the log was 55 gigs, which seems ridiculous to me. The .bak file was only 91meg... Thanks, Jenny

Hi, I can't seem to restore my database because the log file is too big for the space left on my drive. There are a number of reasons for this, to prevent this from happening again... but in the meantime, does anyone know how to restore a .bak file, using only the .mdf and not the .ldf? The...

Very close mihaildamjan, Seems I have MDAC version 2.8, so technically this bug should be fixed already. I keep my eyes open and see if there is anything else. Thanks again, Jenny

Wow, thanks mihaildamjan, I'm reviewing all those articles now and will let you know the result. Very much appreciate your time to post! Thanks, Jenny

When using the Profiler to assess some hangups in one of our VB applications, I keep randomly seeing these two errors: Error 16937 and 16945 Any idea what they are, or where I can find what they mean? Thanks, Jenny

Thanks PHV! This is exactly what I was looking for, and was able to do it too! Jenny

Hi, I'm running SQL7 and seem to have a problem with missing users in the Users view of my DB. I know the users exist, as they use their NT windows login as authentication, and if I try to add them, a message appears stating they already exist. Yet, they are not seen in the view, nor in the...

Can you make an instance of a combobox, and dynamically place it on a form in runtime? Thanks, Jenny

Anyone have an updated link to this? Thanks, Jenny

Hi, OpenArgs seems to work in A2002 in A2000 mode, but does not work in A2000. Any reason for this? Thanks, Jenny

Any luck with this diamondsc? I am having the same random problem, and it's killing my app! Thanks, Jenny

Hi, We have a tape backup plan that backs up the MSSQL7/backup folder every night at 3:00am. For some reason, the folder MSSQL7/backup gets denied every once in a while, stating the tape backup doesn't have permission to back up it. It does of course, and often works fine. I do have a...

JayKusch, Thanks! There was a scheduled job there, making a log backup at 12:00am. Great help! Jenny

PTina, Please excuse my ignorance, but where would one schedule a 'job'? I don't see that anywhere. JayKusch, The date/time you see above is the creation date of the database. The acutal title of the log file shows the time of 00:00:11:93. But, the backup at midnight appears to be a 'log'...

Hi, I'm working on SQL7 and seems to have an unscheduled backup that occurs every night at midnight. I DO have a scheulded one that occurs at 2:00AM, but not at midnight. The log states the following: Log backed up with following information: Database: prod2000, creation date and time...