Forum Replies Created

Viewing 15 posts - 2,971 through 2,985 (of 9,725 total)

  • 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

  • RE: Differential backup pushing a full backup?

    Benki Chendu (1/12/2015)

    I see some 12 tables being modified between the full backup and the differential backup taken in the next 5-6 hours but none of them seem to be...

    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:10 am

    #1769802

  • RE: No elevated right yet need to create a database.

    You've posted this in the wrong forum. I'll ask Steve to move this to the 2012 forum.

    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:03 am

    #1769798

  • RE: Execute SQL task issue

    Without knowing a few more details, this one is hard to answer.

    Can you post pics of all tabs on your EXECUTE SQL task?

    Also, how many is "more records"? 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.

    January 13, 2015 at 7:02 am

    #1769797

  • RE: Best way to migrate data from 2005 to 2008R2 env

    SQLisAwE5OmE (1/13/2015)

    GilaMonster (1/13/2015)

    Script all their modified procs, views, functions out. Backup, restore with overwrite. Run script with all objects (take a backup of their DB first, just in case)

    Likely to...

    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 6:58 am

    #1769796

  • RE: SQL query to check log shipping error

    Peter2012 (1/12/2015)

    Hi Gurus,

    We're using SQL server 2008 R2 and have been receiving the following error messages recently.

    ----------------------------------------------------------------------------------

    Error: 14421, Severity: 16, State: 1.

    Date12/1/2015 12:06:00 PM

    LogSQL Server (Current - 12/1/2015 5:45:00 PM)

    Sourcespid55

    Message

    Error:...

    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 6:47 am

    #1769789

  • RE: Best way to migrate data from 2005 to 2008R2 env

    The other possibility (correct me if I'm wrong, everyone) is to use the DTSX Import Wizard from the 2008R2 server to grab the data from the 2005 server. It won't...

    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 6:44 am

    #1769787

  • RE: Excel Hell using SSIS

    Koen Verbeeck (1/13/2015)

    You can also set TypeGuessRows to 0 in the registry. It then scans the first 60,000 rows or so.

    WOW. I did not know about that hack. Thanks, Koen.

    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 6:39 am

    #1769786

  • RE: How to Loop the unmatched rows data from two tables in sqlserver 2012

    Can you try explaining in more English and less code what you're trying to accomplish?

    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 6:37 am

    #1769785

  • RE: Copy from "edit top N rows" with an auto increment field

    masoudk1990 (1/13/2015)

    I know how to copy and paste data from one table to another table with INSERT and SELECT query.

    I just want to know is it possible to do 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.

    January 13, 2015 at 6:36 am

    #1769784

  • RE: SSIS-Stored-Packages via Job: Logging fails

    ElKapy (1/12/2015)

    Hello there,

    I have a some SSIS-Stored-Packages. Running these jobs via "Run package", works fine, inluding logging.

    Running the packages by Job, however, works also fine, except the Logging!

    Looking in 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 6:33 am

    #1769782

Viewing 15 posts - 2,971 through 2,985 (of 9,725 total)