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

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

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

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

we that certainly was not obvious, but your solution was effective!

thanks!

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.

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

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

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

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

Ross.M (3/24/2014)

---

Lowell (3/24/2014)

---

...you cannot change the receipient of an email that was sent to sp_send_dbmail. it's stuck in the service broker asychronously, and processed, and i don't think there is...

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

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:

i've done a CLR which sends email, but that assumes you have the ability to install CLR assembleis on your machine; .NET has the built in classes to do that,...

ok this got interesting so i did the whole thing.

enjoy!

/*

valSkills

000010010011,8,64

0101111111,2,4,8,16,32,128

101011,4,16

10101004,16,64

*/

;WITH myStrings (val)

AS (

SELECT '00001001001' UNION ALL

SELECT '10101' UNION ALL

SELECT '1010100' UNION ALL

SELECT '010111111' )

,

FormattedStrings AS (

SELECT val,

right('0000000000000000000000000000000'...