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

VB is fine, but then you can't bring it back to the designer. This is fine if your people know VB.

Steve Jones

steve@dkranch.net

Interesting. Never had anyone yell at me like that, but I'm 6', 200, so that may be part of it.

I got offered both jobs, took the first at the time....

If you add the second address to the NIC in NT, then you need to reboot the box and SQL should listen on all NICs/addresses.

I have multi=homed boxes and this...

I have a "trim BAckup files" script on this site the you may be able to adapt. You would need to add a connector to the SQL Server to get...

Don't have any v7 servers here. Try running profiler with the sa logon and see what happens.

Steve Jones

steve@dkranch.net

Change to a real table. Make the same structure, but include a column for SPID.

At the beginning, detele from mytabel where Spid = @myspid

then insert your values with the current...