could grant execute on sp_start_job only to the account in question, then pass it the job_id

maybe this will help

http://msdn.microsoft.com/en-us/library/ms177410.aspx

SELECT

ID, Name, [English] AS English, [Math] AS Math, [Hindi] AS Hindi, [Marathi] AS Marathi

FROM

@TMP

PIVOT

(max(marks) for subjectname

IN ([english],[math],[hindi],[marathi])) as p

Will give results like this

IDNameEnglishMathHindiMarathi

1A808090NULL

2B801009080

this works for me,

create table #dates1 (Date1 DATETIME)

create table #dates2 (Date2 DATETIME)

insert into #dates1 values ('2011-05-05 08:00:00.000')

insert into #dates2 values ('2011-05-05 08:00:00.000')

insert into #dates2 values ('2011-05-05 08:12:14.000')

select

d1.*,

d2.*

from

#dates1 d1

inner join

#dates2...

please dont quote me on this as i'm not the best person on dos, but I think you will need to get the script to fail as the script will...

this link may help

http://blogs.msdn.com/b/joaol/archive/2010/01/05/sql-server-2005-patch-fails-to-install-with-an-error-unable-to-install-windows-installer-msp-file.aspx

can you explain which part is not working?

currently trying to find a licensing document where I believe that SQL, AS, RS, IS are the licensed parts of SQL, so you cannot install SSIS on client machines unless...

No I haven't

Also you have posted a 2005 question in the 2008 area.

You might get better help if you ask in the SQL 2005 area.

Have you looked through the log...

I know in McAfee you have to disable the mass mail worm in order to get it to send emails

If McAfee is controlled by an ePO server, get your ePO...

I think the way to do this would be to create a 32 bit DSN and then use a linked server to do the export, as I know 64 bit...

put sp_addmessage into BOL, google etc which will give you the syntax

then create a message which has meaning to you

You can create a job via the central management server across all servers which are members of the CMS, but you need to do it in T-SQL, you cant use...

CREATE TRIGGER [DatabaseChangeTrigger] ON ALL SERVER

FOR DDL_EVENTS

AS

BEGIN

DECLARE @data XML;

DECLARE @schema SYSNAME;

DECLARE @object SYSNAME;

DECLARE @eventType SYSNAME;

DECLARE @user SYSNAME;

DECLARE @mess NVARCHAR(MAX);

DECLARE @dbname SYSNAME;

SET @user = SUSER_NAME()

SET @data = EVENTDATA();

SET @eventType =...

are all the health checks different for each server?

if they are then it would be a case of creating the individual jobs on each server

if not you could look at...

please post the DDL and sample data of the objects in the problem