by joe.pesch
16. September 2015 05:17
1) Open a cmd prompt.
2) Enter telnet <the FQDN of your SMTP server> <the port number>

3) Enter EHLO <the DNS domain name where the SMTP server is at>

If you get a successful connection you will see this:

4) Enter MAIL FROM: <the email address of the Workflow Run As Account>

5) Enter RCPT TO: <some email address you want to send to>

6) Enter DATA

7) Enter SUBJECT: <some subject you want to have> and hit Enter TWO times:

8) Enter a message body followed by Enter, then a period, then Enter again.

9: Enter QUIT
2e93ff03-0086-4530-9627-9a35dcab4ddd|0|.0|96d5b379-7e1d-4dac-a6ba-1e50db561b04
Tags:
Windows
by joe.pesch
8. September 2015 04:38
This script will generate a set of drop statements:
--tables
select 'EXEC sp_dropextendedproperty
@name = '''+name+'''
,@level0type = ''schema''
,@level0name = ' + object_schema_name(extended_properties.major_id) + '
,@level1type = ''table''
,@level1name = ' + object_name(extended_properties.major_id)
from sys.extended_properties
where extended_properties.class_desc = 'OBJECT_OR_COLUMN'
and extended_properties.minor_id = 0
union
--columns
select 'EXEC sp_dropextendedproperty
@name = '''+sys.extended_properties.name+'''
,@level0type = ''schema''
,@level0name = ' + object_schema_name(extended_properties.major_id) + '
,@level1type = ''table''
,@level1name = ' + object_name(extended_properties.major_id) + '
,@level2type = ''column''
,@level2name = ' + columns.name
from sys.extended_properties
join sys.columns
on columns.object_id = extended_properties.major_id
and columns.column_id = extended_properties.minor_id
where extended_properties.class_desc = 'OBJECT_OR_COLUMN'
and extended_properties.minor_id > 0
16a67bd2-4fee-4c7c-b72b-5cf058b73161|0|.0|96d5b379-7e1d-4dac-a6ba-1e50db561b04
Tags:
SQL Server