Dear bkelley

Thank you for help!..

Mr. chrhedga also helped me, now i got two different method to solve the problem. That is using @@identity

Any way Thanks a lot

with lov

Kiran

Dear chrhedga

Thanks again.

That worked !!...

You have been a tremendous help!

Thanks a lot

Kiran

Dear chrhedga

I am calling a stored procedure in SQL Server from VB and I am using that code inside the SQL Server procedure and I will return the value to...

hi chrhedga

u mean

begin tran

and

commit tran?

I have tried that also, but it doen't make any difference

Thanks for your reply

Kiran

Hi Tim,

Actually "log on as service" was not enabled for the account i use, but now i have enabled that, but des't affected the current status(Still I am getting the...

Hi timwilliams,

It is a separate server under a doamin server.

Thanks for replay

Kiran

Thank you for your reply,

DBCC CHECKIDENT (“Employee”,RESEED, 2) worked ok.

When I tried to execute ALTER TABLE Employee ALTER COLUMN Employee_id int IDENTITY(2,2) generated an error..

“Incorrect syntax near the key word...

Hi Brian,

Thank you for your reply,

While executing the procedure I am getting the message

“The Command(s) competed successfully”

But the global temp table is not created!..

If you are using the code...

Hello David,

It's Ok, but, suppose I want perform some computation on the returned value, I have to store the value in a variable. In my case, I want this value...