Forum Replies Created

Viewing 15 posts - 7,186 through 7,200 (of 9,720 total)

  • RE: Today's Random Word!

    bikini top

    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.

    October 18, 2010 at 10:35 am

    #1238528

  • RE: format date within reporting services

    Which version of SSRS? 2000, 2005, or 2008?

    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.

    October 18, 2010 at 8:56 am

    #1238465

  • RE: declare dynamic variable text type

    No. You don't convert. Just create the datatype as type Nvarchar(Max). It's really that simple.

    EDIT: SQL Server will known how to handle your datatype and will only use the amount...

    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.

    October 18, 2010 at 8:36 am

    #1238449

  • RE: SSIS Insert Violation of PRIMARY KEY constraint during insert on SSIS

    I did read your first post. You didn't say anything about "passes" in that post. Hence the reason I asked the question.

    As far as your primary key violation goes... 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.

    October 18, 2010 at 8:33 am

    #1238448

  • RE: declare dynamic variable text type

    sqldba_icon (10/18/2010)

    Thanks Brandie, and i was refering to Wayne's statement. There is limit of 8000 characters on nvarchar and my sql dynamically generates more than 8000 characters of code 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.

    October 18, 2010 at 8:23 am

    #1238440

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (10/18/2010)

    Gianluca Sartori (10/18/2010)

    Plz, do my homework!

    Plz, do my homework (reloaded)!

    Well, I was wrong.

    When I see things like "plz" and "How can i write the Sp PLZ let me...

    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.

    October 18, 2010 at 8:17 am

    #1238435

  • RE: Are the posted questions getting worse?

    Ray K (10/18/2010)

    I can haz cheezburger?

    Noes! U cantz haz cheezburger!

    But u can haz lazanya.

    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.

    October 18, 2010 at 8:15 am

    #1238431

  • RE: You'd think I'd have learned...

    Ray K (10/18/2010)

    I don't make mistakes! I'm perfect! 😀

    You've heard the old adage, right?

    If you're not making mistakes, you're not actually working. @=)

    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.

    October 18, 2010 at 8:11 am

    #1238425

  • RE: How to create new instance in sql server 2005

    You may have a set of disks built for ghosted workstations. I.E., someone built the disks specifically for client tools only.

    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.

    October 18, 2010 at 8:05 am

    #1238419

  • RE: Are the posted questions getting worse?

    I love polite respondents. Heck, I love people who actually respond once you give them advice. It's nice to know when advice doesn't go down the rabbit hole and who...

    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.

    October 18, 2010 at 5:52 am

    #1238342

  • RE: SQL Server 2005 & Avast ADNM issues

    Glad I could help. Please let us know if you have any additional questions.

    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.

    October 18, 2010 at 5:50 am

    #1238341

  • RE: Help please

    I assume this is in SSIS? You're using the Script Transformation Editor?

    What exactly does your input and output data look like (examples, please)? Are you pulling from SQL Server 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.

    October 18, 2010 at 5:35 am

    #1238333

  • RE: Split names into columns

    Aha. There are similarities in this code for what I did as an article today. Using spaces to alter character case. In this situation, though, I'd advise looking at 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.

    October 18, 2010 at 5:25 am

    #1238330

  • RE: declare dynamic variable text type

    sqldba_icon (10/15/2010)

    hmm.. i don't completely agree."Unless the text is over 8,000 bytes at which point it behaves like an NTEXT and stores the text value in the LOB".

    You don't completely...

    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.

    October 18, 2010 at 5:22 am

    #1238329

  • RE: Convert Date (dd-MM-YYYY) to (dd/MM/YYYY)

    You need to follow both Gail's and Jeff's advice. You can embed a REPLACE inside of a CONVERT to fix the hypen problem, then switch that column to datetime 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.

    October 18, 2010 at 5:16 am

    #1238326

Viewing 15 posts - 7,186 through 7,200 (of 9,720 total)