Ear

Hmm. I'm with Koen - I'd think you would know the schema to support your website.

Here are two alternatives to sp_MSforeachdb

http://sqlblog.com/blogs/aaron_bertrand/archive/2010/12/29/a-more-reliable-and-more-flexible-sp-msforeachdb.aspx

And then this one that I have been using:

http://spaghettidba.com/2011/09/09/a-better-sp_msforeachdb/

With a few samples of usage here

http://jasonbrimhall.info/2012/07/17/a-trio-of-eachdb/

Kingston Dhasian (1/23/2013)

---

Any particular reason for avoiding the use of...

In addition to what Gail said, here is a simple script to Read from the default trace

DECLARE @path NVARCHAR(260);

SELECT @path = REVERSE(SUBSTRING(REVERSE([path]),

CHARINDEX('\', REVERSE([path])), 260)) + N'log.trc'

FROM...

+10

How beefy is the test server? Different hardware, different resources, different results.

frog legs

Like Craig said, I would stop using a DTS package to perform the backups.

Here is another thread with the same issue

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/39621314-dec7-42aa-9e30-e62ea058947d

This looks to be a stored procedure that you have downloaded or written. Are you trying to run it from the correct database?

Does the procedure exist in the database...

Sans Crainte

I know this is an old thread, but since it was reactivated today, I suggest that the code being used for checkdb be updated to also include running checkdb against...

sqlfriends (1/23/2013)

---

thanks, I do them, but here we are talking about model database only and the transaction log issue.

I guess I will just do the fullbackup, and monitor it, if...

thanks for the question.

fearsome