Forum Replies Created

Viewing 15 posts - 481 through 495 (of 1,583 total)

  • RE: Replication?

    Agreed, they are still delivered to the distributor (my bad for not clarifying that in my statement). What I meant to say was depending on the potential error at...

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: Not getting full results in email

    Is there any chance you are using a variable within SSIS and it's value is set smaller?

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: Reset password for user with no login?

    I would drop/create them with new passwords

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: Replication?

    MysteryJimbo (2/18/2014)


    schleep (2/18/2014)


    And on their wildest-dreams wishlist, they could schedule changes going to the destination days in advance.

    As mentioned, merge replication can use dynamic dates to publish so this is...

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: Linked server query issues?

    Please post your error log, I have no intention of opening a compressed file at the office but am curious to see it

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: Just one row for each patientid 2

    MyDoggieJessie (2/15/2014)


    If you want only 1 record, you will need to remove the LedgerType (otherwise you will get a SUM for each record by Ledger Type)

    I believe that's...

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: Customizing Rendering Extension Parameters in RSReportServer.Config - DAT/CSV(|)

    I believe the issue is with the "WordRendering" - can you try this?

    <Extension Name="TXT" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">

    <Configuration>

    <DeviceInfo>

    <NoHeader>True</NoHeader>

    <FileExtension>txt</FileExtension>

    <ExcelMode>true</ExcelMode>

    <SuppressLineBreaks>false</SuppressLineBreaks>

    <Qualifier></Qualifier>

    </DeviceInfo>

    </Configuration>

    <OverrideNames>

    <Name Language="en-US">TXT</Name>

    </OverrideNames>

    </Extension>

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: E-Mail notifications occurring on success despite configuration in job

    Please post your TSQL generating the alerts...

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: result set > just one row for each patientid

    mattech06 (2/15/2014)


    I'll start a new post for this which has my tables and data in called 'just on row for each patientid 2'

    Please see your other post: http://www.sqlservercentral.com/Forums/Topic1541840-391-1.aspx

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: Just one row for each patientid 2

    If you want only 1 record, you will need to remove the LedgerType (otherwise you will get a SUM for each record by Ledger Type) so you could try SELECT...

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: How to check that Reporting Services is working

    If it works for you, please mark it as helpful so others will know to use it - have a GREAT WEEKEND!!!!! 🙂

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: Why does SSIS take so long to "build" before running?

    I have no doubt that the network location is the issue. If you copy it locally and run it I would bet a round of beers that the issue goes...

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: SSMS became the default program for .txt files and I cannot change the behavior

    Check out this link, if you scroll down a bit there is a mention of a workaround

    http://answers.microsoft.com/en-us/office/forum/office_2003-onenote/in-my-open-with-window-the-always-use-the-selected/11efd932-1f48-45cd-83fa-9f5da0da7025

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: Why does SSIS take so long to "build" before running?

    This is a pretty old post, but the root cause of my issue was that I was opening the project from a Network location. Once I moved it locally...

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: Moving Standby/Readonly DB to New server

    Agree with everyone is saying about the standby...seems like we're missing something.

    To answer your question, simple take a full backup on the current server, then restore it to the new...

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

Viewing 15 posts - 481 through 495 (of 1,583 total)