There are always fixes in progress and hotfixes appear occassionaly, but I have found that by calling support, I sometimes get "unreleased" hot fixes. Usually these are later included in...

Your welcome. Glad we could help.

Steve Jones

steve@dkranch.net

Thanks for the update and pleasae let us know.

Steve Jones

steve@dkranch.net

I like the time bomb.

Be sure you disclose some of this in your contract so your client is aware he cannot stop you from accessing the site. Just let him...

Anytime is fine. We check these forums most eveery day.

Steve Jones

steve@dkranch.net

Haven't tried it, but I'll see if I can Thur or Fri.

Steve Jones

steve@dkranch.net

Good job Brian. A great topic and definitely place for a Part II!!!

Steve Jones

steve@dkranch.net

Yikes!!!!

this is scary to even contemplate as a developer unless the client is someone your trust.

Some thoughts:

1) Convert ASP application into a DLL so that my source code remains safe(Helps...

What would that do in a clustered scneario? Probably still work.

In that scenario, if you have SQL 2000, you might even want to investigate a 3 or 4 server cluster....

No good way natively. Check out the product from RedGate (ad at the bottom of the page). This is exactly what that product will do.

Steve Jones

steve@dkranch.net

It seems like you are trying to do two things. If you want to load balance, then you would do that by directing some queries to one server instead of...

So I assume that msdb is included and SQL Agent is picked up by the second server?

Is this correct? Brian? Anyone tested it?

Steve Jones

steve@dkranch.net

You sure you didn't eat any wild mushrooms instead?

Steve Jones

steve@dkranch.net

In native mode this is probably true (Andy?).

This does, though, meet the division of roles. You should create the roles and hopefully they map to the network groups. If not,...

switch to master in Query Analyzer. Your QA connection is a connection (and lock) in the db.

Steve Jones

steve@dkranch.net