I've experienced the timeout error when SQL Server is down or I VPN from home using a different domain. Some containers fail from being unable to obtain a lock.

Try using...

First, when a cluster instance is started, you can check if the active node has changed. The active node name is captured in the [SQL_Overview].[dbo].[SQL_Servers] table. You can add a...

Good Article it presented an often-missed backup option that I was unaware off and will now remember in the future.

Based on the article contents, follow up discussion, and books...

The domain must be accessible from the server running the package. A trust must be establish between domains. When accessing servers in another domain, I use the full name of...

The article SQL Overview IV - DBA's Morning Review[/url] includes a variety of reports that can be scheduledeach morning. One report 'Error Log Messages Report" specifically addresses reporting only errors...

My mistake, I missed the note in the newsletter that they will be available through live meeting

Are these presentations going to be broadcast over the internet?

Remove the duplicate drives by deleting them from the table Disk_Space.

You can use the drives letters identified in the Database_info column Filename to identify which drives to keep for...

Your question got my mind of thinking. I have tested the script on a Lab server to verify it would not blow up. Currently, we do not have any multiple...

Good idea. I have noticed clustered servers are more sensitive than non-cluster servers. They automatically restart services by failing over whenever something seems to be wrong. I think of it...

The SQL Agent is running the package as 'FNBN\OTGDEV04$'

This is a local server id which I will assume does not have access to the instance you are trying to connect...

I was successful in using SQL Server 2008 "SQL Server Business Intelligence Development Studio" to open the SQL 2005 solution/package and migrating it to SQL Server 2008.

I got some...

Finally got the DVD's for SQL Server 2008 a month ago and installed it on a LAB Server.

We are still pushing applications to migrate to SQL Server 2005 which is...

Nice list of tools. I plan to look into the synergy software.

While I do use Firefox, Internet Explorer is the companies preferred browser, and I also like using Opera/Chrome...

It seems SP3 is missing the last two cumulative updates.

Take a look at this SQL Server Magazine article for the full story http://www.sqlmag.com/Articles/ArticleID/101085/101085.html

I plan to wait for SP3 cumulative update...