Hi,
I'm having an issue where a user has been using SQL*PLUS to query a SID on an Oracle Database Server 11g Release 1.
They have a read-only SQL account to run the query, which returns 67,000+ rows when they run it on their old laptop, but 0 rows when they run it on their current laptop...
Hi,
I'm trying to find out how to determine whether a server has a MOSS 2007 WFE installation on it based off the running processes or services.
It seems relatively simple to run PsTools query on a server's processes/services to find out whether any WSS 3.0 services are running, but given...
Hi, I've got a command prompt batch script which extracts the day of week, day number, month number, year, hour and seconds. Unfortunately, whilst it does work, it gets the day number and month number confused when ran with US regional settings - and it needs to work in both UK and US settings...
I've made some progress with this, in terms of automating the process which works out which folders are needing to be moved and which don't (not written in a batch script).
I'm now at a point where I've got a CSV file which has all the folders which need moving in. But I'm unsure how to...
I'm unsure if this is the right forum so please let me know where to post this if this is the wrong place.
My problem is this:
I have about 2500+ folders located in a directory "C:\Projects", in a folder structure of "C:\Projects\0", "C:\Projects\100", "C:\Projects\200" and so on up to...
I wasn't able to record it manually as macro. By the way I forgot to mention in my first post that the DB I'm connecting to is an Oracle DB if that makes any difference (sorry if that sounds stupid, am really new to all this).
Hi,
I have successfully managed to connect to a database on a server, and NOT using the wizard I executed the below query in Microsoft Query then return the data to Excel.
select * from projects
where team = 'TEAM1'
and startdate >
to_date( '01-apr-2007 00:00:00', 'dd-mon-yyyy hh24:mi:ss' )...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.