Viewing 15 posts - 7,951 through 7,965 (of 9,701 total)
Edit: Misread original post. Deleting this comment and looking for a better solution.
May 7, 2010 at 5:56 am
Paul_Harvey (5/7/2010)
It seems add that simply setting the RetainSameConnection to True would cause a permissions error.
I've never actually seen that error before, and I've used the RetainSameConnection property. But never...
May 7, 2010 at 5:50 am
The number of times a query runs doesn't mean anything. What matters is the number of reads, writes, and recompiles. Also the length of time a query runs.
I'll take a...
May 7, 2010 at 4:56 am
Are you running a clustered server environment? Does your network use a foundary for passing up connections to the cluster?
We've had issues with our foundary where it would keep routing...
May 6, 2010 at 5:57 am
nana.asare (5/5/2010)
i have attached a screen shot of the error i got to my reply
Read the error carefully. See where it says "or Remote connections are not allowed?"
Brandie Tarvin (4/29/2010)
May 6, 2010 at 4:27 am
emily-1119612 (5/5/2010)
>>Most of the actual SQL code is generated & issued by a 3rd party applicationSo does this 3rd party support 2008?
That's actually a huge issue with using third party...
May 6, 2010 at 4:17 am
wodom (5/5/2010)
It sounds like you're saying DTS has been replaced by SSIS in the newer versions.
That's exactly what he's saying. DTS was completely taken apart and rebuilt from the ground...
May 6, 2010 at 4:15 am
Kwisatz78 (5/5/2010)
Sorry I am not even getting to execute code, this error happens when trying to connect to the database engine remotely.
Walk us through the steps you're using to...
May 5, 2010 at 11:34 am
How are you running through SSMS? Are you right-clicking an object in the Object Explorer and choosing execute or are you running the code directly in a query window?
We ran...
May 5, 2010 at 4:13 am
wodom (5/4/2010)
May 4, 2010 at 3:26 pm
Sorry, I misspoke. I don't run InputBuffer anymore. I have better code now that gives me the entire context of the command instead of just the first X number of...
May 4, 2010 at 12:53 pm
wodom (5/4/2010)
Brandie Tarvin (5/4/2010)
He's asking if your SQL 2000 is 64 bit or 32 bit.
I don't know. Haven't been able to find out. We're supposed to download it from MS....
May 4, 2010 at 12:51 pm
It doesn't matter what database you're on for the InputBuffer command (and I believe the same for the OpenTran). A SPID is unique in the whole server instance. It should...
May 4, 2010 at 12:48 pm
Viewing 15 posts - 7,951 through 7,965 (of 9,701 total)