Viewing 15 posts - 11,371 through 11,385 (of 13,469 total)
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...
March 26, 2009 at 6:30 am
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...
March 25, 2009 at 6:03 pm
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?
March 25, 2009 at 6:00 pm
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...
March 25, 2009 at 5:56 pm
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...
March 25, 2009 at 1:43 pm
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...
March 25, 2009 at 1:19 pm
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,...
March 25, 2009 at 12:11 pm
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...
March 25, 2009 at 12:04 pm
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
...
March 25, 2009 at 11:57 am
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?...
March 25, 2009 at 11:12 am
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 ...
March 25, 2009 at 10:43 am
could there be a trigger on the destination table that is causing the issue?
March 25, 2009 at 8:35 am
double post.
follow the suggested solutions hee to avoid disjointed answers:
http://www.sqlservercentral.com/Forums/Topic683311-266-1.aspx
March 25, 2009 at 8:22 am
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...
March 25, 2009 at 8:11 am
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...
March 25, 2009 at 8:06 am
Viewing 15 posts - 11,371 through 11,385 (of 13,469 total)