Jeff Magouirk (magouirkj@njc.org) writes:
> I am tring to use a command that calls the server to fill an adapter, it
> never seems to get to the adapter, command and the server either times out
> or does not respond. The timeout is set at 10 hours. I am using Visual
> Studio to acces MS SQL - Server.
>
> I think I have all the rights and permissions set correctly. Also, I have
> used this command to fill other adapters and tables.
>
> Does anyone have a suggestion.

I am afraid that the amount of detail in your post is too small for a
good answer to be possible.

One trivial reason could be blocking. You can run sp_who to see if you
have any blocking. If there is a non-zero value in th Blk column, then
that process is blocking the spid for this row.

If the query really takes ten hours to run - then you have some tuning
to do!


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp