What build are you running?

Interesting.....have you confirmed that database mail is working in your env? Can you send a test message?

Why not just use sp_send_dbmail? You can use HTML, see BOL

http://msdn2.microsoft.com/en-us/library/ms190307.aspx

I suppose you could always contact the third-party for more information:

http://www.thorpesoftware.com/%5B/url%5D

Try -

DECLARE @SQL nvarchar(MAX)

SET @SQL = 'select top 1* from sys.tables'

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'DBMail',

@recipients = 'thomas_bollhofer@symantec.com',

@body = 'Test',

@query = @SQL ,

@subject = 'DB Mail Test',

@attach_query_result_as_file = 1;

You would trust the server SSIS is running on for delegation. Review the article in the previous post, there are several steps you will need to take to ensure Kerberos...

Does this account also have access to the database server? Is Kerberos working? Have you enabled the SSIS server for delegation?

http://support.microsoft.com/kb/319723

What account is SSIS running under?

Also worth a look is RedGate's SQL Doc (http://www.red-gate.com/products/SQL_Doc/index.htm)

😉

Try

CREATE TRIGGER TR_SP_CONVENTIONS

ON DATABASE

FOR CREATE_PROCEDURE, ALTER_PROCEDURE

AS

declare @data XML

declare @new_schema_name nvarchar(250)

declare @new_obj_name nvarchar(250)

set @data = EVENTDATA()

select @new_schema_name = @data.value('(/EVENT_INSTANCE/SchemaName)[1]', 'nvarchar(250)')

select @new_obj_name = @data.value('(/EVENT_INSTANCE/ObjectName)[1]', 'nvarchar(250)')

declare @sql1 nvarchar(max)

set...

Until it becomes full, it will autogrow by 10%. In this case 10% of 1.5GB. I would avoid this if possible (hinders performance), forecast your space requirements and allocate the...

Sure it is 🙂

1) Create a new Database role for your users, for example 'PowerUsers'

2) Create a trigger to grant EXEC and VIEW DEFINITION for your new procedures.

CREATE TRIGGER...

Run -

DBCC UPDATEUSAGE ('MyDatabase') WITH NO_INFOMSGS

go

No to the first, Yes to the SSIS (Just FYI, w/ SP2 you don't need to install SSIS for maintenance plans).

Correct 🙂 Client components will have to be patched individually.

NP 😀