Hi. I ended up assigning Content Manager + Publisher roles to users within specific AD groups.

Phil.

Hi, you were quite right however name '0AF393F7-24CA-4729-9EB0-DA13AB31CB33' means as little as Job_Id 🙂

I hoped to return the report Name that created the Job_Id.

Thanks,

Phil.

Hi. I disbaled the jobs on the new server until i flick the switch.

The following code returns blanks for all jobs I tried

SELECT [Name] FROM MSDB.DBO.SysJobs WHERE Job_Id = '0AF393F7-24CA-4729-9EB0-DA13AB31CB33'

Result:

Name

Blank

Thanks,

Phil.

Thanks,

Phil.

Thanks to all who have taken time to post. RAID 1 it is then.

Kind Regards,

phil.

That's microsoft for you......... 🙂

Thanks,

Phil.

Hi. Yes I plan to test prior to move.

Thanks,

Phil.

I followed the following article: http://msdn.microsoft.com/en-us/library/dd758814.aspx

Hope this helps others.

Phil.

Thanks for the links, I will take a look. Great response time (unlike the application 🙂 )

Phil.

Thanks.

Phil.

Thanks guys. I enabled remote logging and indeed it was due to the row limitation in excel 2003. Are you suggesting as a work around I can export to .csv,...

Hi Phil, yes SSIS (apologies).

SQL Log:

Date10/03/2011 22:15:00

LogJob History (Purchasing Supplier Email)

Step ID1

ServerSQL1

Job NamePurchasing Supplier Email

Step NameExecute ssis Package

Duration00:00:02

Sql Severity0

Sql Message ID0

Operator Emailed

Operator Net sent

Operator Paged

Retries Attempted0

Message

Executed as user: Domain\Account....

It transpires the report has the following code:

public function DecodeXML(byval rootNode as string,byval myXML as string) as string

try

Dim str As New System.IO.StringReader(myXML)

Dim r As System.Xml.XmlReader = System.Xml.XmlReader.Create(str)

r.Read()

r.ReadToFollowing(rootNode)

r = r.ReadSubTree

r.Read()

dim decoded...

Hi. I now have a report. Datset as follows:

DECLARE @idoc int

DECLARE @AuditXML nvarchar(max)

DECLARE @PrimaryTableName NVARCHAR(25)

SET @PrimaryTableName = 'Customers'

DECLARE @Identifier int

SET @Identifier = 70798

DECLARE @TextId NVARCHAR(20)

SET @TextId = 'C00237'

SELECT Audit,

CASE...

Back again. How can I query column 'AuditXML' to list individual element values (i.e. extract CreatedUser, LastModifiedUser). The column data type is nvarchar (max)?

<Audit><PrimaryTable xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><Customer>70798</Customer><CustomerId>C00237</CustomerId><Branch>0000</Branch><CustomerName>SQL Central</CustomerName><Address>In the Cloud</Address><City>City</City><Region></Region><PostalCode></PostalCode><Country>229</Country><PhoneNumber>0012586525</PhoneNumber><FaxNumber></FaxNumber><EmailAddress>info@sqlcentral.com</EmailAddress><WebSite>http://www.sqlservercentral.com/</WebSite><Industry>216</Industry><Currency>292</Currency><GLAccountDivision>2</GLAccountDivision><Department>25</Department><TaxCode>23</TaxCode><TaxNumber></TaxNumber><Bank>148</Bank><CreditTerms>332</CreditTerms><Discount>408</Discount><CreditLimit xsi:nil="true"/><GLAccountType>2718</GLAccountType><PriceList...