Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. skicamel

    IPhone Exchange calendar sync

    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...
  2. skicamel

    IPhone Exchange calendar sync

    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...
  3. skicamel

    IPhone Exchange calendar sync

    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...
  4. skicamel

    Cell reference formatting

    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...
  5. skicamel

    Recursive scp - w/ wildcard - Maintain file structure

    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="*"...
  6. skicamel

    Recursive scp - w/ wildcard - Maintain file structure

    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...
  7. skicamel

    Start job from trigger w- non-admin user

    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...
  8. skicamel

    Start job from trigger w- non-admin user

    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?
  9. skicamel

    Start job from trigger w- non-admin user

    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...
  10. skicamel

    Interval conversion

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

    Interval conversion

    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
  12. skicamel

    Interval conversion

    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...
  13. skicamel

    import from 1 or more dynamic sources

    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
  14. skicamel

    import from 1 or more dynamic sources

    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...
  15. skicamel

    Images stored in database

    ...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?
  16. skicamel

    Images stored in database

    If I were more conspiratorial, I'd think nobody actually knows how to do this. In language we should all understand... replicate('I just want to learn it. ',100)
  17. skicamel

    Images stored in database

    How does one go about viewing images stored in SQL? I've googled my little heart out, and can only find pages telling me not to store images, just pointers to their physical locations. I'm aware it's not optimal. But I'm a knowledge sponge fallen off the wagon. Though it's extremely rare...
  18. skicamel

    Locking tables: Multi-table inserts

    Side note: I haven't been back here in some time. Odd not seeing Terry's name up in the MVP list. He still pop in here from time to time?
  19. skicamel

    Locking tables: Multi-table inserts

    That's a very useful link. Thanks, Wayne. We acquired a little over a dozen companies some time ago. Each billing system was in a separate SQL database. I'm transferring the databases into our main billing database. The main transfer scripts I use are during off hours and haven't been an...
  20. skicamel

    Locking tables: Multi-table inserts

    Between a 'begin transaction' and 'commit transaction', will the database lock all tables involved until the commit transaction is executed? I've seen various posts about locking single tables, but the proc I'm using touches a few dozen tables. If the 'transaction' doesn't lock all of the...

Part and Inventory Search

Back
Top