Forum Replies Created

Viewing 15 posts - 181 through 195 (of 9,715 total)

  • Reply To: Are the posted questions getting worse?

    Could urgently use some help here, please. https://www.sqlservercentral.com/forums/topic/encrypting-sql-2012

    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: SSIS Inserts 01/01/1753 instead of NULL for datetime

    pmidgette wrote:

    Thanks!

    This helped me 13 years after you posted it!

    So glad it did.

    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?

    Completely missing the point, Phil.

    It's not discrimination. You are not being forbidden from attending these conferences. You are not incapable of getting jobs or networking because of your gender or...

    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?

    Jeff Moden wrote:

    Can someone tell me why this isn't horribly racially prejudiced?

    https://www.eventbrite.com/e/black-is-tech-conference-2021-tickets-149570987851

    Can I open a "White Is Tech" conference without any ramifications?  I never would, though.  THAT would be racist.

    Can...

    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: sp_send_dbmail: Failed to initialize sqlcmd library with error number -214746725

    Oh, FOR HEAVEN'S SAKE!

    It was executing the query under the context of msdb, not the original database, so the query needs to have the MyDB prepended to the dbo.MyTable.

    <headdesk>

    I used...

    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?

    Well THIS is annoying.

    I have an SSIS solution / project saved that is set to DontSaveSensitive. All the packages under it are saved as the same. Last week, everything was...

    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?

    So here's a random thought based on your last post, Steve. If this is the longest thread in the world, how do we get it into the Guinness book of...

    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?

    I find myself wondering how many people who frequent this website have gotten the dreaded bug and are unable to return for ... various reasons. I hope everyone is doing...

    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: Mysterious ability to drop / create stored procedures

    Well, THAT was a pain.

    As Mr. Monk would say, "Here's what happened..."

    Somehow, several members of one team (Team A) got added to the security group of another team (Team B)....

    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: Mysterious ability to drop / create stored procedures

    The individual users don't exist on the server. They are part of a windows login group, which is not returning results and erroring out.

    I think I'm going nuclear. I've removed...

    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: Mysterious ability to drop / create stored procedures

    HMMM... We use groups in SQL Server, so the individual login isn't working. And the group gives the same error.

    Msg 15406, Level 16, State 1, Line 1

    Cannot execute as 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: Mysterious ability to drop / create stored procedures

    Mr. Brian Gale wrote:

    Another thing to check is linked servers.  If a linked server connection connects to that instance as a user who has permission to drop and create objects AND you...

    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: Mysterious ability to drop / create stored procedures

    frederico_fonseca wrote:

    I assume you know which login dropped/created the procs.

    and assuming you are a SYSADMIN what output do you get out of these

    execute as login = 'loginname' SELECT * FROM...

    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: Mysterious ability to drop / create stored procedures

    There is no schema owned by this group. But you brought up an interesting point. Sometimes groups become owner of system created database schemas, so I double-checked. The group does...

    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?

    I am getting really annoyed with this "link to the post takes me to the second last page of the thread, not the actual post" 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.

Viewing 15 posts - 181 through 195 (of 9,715 total)