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

Can you explain a little more?

if i had THIS as a comment:

declare @text varchar(4000)

SET @text = Without a doubt SQLCentral is home to finest SQL folk[comment:#grovel].

Sometimes things may get heated[comment:#super...

for profiler, only users who have ALTER TRACE permission...

yeah, encryption can be confusing; I didn't know SSL was an added layer; so I learned something today; (as usual here on SSC) Thanks Eduard!

river by changing that flag...

SSL is an https connection for a web page, using port 443 by default. in theory, i can go to your web page via https, but your web server goes...

1.your trigger doesn't have SET NOCOUNT ON at the beginning, which is good practice and may avert other issues receiving "1 row(s) affected" and thinking it's a result set.

2.you are...

it sounds like you are developing in C# becasue of the error on the escape;, i think you need to use double slash to escape the string in that case:

Data...

river1 (2/6/2010)

---

But there is no problem with encrypting a connection because it uses SQL Server authentication instead of windowns authentication, correct?

Or i can only encrypt connection if they use windows...