No, that's the link to the twitter article. The article that went missing/broken is "StreamInsight - The Development Models" which was URL http://www.sqlservercentral.com/articles/StreamInsight/70160/ which was...

Broken again and link has been removed from the summary article. Guess it's gone for good. 🙁

Yes, I've tried it in multiple browsers. I am logged in (top left corner says Welcome, Anthony Young-######). When I hit that url it takes me to

In SQL Server Management Studio, connect to the SQL Server 2005 instance in the object explorer on the left. Expand the server, right click on the database that contains...

Cheryl,

There are a few possibilities that come to mind:

1. You forgot to change the connection string on the ASP page to point at the new SQL 2005 server so it...

jyuan,

Yes, on 2000 / 2005 databases the script above would be for cycling a log if it was over 14 days OR if it is over 1MB in size (LogFileSizeBytes...

Wow, jyuan, I don't know. I must have written the script while sleep-deprived. Should be 0. Good catch...now I have to go fix the job on all my...

The "2000(+)" portion of the script will work for 2000 (8) or 2005 (9).

Rather than just cycle the error log on a fixed timed interval, I setup a job on each server that conditionally cycles the error log based upon age and/or size....

--to find objects (procedures, etc) which reference your procedure:

select sysobjects.name

from sysobjects

inner join syscomments on sysobjects.id = syscomments.id

where syscomments.text like '%mysp_name%'

--to find sql agent jobs which reference your...

Mangus,

Thanks for your response. Earlier this week I opened a support case with Microsoft. What they ended up having me do was

1. restore the database to the...