An Amazing Errorrrrrrrrrrrrrrrr

Jun 8, 2007

Hi All Friends

i have an amazing error in my project

i wrote a project in ASP.NET 2

a part of this project change a value in a row in a table in sql 2005 to another value

i used it in my computer (With Local host and my own iis) and it works properly and without any problem

but when i upload it in internet it have this error:

"Concurrency violation: the UpdateCommand affected 0 of the expected 1 records. "

can anyone help me?

i think the error is from my table in sql 2005 but i dont know what is wrong in it

thanks for your cares friends and im waiting for your usefull answers

 

 

 

View 3 Replies


ADVERTISEMENT

Amazing

Jan 24, 2007

Hi everyone,

I've got a dts 2000 which owns a Sql Task:

werweuroweuroiweruewr
DECLARE @CONTADOR BIGINT
SET @CONTADOR = 0

WHILE @CONTADOR <= 100000
BEGIN
INSERT INTO TABLA1 (ID,NOMBRE) VALUES(@CONTADOR,'PRUEBAS')
SET @CONTADOR = @CONTADOR + 1

END

'werweuroweuroiweruewr' obviously doesn't exists in my database, but it's ignored 110 times.
Then I see that TABLA1 own 100 rows. After that fails, of course.

Could you please so kind to give me any explanation for this behaviour. I'm totally stuck,
I haven't enought words (in english) in order to define this!

Why SQL executes 110 times that loop and then, oh my god, discover that 'weerrrr...' doesn't exists at all and stop!

If possible and there is explanation for that it could happen in SQL 2005??

Thanks in advance,

View 4 Replies View Related

Log File Growing In Amazing Manner

Sep 28, 2004

I started my database in last week to user with transfer data from Sybase to sql 2000 server. Intitally log file size was few MB near to 20 MB for each co’s, within 8 days it has reached upto 300 MB still datafile size in few MB , approximately 40MB for each co’s, why log file growing in such manger, how I can manage it?

Thanking You

R.Mall

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved