Forum Replies Created

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

  • RE: Object Explorer Details & undocumented system stored procedures

    TheSQLGuru (8/9/2016)


    SQLJudo did a 30-day series on creating your own SSMS Add-in. Why don't you just build what you need (and then make a product out of it and become...

    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)


    So it's this row that generates the error?

    EXEC master.sys.xp_create_subdir @DatabaseDailyFolder;

    If so, I think you might have to modify your code to capture the execution status of the xp...

    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?

    SQLRNNR (8/10/2016)


    Brandie Tarvin (8/10/2016)


    Sean Lange (8/10/2016)


    Brandie Tarvin (8/10/2016)


    SQLRNNR (8/9/2016)


    Brandie Tarvin (8/9/2016)


    Sigh.

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

    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?

    Sean Lange (8/10/2016)


    Brandie Tarvin (8/10/2016)


    SQLRNNR (8/9/2016)


    Brandie Tarvin (8/9/2016)


    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,...

    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?

    SQLRNNR (8/9/2016)


    Brandie Tarvin (8/9/2016)


    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...

    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: 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.

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