Forum Replies Created

Viewing 15 posts - 91 through 105 (of 9,725 total)

  • Reply To: Scripting SQL Jobs

    Ant-Green, am I missing something? I'm trying to script to a file. That link shows me how to copy from one server to another.

    EDIT: I think what I need is...

    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.

    August 6, 2024 at 1:54 pm

    #4442760

  • Reply To: Scripting SQL Jobs

    I have dbatools installed. I'll look at this information. Thanks.

    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.

    August 6, 2024 at 1:51 pm

    #4442758

  • Reply To: Scripting SQL Jobs

    That article is for SQL 2008. The servers are 2017 and I'm pretty sure SMO code doesn't work anymore in 2017.

    EDIT: Even looking at the PowerShell options, it doesn't let...

    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.

    August 6, 2024 at 1:09 pm

    #4442754

  • Reply To: Scripting SQL Jobs

    SMO still works? I thought it got deprecated or removed.

    I'll check it out.

    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.

    August 6, 2024 at 1:08 pm

    #4442753

  • Reply To: Are the posted questions getting worse?

    And the hits keep coming. Google Chrome, fixed now fortunately.

    Passwords disappear for millions of Windows users thanks to Google | Windows Central

    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.

    July 29, 2024 at 11:34 am

    #4440726

  • Reply To: Are the posted questions getting worse?

    It gets better. A few days after the CrowdStrike outage, now THIS is a thing and it's totally Microsoft:

     

    Windows July security updates send PCs into BitLocker recovery (bleepingcomputer.com)

    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.

    July 26, 2024 at 2:16 am

    #4439952

  • Reply To: Are the posted questions getting worse?

    Anyone notice that Microsoft is trying to blame the EU for their 2009 non-compete settlement being the root cause of the CloudStrike issue?

    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.

    July 22, 2024 at 4:54 pm

    #4438898

  • Reply To: Select permission denied despite group having db_datareader

    I don't see anything in their connection strings that indicate they're trying to log in as a "user" vs "login" so I still have no idea what the issue is.

    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.

    July 3, 2024 at 3:48 pm

    #4433210

  • Reply To: Select permission denied despite group having db_datareader

    They are using a stored procedure at the upper level which references the views, and I'm not sure changing the last view's code to be a proc in the other...

    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.

    July 3, 2024 at 3:17 pm

    #4433191

  • Reply To: Error: Server is configured for Integrated authentication only.

    Yes. I triple-checked before I posted.

    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.

    June 27, 2024 at 1:01 pm

    #4431879

  • Reply To: Schema Execute not working on sproc

    Oh, thank you for that bit of code. I shall try it out. It might 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.

    June 13, 2024 at 2:21 pm

    #4428249

  • Reply To: Schema Execute not working on sproc

    Will that tell me if it's double-hopping?

    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.

    June 11, 2024 at 7:34 pm

    #4427846

  • Reply To: Are the posted questions getting worse?

    I could use some perspective on an execution issue, please. Schema Execute not working on sproc – SQLServerCentral Forums.

    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.

    June 11, 2024 at 7:12 pm

    #4427841

  • Reply To: Are the posted questions getting worse?

    Quick interuption: 5+ gallons of blueberries from my bushes. First picking. And oh, do they taste good.

    More berries to come in a few weeks, possibly just as many.

    What to do....

    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.

    May 28, 2024 at 3:22 pm

    #4424454

  • Reply To: Linked Server Product Name?

    Is "Product Name" just a tag, then? Not actually required for the linked server to function?

    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.

    May 24, 2024 at 11:18 am

    #4423734

Viewing 15 posts - 91 through 105 (of 9,725 total)