Are there any other error messages in the SQL Error Log?

Are you generating a cartesian join when you include both join conditions? Try using SET ROWCOUNT to limit the number...

... and if necessary, kill any current connections.

 

Both services startup using a domain user account.

Problem hasn't re-appeared for the last couple of days. We could have isolated the problem to a dodgy WINS entry that was preventing...

Ok, the reason you would have got the sp_executesql is because you haven't set the command type to StoredProcedure. I think by default the command type would just be text...

Have you had a look at the white paper here?

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx

 

Just wondering why you would use sp_executesql anyway?

Couldn't just run,

exec spGetAuthorsList @author_id=1, @FindExact=0

 

OK, so can you map out the fields

A222|ZS08          |0005      |H350        |GENERAL_REPAIR      |A              |28.02.2004|01.02.2004|0000352836     |000

EG

Table: A222
Field: ZS08 Value:0005
etc...

BTW, who thought up the names and file format?

ApexSQL Proc Blaster does do this. There are other products out there as well that generate a full end-to-end solution.

EG: Iron Speed Designer - Point it at the database and...

As we are talking about a database engine that is far and away more powerful than Access. Is there any reason to apply the same logic?

0)...

Ok, so this is a single data record,

A222|ZS08          |0005      |H350        |GENERAL_REPAIR      |A              |28.02.2004|01.02.2004|0000352836     |000

Is A222 the destination table  and ZS08 the field? (For sanity sake I hope not :crazy