Recent content by skicamel

Preaching to the choir... New CFO came in a few months ago with shiny new IPhone (BES server working out wonderfully for all the Blackberry folk), will not approve any spending, & swears up & down he has friends that could make this work without any further expense. Note there are now 3 IPhone...

Thanks for the answer... Have you (or anyone else out there) successfully set up full syncing with an IPhone using a reverse proxy other than ISA? Recommendations? It's been a few years, but I'm planning on setting up a Linux box w/ Apache. Would you recommend utilizing mod_proxy, or could...

Nutshell version. We've got an Exchange 2003 mail server behind our firewall. The IP is not externally routable. We do not have an ISA server. We have webmail working through a DMZ'd server that port-forwards through to the mail server. As is, does anyone know of a way to get the Exchange...

Scenario: Cell A1 contains whatever data Cell A2 contains formula : =A1 Any data changed in A1 obvoiusly changes A2. Is it possible to change the format of A2 based on the format of A1 as well? i.e. Set A1 to bold, and automatically have A2 changed to bold? Found ways to get close with...

Actually, I hadn't. Ran into rsync while googling and passed over it thinking it was basically a bulk-type mirroring tool w/o much in the way of options. Didn't realize how powerful it could be. Ended up w/ something like this: rsync -av --include="*/" --include="*20060408.gz" --exclude="*"...

The goal is to scp into another server and pull all files matching a format, say 20060408.gz, from all folders in a certain directory, say /home/tmp. scp -r user@server:/home/tmp/ del/ keeps the file structure intact, but obviously, pulls all files, not just 20060408.gz. scp -r...

Didn't even think to use sp_OA procedures. I am ashamed. Major kudos on the other two. Very good information there. Looks like any of the 3 should work. Thanks for the help. Haven't been here in ages, and not seeing good old Terry Broadbent in here gave me pause, but it looks like tek-tips...

Thought I'd already tried that, but it looks like not. Now it will call the job, but still no go: "Non-SysAdmins have been denied permission to run ActiveScripting job steps. The step failed." Ideas?

I've got a php page that, under certain, rare circumstances, adds a row to a table. The goal is to receive an email notification whenever a row is inserted. xp_sendmail is not an option (have 'sa' access to mssql, but little access on the box itself). MSSQL Notifications are out for the...

I could swear that section in the documentation was not there yesterday. *cough* Thanks a million.

Good Lord. I've spent two days on this, and figure out one way minutes after posting here. cast((timeused ||' seconds') as interval) I'd still like to hear if anyone knows of any straightforward ways to go from interval to seconds. Thanks again, folks. Dan

I've got a number of tables containing data that comes from outside sources. I'd like to create a unifying view of the key information. The issue is session time. Most of the tables have this information stored in seconds. Some only contain the start & end dates. I can get the session time...

Thanks for the help. I got some good info from sqldts.com (through one of your other post's threads). I've been 'tasked a deliverable' on another project, so I'll have to play a bit more w/ this after work. Thanks again. Dan

I've got a package set up to pull an excel file from an ftp datasource. The format is along the lines of filename20051115.xls and changes daily based on the date. I have a dynamic properties task that generates a filename for a date of 3 days prior. All runs fine as is. The issue is that the...

...and side note... being born in Elgin... The Bears are going to hit the playoffs this year... Super Bowl next year... Figure every 20 years works, eh?