Forum Replies Created

Viewing 15 posts - 106 through 120 (of 541 total)

  • RE: Allow Users to Configure Email on Report Subscription

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

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    May 18, 2012 at 9:19 am

    #1489766

  • RE: Identify SQL Job 'Friendly Name'

    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.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 16, 2011 at 6:55 am

    #1422477

  • RE: Identify SQL Job 'Friendly Name'

    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.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 16, 2011 at 5:31 am

    #1422414

  • RE: tempdb file placement

    Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 13, 2011 at 12:59 pm

    #1420841

  • RE: tempdb file placement

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

    Kind Regards,

    phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 12, 2011 at 7:38 am

    #1420079

  • RE: Virtualise SQL 2005

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

    Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 7, 2011 at 3:38 am

    #1417917

  • RE: Patch SQL 2005 - SP4?

    Hi. Yes I plan to test prior to move.

    Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 6, 2011 at 6:19 am

    #1417303

  • RE: Virtualise SQL 2005

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

    Hope this helps others.

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 6, 2011 at 4:03 am

    #1417198

  • RE: Where to start - Identify Performance Issue

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

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    November 21, 2011 at 9:39 am

    #1410852

  • RE: Report fails to export to excel

    Thanks.

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    September 30, 2011 at 9:53 am

    #1388920

  • RE: Report fails to export to excel

    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,...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    September 30, 2011 at 9:20 am

    #1388900

  • RE: DTS task returns failure on no records

    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....

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    March 11, 2011 at 3:30 am

    #1297506

  • RE: Query that returns change details

    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...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    February 22, 2011 at 9:33 am

    #1289919

  • RE: Query that returns change details

    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...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    February 21, 2011 at 8:12 am

    #1289440

  • RE: Query that returns change details

    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...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    February 18, 2011 at 3:41 pm

    #1289105

Viewing 15 posts - 106 through 120 (of 541 total)