Viewing 4 posts - 16 through 19 (of 19 total)
Ali_SQLDBA (1/6/2010)
My cluster is a AA cluster. So, I need to install on both nodes then. correct?
Well, I don't like to open a can of worms, but there is no...
January 7, 2010 at 3:13 pm
CREATE PROCEDURE [dbo].[TestSendMail]
.....
WITH EXECUTE AS <account with rights to send e-mails>
Wouldn't it be easier that way?
December 17, 2009 at 4:10 pm
I do agree the msdb.sys.syslogins shouldn't be used.
Another way is to use the SUSER_SID function:
SQL 2005 Maintenance Plans
UPDATE
[msdb].[dbo].[sysdtspackages90]
SET
[ownersid] = SUSER_SID('sa')
SQL 2008 Maintenance Plans
UPDATE
[msdb].[dbo].[sysssispackages]
SET
[ownersid] = SUSER_SID('sa')
November 19, 2009 at 4:18 pm
It doesn't work -
Msg 102, Level 15, State 1, Line 10
Incorrect syntax near '?'.
on spt_values.number = 1 and spt_values.type = 'E'
May 4, 2009 at 8:58 pm
Viewing 4 posts - 16 through 19 (of 19 total)