Remi,

Thanks for reply, I've tried adding the mycn = nothing however the store procedure says the connection  still exists with the status is set to sleeping.

Thanks for that. We've created a modified page in the system to throw back the actual error as opposed to 'Couldn't connect to database'. Will try suggested port number and...

Thanks for the response. The connection string in question is in the format of:

<

add key="connectionstring" value="data source=10.9.675.3;initial catalog=NW_Data;user id=LOGIN;password=aaabbb">

Cheers for response, put an index on and both sp's now take only 10 secs to return results,

Thanks

Dave

Thanks newbie for the response. I added:

set nocount on

after the AS in my sp and this seems to have sorted it!!

Are there any other 'settings' as such that I can...

Thanks bdohmen for the response. Changed SPs to use output, which sorted it out (in the end!)

Cheers

Dave

Thanks for the suggestion of using OUTPUT. How would I use this with a select statement like:

Select * from Employee inner join etc where etc

How would the OUTPUT contain the...

Thanks for the response, thats cleared it up!

Thanks for the suggestions guys.

I'd created a script file that seems to work using the Wizard in SQL Server. It creates all the tables, inner joins, Sps etc. I was...