If you are not getting an error then it should not through the error message. It is hard to tell based on the limited code snippets you have provided....

AS Jeff Moden mentioned earlier, it could be a network issue as well. Are there backups across the network running at this time? You can test this a...

It would be easier to answer your question if you posted some DDL, your queries, and the execution plans. It could be as simple as the statistics were updated...

mbender (6/4/2008)

---

Is there a way either thru sql or using ADO Properties to tell whether or not a table is locked. Basically my problem is we write most of...

I think you need this:

SET @SQLString = N'spiTriggerControl';

to be this:

SET @SQLString = N'Exec spiTriggerControl';

I'm not sure why you are using sp_executesql based on the information you have provided. You...

At the very least is your ordering. You are never setting @ErrMsg because it is after your goto.

If you are doing multiple inserts\updates in a single transaction why use...

If you want to track changes to stored procedures you can create a DDL trigger for ALTER PROCEDURE, I assume you are on 2005 since this is a 2005 forum,...

Good catch. I did not completely read the script. I asked about restores because I have seen this when the login is not on the server you restored...

Are these databases that have been restored from another server?

I just read a short blog post that touches on this subject, http://sqlblog.com/blogs/john_paul_cook/archive/2008/06/04/hyper-v-at-teched-questions-and-answers.aspx that might be of some interest to you.

Yes I the instance needs to be up and running as there is nothing to connect to, if there is no instance. See How To: Restore the master Database...

I believe this thread has the answer, http://www.sqlservercentral.com/Forums/Topic140287-5-1.aspx

Here is a way to check when stats where last updated.

[font="Courier New"]SELECT

    ST.name AS stats_name,

    COL_NAME(sic.OBJECT_ID, sic.column_id) AS column_name,

    STATS_DATE(st.OBJECT_ID, st.stats_id) AS last_updated

FROM

    sys.tables AS tbl INNER JOIN

    sys.stats st ON st.OBJECT_ID=tbl.OBJECT_ID INNER JOIN...

You need to do SET IDENTITY_INSERT ON in order to explicitly insert a value into the identity column.

Is it a web application? What are the connection strings for the applications? What are the differences in the applications?