will this work for 2 NIC configuration?  One Public and one heartbeat?  I am attempting to move all replication traffic to the Heartbeat NIC which happens to be on a...

The best thing I like about the new "sample" databases is the inclusion of actual tools. The ETL package designed to take OLTP to the DW database is not...

13.00.3000.0

There is an option in Windows Update to include "other Microsoft products", which will prompt you to accept license and update the WSUS control on the server.

after this,...

Thank you sir! Granting EXECUTE on the schema worked perfectly (not a big fan of triggers).

AND it seems to inherit

Thank you!

I'm not sure what changed or HOW it changed, or why a particular setting that is dubbed "The setting has no effect." worked, but it did.

Cool! Can't wait for the next version!

I would actually like to see the option to have this information saved to a AdminDB table.

Once again, you hit the ball out of the park!

Thanks!

one more question, please sir.

if I wanted to build the results of TableB into a table variable to record for audit purposes, i.e. what I am deleting.

I would build the...

THANK YOU! Worked Like a charm! I couldn't figure out the alias for Table A and how to join it to table B.

Thank you again!

and where is the best place to get the most current script?

I am having issues running this script against a SQL 2005 box (9.0.5000). I keep getting these errors

Msg 2715, Level 16, State 3, Line 280

Column, parameter, or variable #1:...

Would it be possible to run this script from a "central server" and using Linked Servers collect data from remote servers?

I understand that SQL will take all that she can from OS on memory, so what is an acceptable "range" of memory to designate to SQL. i would assume...