Interesting. Have you checked SP_who2 and do you see the SQL Agent connected?

Anything in the Agent log?

It almost sounds like the Agent didn't fail over. Have you tried restarting the...

When you say secondary node, I'm not sure what you mean. In A/P, one node is live as the active node. Doesn't matter which one it is.

Did you have a...

One other note, the recovery mode is a database option, not a server option. I believe most db options are not service restarting changes. Some might take the db offline,...

Ben,

That's exactly right. We've seen this happen with web servers, with a lot of success (and other issues). We recently did it here with the need for Sharepoint, but not...

tasnim.siddiqi (7/14/2010)

---

Robust in the sense that it will be more reliable, I mean with just ascending ordered numbers the app_IDs will have a biased numbering form. I mean it is...

Service has been good and bad, in all industries for me. I think it has been bad at times when utilities become complacent. Just like government workers, they feel they...

Seth has some good ideas about where to look. This is one reason you should not use sa in your packages or connections. The pwd should be changed periodically for...

It is, unless the files get copied to a new server. New creation date. That's why I use naming conventions.

Most scripts, and the maint plans, will do this for you.

I usually say "never do x.... until you have to"

In the v6/6.5 days, temp tables where an issue. So we told all developers to "never" use temp tables.

Until we...

Couple things. Make sure SQL Agent doesn't start. That will connect and use your one connection.

You will also not want to use the Object Explorer since that takes a connection....

You are welcome and looking forward to seeing it.

First, stop saying you are starting SSMS in single user mode. You start SSMS, the mode in which SQL Server is started is irrelevant.

The error you are getting is that...

Like most anything, I think it depends. I have it in a lot of scripts to be sure that I end up in the right database.

However for things like deployment...

You can use two CTEs in a single statement

http://www.sqlservercentral.com/articles/Common+Table+Expression+%28CTE%29/62291/

It's still not clear. How does Access even come into play? If you can see the Lotus database as a connection, you connect to it in SSIS. If you cannot...