Pete there is a difference between Joining and using a WHERE statement to limit your results; I'm thinking that you are including the WHERE statement as part of the join,...

As Jeff's link pointed out, you can easily script the enabling and disabling of xp_cmdshell;

if you had checked BOL before posting a question here, you'd have found it yourself, and...

good job posting details Bryan! that gives us just what we need for testing.

with the table definitions, we can emulate what you are doing, and provide solid comprehensive answers.

now we...

details, that's the key.

you said you want to put XML in the following folder:

c:\AllSites\romah.com\ folder of target

does that mean the web server and the sql server are the same...

if you are getting a specific error, we really need to see the code in your triggers; that's where the error lies; it sounds like you have declared variables in...

still fairly easy: you jsut add the dependancies and the columns to teh same query:

SELECT

CASE

WHEN object_name(tr.parent_id) IS NULL Then 'Database'

...

here's an example of what Jason was talking about; my SandBox database had a database trigger, and I thought that deserved mentioning and a demo of special handling:

SELECT

...

the best way is to switch to your own cursor, and do whatever you were going to do to the specific tables;

here's a generic example; note how you could exclude...

DR = Disaster Recovery.

a SQL disaster Recovery Regime would simply be the steps you plan to take to bring SQL server back up in the event of a disaster...whether that...

yes! that is the "tipping point" Jeff was referring to; most huge updates take seconds/under a minute total, isntead of hours.

after your update, have you done a select to...

i agree with Bru; i don't think you can change column names via replication.

an alternative might be to create a view that aliases the column names, but if these are...

not that a million records a day is a lot, but here's a question for you:

are the million records at a time date related? ie since you are doing this...

the error pretty much tells you what the issue is.

when you do a CREATE TABLE statment, you can optionally say what filegroup it will be created on...the "default" group is...

i'd say there was an error in assigning roles;

how can you update something(db_datawriter) if you can never query it for the original values(db_datareader)

i think you need to add db_datareader to...

here's my guess at it:

DECLARE @pid int

--don't see it assigned a value..this might be a select for ALL recs, and pid is the current record?

SELECT ISNULL(CustName,'') As CustName,

ISNULL(CustAddress,'') As CustAddress

FROM...