Just throwing this out there:

I've used xmind for documentation and to help me flesh out a process tree;

it's free and easy to use after you learn a few keyboard shortcuts.

it's...

there's a good chance the free SQL Express Edition may suite your needs.

the caveat there is you don't get any of the powerful business tools like SSIS, The ability to...

not sure what exactly you are looking for. it kind of looks like you wnat to test if a table exists?

this code example works, but might not be what you...

lol thanks everyone; every...

a Row has more than one column...if you mean searching all the char/varchar/nchar columns in a given table, the recommended...

constant strings have to be quoted out i think,

so I'm fairly sure this is the right syntax:

$BackupFiles=get-childItem -name -include "*_"+$NumberOfWeek+"_*"

i prefer the extended properties, because they stay with the database they are describing;

that's really the purpose of the extended properties anyway;

it also makes it a lot easier for any...

you are correct; dynamic SQL is not allowed in a UDF, dynamic SQL limits you to either a procedure or ad-hoc code that will need to be built and executed...

a person with db_owner permissions has the ability to backup, restore, or even drop their own database, i believe.

that's very easy to test.

well it sounds like there is a few things going wrong here; is this a CLR trigger or a regular TSQL trigger? a TSQL trigger should not be going to...

welsh can you go to one of your servers you know you already set up and is working, and use my script to reverse engineer database mail settings?

then you can...

i think if you look at the profile, the checkbox for "This server requires a secure connection(SSL) is checked.

the error message says the mail server doesn't support SSL for that...

ok based on your table scheme you posted, this correctly builds a string and prints it, listing only columns that CHANGED, along with some hopefully helpful audit information.

I'll leave it...

ok, one of the things you'll run into first is permissions to send mail inside the trigger.

EVERY user that can access the table will need to a user in the...

how many columns are"critical" that you have to track for changes in the table to be emailed?

It would be pretty easy to modify my example, but i'd like to see...