Recent content by 3270

Hi got a problem with some transactions i hope someone kan show me a workaround If got the following sql code begin transaction A DO SOMETHING begin transaction b insert test values ("AAAA") -- Please keep commit transaction b DO SOMETHING MORE rollback transaction a Is there a way...

I found the error, just had to disable "shared memory protocol"

Hi Im trying to measure the performance on some changes im going to make. So i created a script which calls some stored procedures, in a while loop. When run the script from the query analyzer, a round trip in the while loop takes about 3,5 seconds. I then make 3 other connections, and start...

select @string = replace(@string ,' ',space(0)) returns null. I guess there is no easy solution then.

select @string = replace(replace(@string ,' ','*'),'*','') doesnt work for me either. if my statements is like this select @string = 'aaaxxyyy' select @string = replace(@string,'x','') the result is : 'aaa yyy'

When i use the replace proecdure nothing happends, the ouput is 'xxx yyy z zz' if i write select @string = replace(@string ,' ','*') the output is 'xxx*yyy*z*zz'

On a Sql 2000 server in 6.5 mode and @@options = 0

Hi whats the easy way to remove blanks from the at string? If i got a string like this 'xxx yyy z zz' and i want it to look like this 'xxxyyyzzz' is there then a simple solution? example thats doesnt work: declare @String varchar(20) select @string = 'xxx yyy z zz' select @string =...

We have changed to sql2000 mainly because of the lack of ms support. But also because i doesnt perform that well backing up 40gb of data takes a very long time on 6.5. The trick with setting rowcount = 1 isnt optimal, because the select is in a stored procedure. it looks like this testproc...

Hi thanx for the answers vongrunt: there are no search order mrdenny tempdb is in 6.5 mode. The value of @test in on sql 6.5 is 1 The value of @test in on sql 2000 is 3

Hi I got a bit of problem. Im converting from and old sql 6.5 server to a new sql 2000 server(in 6.5 mode, and withansi defaults off) Ill try to illustrate the problem with the following select create table #test ( test int ) go truncate table #test insert into #test values (1) insert into...