Post reply

SQL Time out error

  • November 6, 2007 at 11:52 am

    #200230

    I am creating a stored procedure that is trying to use bcp to create an ASCII text file. I am using execute xp_cmdshell within the stored procedure. It hung up and now I can't open the tables I was using in the procedure. The error I'm getting is "ODBC SQL Server Driver Lock request time out period exceeded".

    What does this mean and how can I fix it?

    Thanks, Ed

  • November 6, 2007 at 12:49 pm

    #748814

    Hi Ed

    BCP probably locked that resource and when you try and access it the ODBC driver you use times out waiting for access to that table.

    You could use the system stored procedure sp_who2 to try and find the connection that is holding the lock on that table, then use the KILL statement to release it.

  • November 6, 2007 at 1:44 pm

    #748849

    Thanks for the help!!!

    Ed

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply