Thanks for your responses,

We are looking into the stored procedure angle.  They are actually using a form to filter the data and they don't return any records when the form...

Zouhir,

I do not believe the implicit transactions are what are causing the problem. The problem is with the SET IDENTITY_INSERT "dbo"."B" ON statements. The SET IDENTITY_INSERT on...

Since it is a SQL statement, how about breaking it up into several variables: select, from, where, groupby etc.?

That would give you 8k a piece. Would that...

Zouhir,

If all you are doing is saving the data for archiving or for performance sake, I would take off the auto number on the subsequent tables because the inital table...

I was able to reproduce your error. I am looking into it. Do you need to have the autonumbers on the second and third tables? What are...

A couple of questions: Are you inserting data into the primary keys? SQL Server won't allow you insert data into the auto number field.

Also, how are you...

Rather

select field1, isnull(field2, '<None>') from table

group by field1, isnull(field2, '<None>')

You might try to put the field into a isnull function and force it to return a value that way.

For example:

select field1, isnull(field2, '<None>') from table

group by field1, isnull(field2,...

I found the problem! The files being accessed were on the Web server and the script source access was not set, so it was not letting it look at...

Allen,

I have learned more about the problem. I thought the error might be a resource problem, so I moved the sever over to a different machine. I got...

No its not. That's why I am confused. It is when I choose a different SQL user it works.

Richard

Edited by - rbinnington on 05/29/2003 09:34:58 AM

Ok,

I tried the script a couple of different ways using QA and Profiler. When I tried just running the script exactly as you had it, it failed during the...

I am sorry to be bothersome, but I got it to work manually the way you described, but when I put it into a stored procedure it gave me the...

Thanks once again! That really helped me out and nailed it for me.

Richard

THANKS!!!

That worked like a charm abd I appreciate the quick response.

I have a second question though. I am still new to a lot of this stuff, but how do...