My issues are I don't see an insert taking more than 90 seconds (causing the service to time out) based on all the previos info about the table.

Your sure the...

If there is no blocking locks or lingering locks (during insert/indexing) what is happening? It took two minutes to run this procedure manually? Is the database db_option 'auto close' set...

Are you sure that will help in this case? I have only used that to fix invalid reports from sp_spaceused and anything that uses dbo.sysindexes. sp_helpfile is reporting from dbo.sysfiles.

I agree with Rudy as far as EM, not when it comes to sp_helpfile returning incorrect values.

Please post the directory listing of the data files, sp_helpfile for the database, and the...

Did you take a minute to look at any logs?

All, my PK violation was just an example to get us thinking! I think we shouold take a moment and step through this and not get ahead of ourselves by...

I am confused! You are guessing it is timing out, is there no log or run time error being thrown? For all you know you are inserting duplicate records and a...

What?

Review the agent log and OS system log, and SQL Server logs for more info.

I used it years ago, and if my memory is correct you can save it as html.

Review the agent log and OS system log for more info.

Create Table #tmp (theCount Integer)

Insert Into #tmp

Exec @CMDWSHScript

Then you can do whatever you want with the data in the temp table.

Did you drop the login as well?

In EM under the database tab right click on the appropriate database and select 'all tasks' --> 'Generate SQL script' and from there you will be able to script the...

Does sp_helpdb show restricted options and do the users that can connect have db_owner role in the database. Just something that could be overlooked. If possible can you drop the...