Viewing 15 posts - 4,846 through 4,860 (of 7,636 total)
Matt Miller (11/11/2008)
November 11, 2008 at 11:50 am
krayknot (11/10/2008)
tymberwyld (11/10/2008)
November 11, 2008 at 7:25 am
oyen_kai (11/10/2008)
rbarryyoung (11/10/2008)
This does not makes sense to me. How did you create the CLR procs on the other server the first time?
I have Database project in Visual Studio...
November 11, 2008 at 7:20 am
Matt Miller (11/10/2008)
November 11, 2008 at 6:52 am
Derek Dongray (11/11/2008)
rbarryyoung (11/10/2008)
Derek Dongray (11/10/2008)
I assume R.Barry Young was kidding ...Not really, "Not Left(name,3) = 'sp_'" is actually what I use. I've never had a problem with it.
Unfortunately,...
November 11, 2008 at 6:23 am
oyen_kai (11/10/2008)
November 10, 2008 at 10:20 pm
krayknot (11/10/2008)and when i supply this command
Select @@trancount
it shows me 2 transactions to be commit or rollback
on the basis of this count i execute a while loop inside which i...
November 10, 2008 at 10:06 pm
Matt Miller (11/10/2008)
The only way I know how to do that is to call the proc from within ANOTHER proc. Which sucks, I know.
Oh I would be OK with...
November 10, 2008 at 9:59 pm
Matt Miller (11/10/2008)
Or - use a WAITFOR with a Service Broker Group conversation handle....No loop.
OMG, you are killing me here Matt! I am using Service Broker with WAITFOR, that's...
November 10, 2008 at 9:56 pm
Why wouldn't you just copy the assemblies over and reload them?
November 10, 2008 at 9:52 pm
Jeff Moden (11/10/2008)
I actually think a loop of some sort would probably be faster for this (GAK! I can't believe I just said that! :hehe:)...
Heh. Yeah, I've been...
November 10, 2008 at 9:48 pm
How big is the Sales table? Is it possible that it is INSERTing into the Sales table but with unexpected values so that it is getting lost?
Also, have you checked...
November 10, 2008 at 9:44 pm
Can you post the current version of the code?
November 10, 2008 at 9:26 pm
Viewing 15 posts - 4,846 through 4,860 (of 7,636 total)