Viewing 15 posts - 2,416 through 2,430 (of 13,469 total)
since you are taking about VIEWS breaking, that really has nothing to do with a trace, right? it really has to do with source code of views/procs/etc
i typically refresh every...
March 27, 2014 at 2:33 pm
I'd seen several similar posts on finding index creation date.
i'm very sure that there is no creation date exposed anywhere for indexes; objects in sys.objects have the create_date and modify_date,...
March 27, 2014 at 8:37 am
ok i did a little bit more: i'm joining against all databases, so i can find things that were never accessed; on my test server i see a lot of...
March 27, 2014 at 6:13 am
Aaron Bertrand has a post on last accessed tracking with a couple of different ways, as well as having posted a script that i've modified in the past a tiny...
March 27, 2014 at 5:53 am
here's a rough example of a logon trigger;
like Lynn said, you can easily lock everyone out, including yourself, with a badly written trigger, so don't disconnect the SSMS query window...
March 24, 2014 at 1:00 pm
excellent question Jeff;
here's the reason, specifically:
Redgate SQL Backup v7.6 is not deleting backups the way i expect it to, and i'm running grievously short on disk space.
I'm setting the job...
March 24, 2014 at 12:45 pm
we that certainly was not obvious, but your solution was effective!
thanks!
March 24, 2014 at 10:33 am
Like Phil said, a real text editor; NotePad++,EditPlus,UltraEdit,GVim to name a few off the top of my head.
Wordpad if you don't have anything installed already would do in a pinch.
March 24, 2014 at 10:10 am
it's just convenience vs completeness; ideally, you want explicitly named constraints eveywhere, but if it's not important to your schema organization, then you can allow SQL server to create names...
March 24, 2014 at 10:08 am
csv is just a raw text format, so there is no limit;
however most peoples default viewer for csv files is Excel; that certainly is handicapped at just over a million...
March 24, 2014 at 10:02 am
assuming you run a job on the same day once a month, cna't you simply get anything created or modified in -1 months?
select * from master.sys.database_principals
WHERE create_date > dateadd(m,-1,getdate())
or modify_date...
March 24, 2014 at 8:27 am
i am sure that everything revolves around sp_send-dbmail; nothing else does the same work via a different name, but certainly jobs and procs could exist, but they all call that...
March 24, 2014 at 8:04 am
Ross.M (3/24/2014)
Lowell (3/24/2014)
March 24, 2014 at 7:24 am
Ross i misread your requirement, and picked up where you said "is there any otherway to send email."
AFAIK you cannot change the receipient of an email that was sent to...
March 24, 2014 at 6:48 am
you can't use anonymous authentication, sounds like you left the SMTP authentication section blank.
587 is for non-SSL i thought.
it should look like this:

March 24, 2014 at 5:46 am
Viewing 15 posts - 2,416 through 2,430 (of 13,469 total)