Forum Replies Created

Viewing 15 posts - 1,546 through 1,560 (of 9,720 total)

  • RE: Advice needed - troubleshooting Severity 20 errors

    Luis Cazares (8/9/2016)


    Did you try increasing the max token size as suggested in here:https://msdn.microsoft.com/en-us/library/cc645913.aspx?

    No. Because my Google-Fu didn't uncover this page. Thanks for the link. 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.

  • RE: Are the posted questions getting worse?

    Sigh.

    I am experiencing that sinking feeling one gets when one realizes an instance of SQL was installed without a sysadmin account.

    To be fair, I don't know for sure that 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.

  • RE: Object Explorer Details & undocumented system stored procedures

    TheSQLGuru (8/3/2016)


    Brandie Tarvin (8/3/2016)

    I appreciate the suggestion, Eric. But my hands are tied on third party software. We're not allowed to use unapproved stuff. Hence hacking SSMS Object Explorer Details...

    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.

  • RE: Object Explorer Details & undocumented system stored procedures

    Well, this is heartbreaking...

    Poking around AdventureWorks, I get stuff like this in SQL 2008.

    exec sp_executesql N'SELECT

    udf.name AS [Name],

    SCHEMA_NAME(udf.schema_id) AS [Schema],

    ''Server[@Name='' + quotename(CAST(

    serverproperty(N''Servername'')

    ...

    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.

  • RE: T-SQL Backup Code

    Phil Parkin (8/9/2016)


    Wow, those double quotes are really throwing the SQL parser off, makes it difficult to read.

    It's probably obvious, but I didn't see it. Which line of code 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.

  • RE: Are the posted questions getting worse?

    Luis Cazares (8/5/2016)


    djj (8/5/2016)


    Brandie Tarvin (8/5/2016)


    A million things to do at work and they want me off my PC. I've got a new one I've got to configure.

    So I'm importing...

    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.

  • RE: Are the posted questions getting worse?

    Phil Parkin (8/5/2016)


    ThomasRushton (8/5/2016)


    Brandie Tarvin (8/5/2016)


    A million things to do at work and they want me off my PC. I've got a new one I've got to configure.

    So I'm importing...

    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.

  • RE: Are the posted questions getting worse?

    A million things to do at work and they want me off my PC. I've got a new one I've got to configure.

    So I'm importing my outlook rules, my IE...

    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.

  • RE: Get one type with max id

    Eirikur Eiriksson (8/4/2016)


    Nice input Brandy, appreciate it:-) Maybe the OP can enlighten us on the issue?

    😎

    There's also the issue of the final sort order. Lynn's results are sorted differently than...

    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.

  • RE: Get one type with max id

    Eirikur Eiriksson (8/4/2016)


    The problem with Lynn's fine solution is that it isn't able to utilise an index on the Address Type, hence a relatively expensive sort operator is introduced in...

    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.

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (8/4/2016)


    Lynn Pettis (8/3/2016)


    Jack Corbett (8/3/2016)


    Lynn Pettis (8/3/2016)


    Is the code I wrote here really that sophisticated, or is it that I have been doing this so long...

    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.

  • RE: Object Explorer Details & undocumented system stored procedures

    Luis Cazares (8/3/2016)


    Brandie Tarvin (8/3/2016)


    . I assume I open a trace against the server I'm browsing as opposed to my local machine?

    Exactly, unless they're the same. I did that 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.

  • RE: Always on Multi subnet : RPC issue

    mikaeru (8/1/2016)


    Thanks.

    The stairway does't seem to talk about multisubnet 🙂

    Well we have a strange network setup, I currently work in Tokyo and they not that flexible ...

    Did you read...

    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.

  • RE: Object Explorer Details & undocumented system stored procedures

    Eric M Russell (8/1/2016)


    Rather than attempting to hack SSMS Object Explorer, maybe there is a SSMS add-in alternative that work in the way you want. Some people like to use...

    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.

  • RE: Are the posted questions getting worse?

    BrainDonor (8/2/2016)


    Anybody remember DataEase? They've 'relaunched' the DOS version:

    http://www.dataease.com/test_article_view/?ArticleID=00122&field1=00122

    Whoever posted or proofed this is not a native English speaker. Or it's a translation program gone rogue.

    We don't know if...

    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 - 1,546 through 1,560 (of 9,720 total)