Forum Replies Created

Viewing 15 posts - 5,761 through 5,775 (of 9,726 total)

  • RE: Missing Drive where SQL Server instance installed - Urgent help required

    If you have issues in the restore because of the lack of tail logs, let us know and we'll try and figure it out from there. But go ahead 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.

    June 16, 2011 at 8:18 am

    #1339766

  • RE: Batch alter stored procedure within one single transaction with error handling

    GilaMonster (6/16/2011)

    Brandie Tarvin (6/16/2011)

    Try naming the Transaction. See if that gets around the error.

    Naming transactions does just about nothing. It's a documentation thing (with one minor exception)

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

    June 16, 2011 at 8:15 am

    #1339761

  • RE: sql script in ssis package using variables

    Elliott Whitlow (6/16/2011)

    Use the input/output wizard and chose the tables and at the end save the package that should give you 98% of the work and be a lot faster...

    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.

    June 16, 2011 at 8:14 am

    #1339760

  • RE: sql script in ssis package using variables

    Elliott is correct on this one. Not only is SELECT...INTO going to cause you performance issues, but the use of * will also. Can I ask why you don't just...

    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.

    June 16, 2011 at 8:13 am

    #1339756

  • RE: Help me

    Okay, I'm a little confused. Could you speak less in L33T / text shorthand and more in real English words, please?

    How many containers do you have in your package? 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.

    June 16, 2011 at 8:11 am

    #1339751

  • RE: Get Source Location From a Table.

    Elliott Whitlow (6/16/2011)

    Brandie Tarvin (6/16/2011)

    Why use a Script Task when a File System Task might work just as well? You can set variables at the package level and have them...

    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.

    June 16, 2011 at 8:09 am

    #1339743

  • RE: SSIS Error Code DTS_E_PRODUCTLEVELTOOLOW

    Phil Parkin (6/15/2011)

    You need SQL Server Enterprise Edition to use fuzzy lookup.

    Phil, where did you get the idea that fuzzy lookup is only available to Enterprise Edition? SSIS is available...

    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.

    June 16, 2011 at 8:08 am

    #1339740

  • RE: Expression Builder Elipse Button(...) Does Not Appear

    EDIT- Whoops. Made the @@Version comment about the wrong post. My bad.

    I need to see a shot of the variable from the variables window AND the entire properties box when...

    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.

    June 16, 2011 at 8:04 am

    #1339732

  • RE: Batch alter stored procedure within one single transaction with error handling

    Try naming the Transaction. See if that gets around the error.

    Also, what you wrote makes no sense. You have a transaction with no way of backing out if there's...

    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.

    June 16, 2011 at 8:01 am

    #1339727

  • RE: sql script in ssis package using variables

    sonal_anjaria (6/16/2011)

    It is a Execute SQL Task. Trying to move tables from a sql server staging database to a production database

    I have created two variables at the container level, not...

    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.

    June 16, 2011 at 7:57 am

    #1339722

  • RE: Missing Drive where SQL Server instance installed - Urgent help required

    Sqlchicken (6/16/2011)

    viduvs (6/16/2011)

    Thanks for your reply.

    I was having the same solution to install a new fresh instance and then configure the things.

    Though we don't have a backup (even external backups),...

    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.

    June 16, 2011 at 7:50 am

    #1339708

  • RE: Batch alter stored procedure within one single transaction with error handling

    Lowell (6/16/2011)

    see opc.three's post from the thread below;

    i learned something here, since i was used to think that GO + BEGIN TRANS were not compatible, and now i know...

    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.

    June 16, 2011 at 7:19 am

    #1339672

  • RE: Batch alter stored procedure within one single transaction with error handling

    princa (6/16/2011)

    Lowell (6/16/2011)

    see opc.three's post from the thread below;

    i learned something here, since i was used to think that GO + BEGIN TRANS were not compatible, and now 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.

    June 16, 2011 at 7:17 am

    #1339670

  • RE: Missing Drive where SQL Server instance installed - Urgent help required

    I wish I could tell you otherwise, but unless you've got some other availability set up (log shipping, Database Mirroring, etc.), you're stuck doing it the old fashioned way.

    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.

    June 16, 2011 at 6:41 am

    #1339619

  • RE: Are the posted questions getting worse?

    Has anyone actually written an SSC article on how to write up and submit PASS abstracts?

    I know I'd be interested in seeing the process as my abstracts tend to suck....

    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.

    June 16, 2011 at 6:39 am

    #1339617

Viewing 15 posts - 5,761 through 5,775 (of 9,726 total)