[Resolved] Return value of Stored Procedure

[naruponk]

Dear szlamany,

Thanks for reply
What does SET QUOTED_IDENTIFIER ON and SET ANSI_NULLS ON do?
I can't run your Stored procedure cause i have no some of your stored procedure can you give me more shortly?

Normally i use command to open recordset from stored procedure, works fine.
but i can't open a recordset (using command) from stored procedure which is using RETURN keyword

Thanks everyone

[szlamany]

Dear szlamany,

Thanks for reply
What does SET QUOTED_IDENTIFIER ON and SET ANSI_NULLS ON do?
I can't run your Stored procedure cause i have no some of your stored procedure can you give me more shortly?

Normally i use command to open recordset from stored procedure, works fine.
but i can't open a recordset (using command) from stored procedure which is using RETURN keyword

Thanks everyone

Another one of our rules is to SCRIPT all DB objects in TEXT FILES that end in .SQL and execute them in QUERY ANALYZER to load them into the database.

That SET QUOTED stuff is just boilerplate that we have in our SCRIPT files - something we saw that MS did in their scripts.