Forum Replies Created

Viewing 15 posts - 2,026 through 2,040 (of 9,725 total)

  • RE: import data from an excel to sql server

    Orlando Colamatteo (2/13/2016)

    Brandie Tarvin (2/12/2016)

    Because ... Excel .... SUCKS ... that way. :pinch:

    I would say it as "because integrating with Excel sucks that way." It is not technically Excel that...

    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.

    February 24, 2016 at 7:34 am

    #1860719

  • RE: Are the posted questions getting worse?

    Alan.B (2/23/2016)

    I don't know if anyone is aware of this but I noticed Dwain Camps hadn't posted anything in awhile so I checked his blog (dwaincsql.com), simple-talk, twitter, linkedin... then...

    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.

    February 24, 2016 at 7:22 am

    #1860712

  • RE: Are the posted questions getting worse?

    djj (2/18/2016)

    Hey, who shut down the water cooler? I do not post often here, but I read it every day. Usually there is a lot going on by...

    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.

    February 24, 2016 at 7:12 am

    #1860705

  • RE: How do we get the definition of tables via sql

    mw112009 (2/12/2016)

    I don't have a need to understand how SQL SERVER works. That is not a part of my job.

    Honestly, if knowing how SQL Server works is NOT part...

    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.

    February 12, 2016 at 11:27 am

    #1858467

  • RE: smtp logging into sql server using ODBC connections

    So what smtp stuff are you logging? IIS stuff? Or database mail?

    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.

    February 12, 2016 at 11:16 am

    #1858461

  • RE: Are the posted questions getting worse?

    Sean Lange (2/12/2016)

    Brandie Tarvin (2/12/2016)

    Thank you backup, Sean. I'm still shaking my head over the OPs initial "you're wrong, that can't be done after all" and then "Well, prove it"...

    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.

    February 12, 2016 at 8:27 am

    #1858379

  • RE: SSDT & TFS

    I know this thread is "dead," but ...

    Update for those who stumble across this thread like I just did, if you have a 64-bit box, follow the instructions here 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.

    February 12, 2016 at 8:23 am

    #1858377

  • RE: Adding quotes to dynamic SQL

    TheSQLGuru (2/11/2016)

    Whenever I am building out dynamic SQL I always use SET QUOTED_IDENFITIER OFF first and then use double quotes in the outer sections of text. Then I never have...

    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.

    February 12, 2016 at 8:20 am

    #1858372

  • RE: Are the posted questions getting worse?

    Thank you backup, Sean. I'm still shaking my head over the OPs initial "you're wrong, that can't be done after all" and then "Well, prove it" responses.

    EDIT: I found it...

    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.

    February 12, 2016 at 8:09 am

    #1858366

  • RE: SSIS fail out of Foreach loop to stop processing

    webrunner (2/12/2016)

    I eventually found out what was happening.

    I was using @[User::Variable] = 0 instead of the operator to check for equality @[User::Variable] == 0. Once I fixed that the branching...

    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.

    February 12, 2016 at 8:06 am

    #1858364

  • RE: How do we get the definition of tables via sql

    mw112009 (2/12/2016)

    Well then can you be kind enough to share that code with us please ?

    The reason I haven't shared the code is because this is a great time...

    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.

    February 12, 2016 at 7:49 am

    #1858351

  • RE: How do we get the definition of tables via sql

    mw112009 (2/12/2016)

    I am not trying to be mean here....

    But the real answer is...

    "[There is no way to do that in one or several SQl statememts]"

    Well, I'm sorry to disagree with...

    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.

    February 12, 2016 at 6:58 am

    #1858331

  • RE: SSDT 2010 or 2012?

    Nevermind. Found my answer here: https://msdn.microsoft.com/en-us/hh500335(v=vs.103).aspx

    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.

    February 12, 2016 at 6:28 am

    #1858321

  • RE: smtp logging into sql server using ODBC connections

    What type of ODBC DSN did you actually create? File, System or User?

    EDIT: And what type of OS do you have on your server? It seems to me that this...

    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.

    February 12, 2016 at 6:11 am

    #1858316

  • RE: SSIS fail out of Foreach loop to stop processing

    There's no way to cause a Foreach loop to stop in the middle unless you deliberately fail it out. If you want to do that, stick a script task 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.

    February 12, 2016 at 6:08 am

    #1858313

Viewing 15 posts - 2,026 through 2,040 (of 9,725 total)