Forum Replies Created

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

  • Reply To: SQL Instance Aliases - Urgent assistance needed please

    Eddie Wuerch wrote:

    > Okay, so it does work with the port number. Now how do I get it to connect without the port number?

    Start the SQL Browser service.

    It was already started....

    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 Instance Aliases - Urgent assistance needed please

    Nevermind. Apparently 50 restarts of the service and recreating the aliases a dozen times will finally get it to work. And must use port 1433 to get the alias 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 Instance Aliases - Urgent assistance needed please

    Okay, so it does work with the port number. Now how do I get it to connect without the port number?

     

    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?

    Having lots of fun at the office. All the old guard has retired and we have several new people coming in who don't know the environment and business rules yet....

    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: Encrypting SQL 2012

    It took me a while to realize the person in question was conflating KMS with TDE. Because I pushed back on using TDE on our specific SQL 2012 environment, they...

    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?

    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.

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