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!

  • Congratulations gkittelson 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. sarah2michelle

    Map software w/ SQL?

    This may be the wrong forum for this question, but I'm not sure where else to put it. I am interested in giving users a city map with a way to enter an address, and show them a pin-point on the map where the address is. There must be some software or tool out there to help with this, but I'm...
  2. sarah2michelle

    Generate SP Execution Plan at server startup?

    I have a SP that takes about 90 seconds longer to run the first time every time after a reboot, the performance is much better after that, until the next reboot. I am assuming this is because the execution plan is stored in memory after the first use. Is there a way to make SQL generate the...
  3. sarah2michelle

    How to include attachment with mailto?

    Thanks! I'll try the other forum and cross my fingers in the meantime.
  4. sarah2michelle

    How to include attachment with mailto?

    Is there a way to create an email with an attachment through a mailto command line? Here is what I have so far... start mailto:test@test.com?subject=See&body=See Attachment&attachment=c:\test\account3.bmp This will create the email, but no attachment. I am using outlook, but want this to...
  5. sarah2michelle

    Adding attachment to message created by mailto command

    Is there a way to create an email with an attachment through a mailto command line? Here is what I have so far... start mailto:test@test.com?subject=See&body=See Attachment&attachment=c:\test\account3.bmp This will create the email, but no attachment. I am using outlook, but want this to...
  6. sarah2michelle

    Show same date in current year from another date

    I should have messed with this longer before posting it. Here is the formula I came up with, if anyone has better ideas, they would be very much appreciated! This logic does not take leap years into account...
  7. sarah2michelle

    Show same date in current year from another date

    I am sorry the subject is confusing, but I'm not sure how to summarize the question better. We have a date that could be during the current year or anytime prior. I need to get that date in the last 12 months. If the date was 12/1/2005, that's within the past 12 months, so it is good. If...
  8. sarah2michelle

    Why won't my job fire?

    I have a simple job that does not seem to fire on our live system. An identical job is set on a test system locally, and it fires with no problem. The only thing I know of that is different is that the one on the local station was created while logged in as SA, and the one on the live server...
  9. sarah2michelle

    Best way to run date-triggered update?

    That brings up another problem then, but I'll post that to a new thread. Thanks again!
  10. sarah2michelle

    Best way to run date-triggered update?

    We have an update statement that should run at 1201AM every day. What is the best way to do this? I've found how to do it using a SQL Agent Job, but is that the best way? Does anyone know of other alternatives? Thanks! Sarah
  11. sarah2michelle

    Find license key

    We had a copy of Acrobat Writer installed and the machine it was on crashed. Writer isn't installed now, but all the files are there like it was installed. We don't have the original CD case with the license key, but is there any way to find what the original license key was from any of the...

Part and Inventory Search

Back
Top