Forum Replies Created

Viewing 15 posts - 2,956 through 2,970 (of 9,720 total)

  • RE: SQL query to check log shipping error

    Making the links clickable...

    lmarkum (1/14/2015)

    Peter2012,

    I did a little research and came across a link to a Microsoft Support article that discusses how this error gets triggered. That led...

    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.

    January 15, 2015 at 4:26 am

    #1770388

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (1/14/2015)

    Luis Cazares (1/14/2015)

    Congratulations Koen! When I grow up I want to be like you. :hehe:

    Action figures will soon be available! 😎

    With or without superhero capes?

    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.

    January 14, 2015 at 12:01 pm

    #1770205

  • RE: Users&Roles for all db's

    The dynamic SQL is going to be hard to get around unless you hard code all your USE DATABASE statements.

    There are two ways of getting around the sp_MSforeachdb. 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.

    January 14, 2015 at 10:08 am

    #1770168

  • RE: Excel Hell using SSIS

    Koen Verbeeck (1/13/2015)

    Jimmy123 (1/13/2015)

    Fairly certain. Think I has been stung by this recently. I am now definitely thinking convert to csv.

    I tested it and the numeric value is imported as...

    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.

    January 14, 2015 at 6:04 am

    #1770078

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (1/13/2015)

    FYI, I received the Author of the Year award at MSSQLTips.com!

    Thanks everyone for voting!

    Congrats!

    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.

    January 14, 2015 at 6:02 am

    #1770076

  • RE: Want to ensure I'm not going to break my SQL Server service account

    Excellent.

    Apparently option 1 is the option of choice. My only worry was that if you were in production, it might stop stuff in the middle of processing.

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

    January 13, 2015 at 9:05 am

    #1769856

  • RE: Starting from Scratch - How long to get the gist of SQL Server?

    IncidentalProgrammer (1/6/2015)

    Grant Fritchey (1/6/2015)

    Nah, the basics of backup are, well, basic. You'll be fine. Restore gets marginally more complicated. But then it can get crazy as you start to add...

    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.

    January 13, 2015 at 9:01 am

    #1769851

  • RE: Want to ensure I'm not going to break my SQL Server service account

    Jason,

    Is this production or a non-prod environment?

    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.

    January 13, 2015 at 8:58 am

    #1769849

  • RE: Are the posted questions getting worse?

    Quick technical question (don't hurt me!). Google Fu refuses to tell me the max size of an object variable in SSIS 2008. Anyone know this off the top of their...

    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.

    January 13, 2015 at 8:22 am

    #1769837

  • RE: Differential backup pushing a full backup?

    Jeff Moden (1/13/2015)

    Tony++ (1/13/2015)

    To ask the silly and obvious: Are they both either compressed or uncompressed?

    Doing full as compressed & diffs as uncompressed could get you that closeness in size.

    I...

    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.

    January 13, 2015 at 8:18 am

    #1769835

  • RE: Execute SQL task issue

    Brandie Tarvin (1/13/2015)

    What about the other three tabs, Parameter Mapping, Result Set, and Expressions?

    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.

    January 13, 2015 at 8:15 am

    #1769832

  • RE: Execute SQL task issue

    Brandie Tarvin (1/13/2015)

    That is just the General tab, and not even all the information on it (timeout, codepage, bypassPrepare). What about the other three tabs, Parameter Mapping, Result Set, and...

    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.

    January 13, 2015 at 8:02 am

    #1769824

  • RE: Execute SQL task issue

    That is just the General tab, and not even all the information on it (timeout, codepage, bypassPrepare). What about the other three tabs, Parameter Mapping, Result Set, and Expressions?

    Side Note...

    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.

    January 13, 2015 at 7:54 am

    #1769822

  • RE: Want to ensure I'm not going to break my SQL Server service account

    jasona.work (1/12/2015)

    I'm working on cleaning up some bad choices made during SQL setup on a few boxes of mine, and one of the items on the list is getting 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.

    January 13, 2015 at 7:17 am

    #1769807

  • RE: Add Auto Incrementing column to my SELECT statement

    SAMDEV (1/13/2015)

    Hello Erin

    I would like to use same technique while inserting records into existing table. Is it possible by any way?

    As per my knowledge IDENTITY function can be 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.

    January 13, 2015 at 7:14 am

    #1769805

Viewing 15 posts - 2,956 through 2,970 (of 9,720 total)