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!

Recent content by DavidLemire

  1. DavidLemire

    Linked Server Information

    Thanks mrdenny! Do you have any advice on optimization for this linked server? Minimum impact must be met for target server, maximum processing should be induced to the calling server. Right now, I heard you can specify that the two servers use same collation, so the target doesn't have to...
  2. DavidLemire

    Linked Server Information

    Hi Guys, I have 2 SQL servers linked by a VPN. On one server, I need to run a SP every one minute on the other server. To do that, we decided a linked server would be best. We want to know which one is most optimized between: 1. At run-time, create a linked server, open it, run query, close...
  3. DavidLemire

    Division by zero!

    Thanks JamesLean!! I tried with ArithIgnore, and it didn't work. Didn't know I had to put off ArithAbort and Ansi_warnings :) I love you guys, it works perfectly now! :) --- David Lemire, Consultant System Technologies for Industry Inc.
  4. DavidLemire

    Division by zero!

    Hi people, I need a little guidance here. To make a long story short, I have a string which would be "(123/0)+23". I need to put that string in a dynamic query. However, I want to avoid the division by zero error. if charindex('/0',@DynamicNumber) <> 0 that won't work here, because I can have...
  5. DavidLemire

    Auditing Stored Procedure Progress

    Thanks! So basically, what you are telling me is that I can run my SP (which will become a job) through a system SP, and that I can monitor this job? And that is done throught SQLAgent service? If so, that is exactly what I want to do and I'll look at that as soon as I can! --- David Lemire...
  6. DavidLemire

    Auditing Stored Procedure Progress

    Thanks for your fast reply. That is an idea a coworker already gave me. I never tried multithreading with a VBA application, but the point is that multiple users may be running the same report at the same time. In that case, I would have the same table name. That leaves me with two things: 1...
  7. DavidLemire

    Auditing Stored Procedure Progress

    Hi friends, This is my first post on this forum, as I've just registered for TekTips. I hope you are a great community, and if that is the case, I'll do my best to keep this community healthy! Ok, down to the point. I have an Excel report that calls a stored procedure. This SP then returns...
See more

Part and Inventory Search

Back
Top