> On 2/15/06, Michael Dinowitz <[EMAIL PROTECTED]> wrote: > > > > That oracle ping query was rather interesting and I wonder if MSSQL has an > > equivalent without a lot of overhead (i.e. no overhead at all). > >
I don't use ColdFusion with SQL Server, but we do have a SQL Server instance that I checked against and I simply did: SELECT getDate() That's it. I'm not sure if the SQL Server JDBC drivers are happy with that syntax, but the SQL Query Analyzer had no problem with it. Regards, Dave. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232376 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
