see the link

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_sa-sz_0kro.asp

Linto

Then, what will be the error description you are getting on the front end application ??

Linto

we had also a similiar problem while calling BULK INSERT from a C++ program. and after increasing the timeout in the ADO connection object in C++ solved this.

Linto

we had an installation program developed in Installshield which is a great tool for this purpose..

We wrote a utility just for restoring from MDF and LDF based on the parameters...

see today's article also!!

http://www.sqlservercentral.com/columnists/darjun/deletingduplicaterows.asp

Linto

it will be in our logs.. even though its not blocking!!

I will always not go for composite primary key if that key is going to be a foreign key of another table.

In the case if you have an orderdetail...

write a subquery which will return only qt_id and Ans_Id combination and then join that subquery with rest of your conditions and select statements.

like this...

select subquery.qt_id, subquery.ans_id, <<rest of the...

I don't see any other method than parsing the string and updating the table as you mentioned in the question...

XML integration is only in the initial stages and by YUKON,...

from where you are calling your stored procedure ?

Is there any configuration changes than the normal settings ? Earlier, i forced to put BEGIN--END and these days its not...

Read today's headline on SQLServerCentral.com

http://www.sqlservercentral.com/columnists/darjun/deletingduplicaterows.asp

Linto

What is your question ?

What is the relation between SQL/PHP ?

Are you trying to reach Microsoft SQL or MySQL... wherever I heard earlier about PHP, the combination is MySQL/PHP and...

It is supposed to return the last identity value inserted across the database...

As per my experience, if you want to get the last inserted record's ID.. the SAFE way is...

u r welcome...

Frank, u may need a fast connection! I posted that 3 minutes before you caught that..

USE CEILING... see the modified code

DECLARE @x DECIMAL(5,2)

DECLARE @y INT

SET @x = 1

SET @x = @x / 8

SET @y = ceiling(@x * 5)

select @y

Linto