Good article and led me to check our backup plans set up by a contractor. Discovered that there is no clearing of the backup and restore history and msdb has...

Thanks, we were rebuilding the DBs from scratch, but the errors keep reoccurring.

After a bit more research I turned up this article: http://support.microsoft.com/kb/940126. As we are on SP2,...

Thanks again for your help.

I have got the first method working and tested it against the longest sql it will encounter. Everything is working fine 🙂

Thanks Ramesh.

Two points:

1) Think I can use this. The only problem I can see is if the dynamic sql exceeds 8000 characters, but hopefully that will not be the case.

2)...

Is there a way to get it to run if the table name is the final part of the code? E.g. if a view finishes with 'FROM tbl_test'. Realise you...

Have you tried opening the connection via coding first? I use this to establish the connections when I first open the database:

objConn.Open strConn, strUID, strPwd

For Each...