Hello I need some advice... Let's have two network : Nprod and Ndev. The production server is on Nprod and is connected to 80 customers databases through 80 VPN, all is fine here. But... we need also to connect the Ndev network to the customers databases, for easy (and sometimes emergency) debugging. Sometimes we have a VPN between Ndev and away DBs, sometimes not, and in this case we have to connect to a remote desktop on the Nprod network, open a connection server, pass queries one by one, and try to understand what's going wrong X| = not very convenient and lost of times to react to the bug. So my question is : Is there a way to connect my dev desktop to the Nprod, and then using the VPNs Nprod <-> Customers DB, something like a connector installed on the Nprod network which could pass queries and return results to my dev network ? I don't know where and what to search so if you have some tips or tricks to orient my search, it should be great :)

Hello everybody I have a strange behaviour on an image link with hover image. When we click and then leave (quickly) the link, the alt is dispayed like if there was no image = alt attribute is displayed, just before new page is openned. to reproduce : http://jsfiddle.net/BuETP/1/[^] click the button and just leave it quicky. "alt" attribute is displayed about 1/2 second... Can't reproduce it on IE, just in Chrome. Have you an idea on what i'm doing wrong ? Thanks very much !

Haha, i think i found the hidden order... Region are simply ordered by descending their longitude, contacts by the length of their name (descending) then by their fourth letter (ascending). As we know commonly longitudes of theses cities/regions are Cape Town : 18.45° Durban : 30.6° Johannesburg : 27° For the understanding, we suppose we have a table containing longitudes (while in real life we would need -of course- the request to connect to googlemap api to find it) (googlemap find CapeTown and Cape Town same longitude): wtf_region_longitude region longitude Cape Town 18 CapeTown 18 Durban 31 Johannesburg 27 and the table of fig 1: wtf_region_contacts Region Contact Cape Town Fred Cape Town Joe Cape Town Anna Durban John Durban Mary Johannesburg Frank Doing permutation between Joe and Fred, the request is :

select s.region, contact from
(
select c.region,
contact = case contact when 'Joe' then 'Fred' when 'Fred' then 'Joe' else contact end
,contact as ocontact
from wtf_region_contacts c
) s, wtf_region_longitude l
where s.region=l.region
order by longitude desc, LEN(contact) desc, SUBSTRING(contact,4,1) asc

--> region contact Durban John Durban Mary Johannesburg Frank Cape Town Anna CapeTown Fred Cape Town Joe Am I right ?

modified on Friday, November 26, 2010 4:30 AM