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...

I agree with the SP_OAxxx procs instead of an extended stored proc. MS says only C, but be wary of registering extended stored procedures. This is a great way to...

Bruce,

192.168.x.x addresses are private addresses. As such, they are non-routable across the Internet.

What usually happens is the router or firewall performs a process called NAT (or PAT) which translates the...

I don't see this option. Is this in SQL 7 or 2000?

Steve Jones

steve@dkranch.net