Forum Replies Created

Viewing 15 posts - 3,541 through 3,555 (of 7,164 total)

  • RE: Mirroring to multiple databases possible?

    GilaMonster (7/18/2012)

    Kiran.Baderdinni (7/18/2012)

    Won't a bad page in the tran log backup (any of the hourly tan backup) have the same outcome?

    Corruption is from something in the IO subsystem stamping on...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 18, 2012 at 1:00 pm

    #1514481

  • RE: Mirroring to multiple databases possible?

    For HA, in my opinion Log Shipping to multiple secondary instances is a much better option than Transactional Replication.

    Log Shipping Overview (2008 R2)

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 18, 2012 at 12:33 pm

    #1514451

  • RE: Main question is how to connect or map dtsx and dtsconfig file in different computer?

    Munabhai (7/18/2012)

    Yes, I got it that part and it does work too. If you know, could you please tell me if location is different then how to point that dtsconfig...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 18, 2012 at 12:11 pm

    #1514426

  • RE: Maximum Memory Windows Server 2003 32 bit?

    Welsh Corgi (7/17/2012)

    I could do an in Place Upgrade to the OS to Enterprise Edition.

    Has anyone tried that and what was the outcome>

    I haven't personally tried it, but have seen...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 18, 2012 at 12:08 pm

    #1514421

  • RE: Main question is how to connect or map dtsx and dtsconfig file in different computer?

    If you place both the dtsx and dtsConfig files in the same path on all computers, i.e. the one you use for development on your own machine, then yes, the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 18, 2012 at 11:13 am

    #1514373

  • RE: SQL Server data storage type

    Mongo DB provides a JSON/BSON interface to issue commands to retrieve and store data.

    Microsoft SQL Server provides a T-SQL interface to do the same. T-SQL stands for Transact-SQL and...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 18, 2012 at 10:25 am

    #1514343

  • RE: Main question is how to connect or map dtsx and dtsconfig file in different computer?

    Munabhai (7/18/2012)

    I have SSIS package. It pulls the data from production server and dump in devlopment server. It run perfectly. If somebody want to run same package in QA or...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 18, 2012 at 10:15 am

    #1514336

  • RE: returning part of string with derived column transform

    It looks like you want to take a decimal and turn it into an integer. Try the Data Conversion Transformation instead of the Derived Column Transformation.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 18, 2012 at 9:38 am

    #1514305

  • RE: Today's Random Word!

    chronostasis

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 17, 2012 at 3:55 pm

    #1513926

  • RE: Inserting VBA Procedure into CSV Files Using SSIS

    How is it going?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 17, 2012 at 1:55 pm

    #1513864

  • RE: Kerberos to NTLM

    How is it going?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 17, 2012 at 1:53 pm

    #1513860

  • RE: Importing Mixed datatypes from a excel column into SQL table

    Post your Excel file to this thread as an attachment.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 17, 2012 at 1:42 pm

    #1513846

  • RE: Scripting in SSIS

    In SSIS 2005 you could use VB.NET. As of SSIS 2008 you have the option to use VB.NET or C#.

    Here are examples from Microsoft that show what they had in...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 17, 2012 at 1:36 pm

    #1513843

  • RE: Moving to new schema and from 2000 to 2008.

    goody71 (7/17/2012)

    I'm moving our DB from 2000 to 2008.

    I'm also developing a .NET App and plan to use this 'starting over' point to fix the schema of our DB. ...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 17, 2012 at 1:08 pm

    #1513829

  • RE: Creating a new database from an existing Access one

    brian.stewart 98697 (7/17/2012)

    I have been experience difficulty converting an access DB to one that can be viewed in SQL Server 2012. This task should be simple right? However...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 17, 2012 at 12:57 pm

    #1513817

Viewing 15 posts - 3,541 through 3,555 (of 7,164 total)