Forum Replies Created

Viewing 15 posts - 661 through 675 (of 1,079 total)

  • RE: Result Set

    lax.rawat07 (11/10/2010)


    i have a result set

    LedgerId, ProfitAndLoss

    46 -3000.00

    49 -7000.00

    45 ...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Named SQL Server Instance

    Jeetendra (11/10/2010)


    Hi,

    We have a Default SQL Server 2005 & several other named SQL Server Instances on the same box.

    Now One of the application requires us to configure the SQL Named...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Active/Active Cluster Installation

    Microsoft Active/Active is purely 2 nodes acting as Active nodes and using each other as failover.

    You will host different databases on each node.

    Not the same as Oracle Active/Active...

    make sense?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Delete old backups from backup device

    add a cleanup task and define your retention period.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Sql Connection

    Tarun Jaggi (11/9/2010)


    Thanks!!

    Yes I am refering to connectionstring of .NET. Can you please give some sample code?

    http://lmgtfy.com/?q=.Net+to+SQL+connection+strings

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Getting Time gap in day

    select DATEDIFF(hour,'2010-10-08 23:59:59','2010-10-09 03:00:00')

    ??

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: OLE DB provider 'MSOLAP' reported an error

    Fair enough, but you only mention

    OLAP Services is using SQL Server Login same with Analysis Services and SQL Server. These two servers are also on the same domain.

    ...

    confirm if...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: OLE DB provider 'MSOLAP' reported an error

    Obviously, the error states the OLAP database does not exist eventhough it exists. Using "sa" login to execute the above script I do not encounter any error.

    check the account permissions...?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Order by is to slow in a query

    Get your application Vendor to provide support on their tables.

    Vendors usually provide scripts to modify their own tables and structures, they should be able to assist.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Order by is to slow in a query

    do you have any indexes on ams_fin_link??

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Attachment file is Invalid

    Map \\Sasi as a drive letter and use it as N'f:\Testing.txt', F being the drive letter or whatever you assigned.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Order by is to slow in a query

    Do you have any indexes on order by c.CATEGORY_NAME ?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: SSIS 2008

    me.nitin.sethi (11/8/2010)


    OK Can u please help me with a step chart to get away with this problem please would be a great help .....

    http://tinyurl.com/3xazmvy

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: SSIS 2008

    me.nitin.sethi (11/8/2010)


    yes i have TEAM viewer for the same if u can cum on gtalk my ID is me.nitin.sethi@gmail.com n m online

    Sorry, I already have a permanent job, with an...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Are the posted questions getting worse?

    does this qualify?

    http://www.sqlservercentral.com/Forums/Topic1017057-391-1.aspx?Update=1

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Viewing 15 posts - 661 through 675 (of 1,079 total)