unless you have a trace already set up and running, you cannot find out who deleted data, and aside from that, will most likely NOT be able to recover data...

well, if you run the script below, it will read the registry and tell you teh listening port...

i duoubt this will work over a linked server, which is what i...

a bit xolumn is still an integer value...it's just limited to 0 or 1.

does that help? i assume your excel file has that value in one of the columns?

Florian, i used a smtp dll...not the built in. nowadays program that runs the job handleds it , but i've done it all in SQL as well.

so i might...

force of habit for me snuck into the code;

SET DATEFIRST allows you to decide what day of the week is your "start of the week"; when you are fiddling with...

yes exactly just a scheduled job for a stored proc that ran every minute....it looped thru every row in the table where a flag SentSuccessfully = 0; it was nothing...

ok two steps, here's how I find "this weeks" monday and friday:

SET DATEFIRST 1

SELECT

DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0) Monday,

DATEADD(wk,...

Florian i recently found out that the procedure sp_send_dbmail is asychronous, so it does not wait for the preocdure to execute before returning control tot eh calling procedure;

in 2000, i...

adding a WHERE clause to check if any of the columns changed might be beneficial, but it's going to do a table scan regardless. like

WHERE A.Col1 <> B.Col1

...

remember that the moment you disconnect, your #tmp table will be DELETED;

it lasts only as long as your session...so you are creating a permenant table on the same database, right?...

Stamey is right;

sql server does not keep track of queries that were executed, or when a view/function/procedure was last used. You HAVE to have a trace running ...

could there be a trigger on the destination table that is causing the issue?

double post.

follow the suggested solutions hee to avoid disjointed answers:

http://www.sqlservercentral.com/Forums/Topic683311-266-1.aspx

sure, but what is "special characters" for you?

anything not a space and alphanumeric, for example? or are you after specific chars, like hi ascii characters?

here's a simple example

select * from...

of course...but it depends on what are "special characters" for you;

do you mean where any character is not alphanumeric(or space) like this?

select * from gmact where actname like '%[^a-z,A-Z,0-9 ]%'

or...