I would suppose that if your IIS server is not secure then any strategy for protecting your SQL server will be compromised in one way or anthoer.

I read an article...

This forumware keeps only giving me one line for msg...whats up with that?

ASP is server side does not get sent anywhere. Clear or other wise.

Yes the NULL_yeilds_null off helped me find problem with var. Fixed that all is good. ty

Jonathan! You are the man! 

SET CONCAT_NULL_YIELDS_NULL OFF

Ya know after all the other troubles I had with this procedure I was almost all outta fight.  It was a fantastic learning event...

Yes I did that. The vars contain what they are supposed to. But the proc is working fine from query analyer only not from ADO.

running this in qa performs the...

Yes I did that. The vars contain what they are supposed to. But the proc is working fine from query analyer only not from ADO.

running this in qa performs the...

thats better...

well unfortunetly i think the fetch is neccessary and in this case probable more efficient then any sql statement that if even possible would have too many joins. The...

hmmm forum only giving me one line for my reply

Well

woot! Your solution got me moved ahead enough to find another problem that was causing it to not function.

Within the WHILE I was doing an insert like this:

insert into A...

Thanks Gary!

I modified your script to more closely resemble mine and it worked. I still am having troubles getting my main proc to work, but it's a big proc and...

Sounds more like a data model issue then a syntax one. The tables are not actauly identical.

Is there a requirement for the identity values of each row to be the same...

Had a brainwave this morning that since this proc calls two other proc's I should ensure that nocount is on in them as well. I had allot of hopes but...

I did a few tests:

CREATE PROCEDURE [dbo].[tblVarTest] AS

declare @TableVar table ( uid int)

insert into @TableVar (uid) values (1)

insert into @TableVar (uid) values (2)

insert into @TableVar (uid) values (3)

insert into @TableVar...