Forum Replies Created

Viewing 15 posts - 1 through 15 (of 120 total)

  • Reply To: Alias woes on SQL Server 2022

    There is going to be a number of changes in the error messages that are put out by Windows as different alements are changed .

    What I've done is  uninstall from...

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • Reply To: Alias woes on SQL Server 2022

    Thanks for your reply. The Browser Service is running on the SQL 2022 box. The cliconfg doesn't expand to provide a better view. The Server name was updated to fqdn...

    • This reply was modified 1 years, 9 months ago by MothInTheMachine. Reason: added note about the error being returned

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • Reply To: Alias woes on SQL Server 2022

    I made the changes you recommended. and get the same problem. I'm using a TCP/IP alias but do have named pipes enabled. The Registry entries on my client are both...

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • Reply To: Alias woes on SQL Server 2022

    SQL Server Configuration Manager is where Aliases have been defined, which would be on the server where SQL is installed. The use of Aliases is recommended for SharePoint which is...

    • This reply was modified 1 years, 9 months ago by MothInTheMachine. Reason: edited for clarity

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • Reply To: Alias woes on SQL Server 2022

    I've created the alias on all SharePoint Servers as well as on my laptop using clconfg in sys32 and syswow64. THe SQL Server 2022 is installed on an Azure Virtual...

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • Reply To: Grouping by hour and minute from TimeStamped data

    It's been a looooong time since I've had to ask for sql help...lol. I've added an attachement with some sample data. Sorry about that and thank you for taking a...

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • Reply To: Grouping by hour and minute from TimeStamped data

    You're right. I added the YEAR part mid post. The Start Time is a DateTime field.

    StartTimeCount StartedDay of Week
    12/14/2021 16:1030Tue
    12/14/2021 15:4016Tue
    12/14/2021 15:301Tue
    12/14/2021 15:104Tue

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • Reply To: Changing Owner NOT dbo_Owner

    Thanks, but it can't be the SA account. It needs to be a specific service account.

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • RE: What Day is this?

    All good information, and appreciated but still don't know what these digits represent.

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • RE: What Day is this?

    paging @GilaMonster

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • RE: Lookups on remote database

    frederico_fonseca - Monday, June 4, 2018 11:29 AM

    pseudo code

    read sharepoint list - load onto datatable Invoices

    using dbconnection to sqldb -- using transactionscope
    {
    ...

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • RE: Scheduled Query when DBS are continuously added

    Looks like I found a way to do this.


    Declare @dataFiles Table (databaseName Varchar(256))
    Declare @sql Nvarchar(Max), @databaseName Varchar(256)
    Set @sql = '';
    Insert  @dataFiles
    select ...

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • RE: UNION to XML throws Msg 116, Level 16, State 1

    That did it. Thanks David!

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • RE: Options to pass encrypted creds from SQL 2012 to Oracle on Unix?

    Hi Lowell. Thanks for your reply. My hunch is there is no automagic encryption that SQL and Oracle share. One solution I had considered was like your. A SSIS dumps...

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • RE: Options to pass encrypted creds from SQL 2012 to Oracle on Unix?

    Lots of looks on this one. Is this really so rare a scenario? A windows based SQL 2012 server wanting to run a SSIS job to pull data from a...

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

Viewing 15 posts - 1 through 15 (of 120 total)