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