Forum Replies Created

Viewing 15 posts - 241 through 255 (of 9,715 total)

  • Reply To: Insert variable values into SQL Server table

    HA! Finally got someone in corporate who had a clue and pointed me to the way to get the SqlServer module loaded outside of powershell.

    Do manual download from https://www.powershellgallery.com/packages/SqlServer/21.1.18246-preview. Save...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Reply To: Insert variable values into SQL Server table

    It doesn't, actually, because the output does the date in named format. "Apr 06 01:18 " for example. It's a little frustrating.

    I'll keep playing with the code and see if there's...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Reply To: Insert variable values into SQL Server table

    The Invoke command looks like what I need after taking a few hours to look it over, but now the problem I'm running into is that I can't install the...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Reply To: Are the posted questions getting worse?

    Spam can be very tasty given the right circumstances. I especially like turkey spam, grilled.

    @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Reply To: 2019 SSRS Install problem

    BWAHAHAHAHAHAHA... or maybe that should be WAAAAAAAAAAAAAAAHHHHHHH.

    I opened a ticket with Microsoft regarding this issue. After an entire week of back and forth (and the version of ProcMon they had...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Reply To: 2019 SSRS Install problem

    Well, we did get SSRS installed. We just can't create a new database or get it to restore encryption keys when we restore the 2012 ReportServer and ReportServerTempDB databases to...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Reply To: SQL Server Interview Questions And Answers

    Your workplace asks some interesting questions, but anyone reading this thread should be aware that it's specific to your workplace and other employers (like my team) doesn't ask questions like...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Reply To: 2019 SSRS Install problem

    Our version is Microsoft SQL Server 2019 (RTM-CU8-GDR) (KB4583459) - 15.0.4083.2 (X64)

    Nov  2 2020 18:35:09

    Copyright (C) 2019 Microsoft Corporation

    Developer Edition (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393:...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Reply To: 2019 SSRS Install problem

    That link refers to SQL 2017 and apparently Microsoft had to go in and fix the installer package because the user had to re-download and use the Upgrade option.

    I'll try...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Reply To: 2019 SSRS Install problem

    So I'm not going to be able to directly upgrade my 2012 ReportServer database to 2019?

    And we're not going to be able to have multiple instances? That sucks and poses...

    Attachments:
    You must be logged in to view attached files.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Reply To: Are the posted questions getting worse?

    There's something suspicious about your provider, who charges by the GB, not telling you how much storage you're using. Might want to have someone go over the contract to verify...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Reply To: Aliasing an instance name for remote connections

    Jeffrey Williams wrote:

    Brandie Tarvin wrote:

    Okay, I don't have control over the DNS process. I filled out a form and sent it along. I'm told it's set up the same as working instances....

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Reply To: Aliasing an instance name for remote connections

    Okay, I don't have control over the DNS process. I filled out a form and sent it along. I'm told it's set up the same as working instances. Also, I...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Reply To: Aliasing an instance name for remote connections

    RE: IPAll, yes I set it to the same port as the aliases.

    It's been a few weeks since the DNS setup, so I would assume it's propagated everywhere. My help...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Reply To: Aliasing an instance name for remote connections

    Yes, Browser is running.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 15 posts - 241 through 255 (of 9,715 total)