mwstewart did you find out what the problem was? are there any triggers, or did you find something else?

Andrew I'm second guessing the purpose of the function....

is it just getting the # rows for a given table? is it being called 1000 times, one for each table?

if that...

nevermind.

my error was this:

set @options = 0

the allowed values for @options is 2 in my case.

my pleasure and thank you very much for the complement!

your question was missing a lot of things that we'd need to join your two tables together, ket alone insert into one of them.

give us some more details: the CREATE...

MJ I'm not sure on the whole sp_oa option, but if you create linked servers to each of your networked SQL servers, you can query them with an OPENQUERY command;...

well, you've got a logical error first:

dates should not be varchars...use datetime datatypes.

CREATE TABLE Table1

(ID int,

Enter datetime)

second, if you want a specific format, validating it to be a...

are there any triggers on the tables? it could be that you enter data into an application like your new customer account, and when it updates, the trigger fails and...

OK here's my prototype for scripting out the traces;

I created a procedure where you have to pass the trace id, and it seems to script everything out .

note this assumes...

Craig thank you! that was the piece could not find;

i was locked into looking for a sys view that had the joining information...with what you posted I could get the...

for me, reverse engineering is to be able to script out any and all traces that exist on the server;

the whole script like this:

--create the trace

exec sp_trace_create...

those "Urgent" posts are like a train wreck or nasty...

you guys have show some great examples of using a future backup to fix todays data, but I've got a question along a similar vein:

somehow I've forgotten to create any...

isn't the REPLACE function overloaded, so there are actually multiple "replace" functions that are used based on the parameters passed?

I'm sure the same thing was discussed on the COALESCE...

you replied while i was editing my original post;

here's one way; i'm testing a Tally solution now:

here's a simple way using a WHILE Loop:

--===== Replace all [' and ']' pairs...