Yes it works if all fields in myTable are varchar. As soon as I make them int, datetime etc, I get type mismatch error when I bulkinsert from the text...

Mom tought me some French but I cannot write

Doesn't work. How to insert into myTable (id int primary key not null, name varchar(50), date datetime )

id | name | date

from the file C:\myFile.txt :

100| yann | 02/01/2008

200|...

Thanks! It works.

Are you French? I am Russian 😛

"On Grant's scale of tolerability, I'm currently falling somewhere between staphilococcus and streptococcus"

Oh dear.. Matt, you made my day. I was laughing for several minutes. OK, back to my bug's...

Life was so easy when I was doing open source:P

Long leave LAMP ..

By the way guys, you talk about how DBAs are under appreciated. You don't know what's a developer's...

"You just have to remove the developer edition before installing DBPro."

This was exactly my question. I don't want to remove anything. I am both. I need both. I am a...

No, my company is not licensed for team suit. Maybe they will buy it, maybe not. Our tech services provided me with Visual Studio Team Edition for Developers so I...

"Besides load-testing the proc (set up 1000 connections on your computer and run them all at once, 100 times each), which would reveal any hidden problem in the proc, I...

Doug,

seems like changes in the stored procedure did help. Thank you very much, you are very smart!

-V

Hi Doug,

this was created without errors (for 2005)

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE TEST

AS

BEGIN

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

BEGIN TRANSACTION;

SELECT getdate();

COMMIT TRANSACTION;

END

"On the performance side: response.redirect causes a postback to the browser resulting in 2 requests back to the web server from the client, while server.transfer advances to the next ASPX...

Doug,

here's your SP;

SP InsertNewOrder:

Begin

set transaction isolation level serializable

-- Store identity in @MyKey during the tran and return from the variable

Declare @MyKey int

-- The real problem was a lack of transactions,...

OK. I still try to pinpoint the problem, is it vb code, application server settings, SQL server settings, scope_identity problem. I read a lot of info regarding session loss etc,...

This is what I got after running it on my local server on my machine:

Scope from IoI trigger [1]

Out of luck

Does it mean scope_identity doesn't work?