Forum Replies Created

Viewing 15 posts - 6,916 through 6,930 (of 9,728 total)

  • RE: Zipping a Text file

    varshakarnik 92752 (12/5/2010)

    I've create batch file:

    @Echo off

    "\\keenm\c$\WinZip\WZZIP.exe" "\\Dell\Tessitura\Source\sso_pacingdata.zip" "\\Dell\Tessitura\Source\sso_pacingdata.txt"

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

    Now i run

    master..xp_cmdshell 'Text_Zip_Cmd.Bat'

    If you are running this batch file on the server, from the server, you need to get rid of...

    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.

    December 6, 2010 at 5:10 am

    #1258955

  • RE: Loading the Data from different excel files to different excel sheets in one excel file

    prasanna-750812 (12/5/2010)

    The number of sources will not be constant for each run.............so i think we can't use multiple sources or multiple data flow tasks.............

    Sounds like a case of needing a...

    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.

    December 6, 2010 at 5:04 am

    #1258953

  • RE: Flat File not outputting Row Delimiters

    Craig Farrell (12/3/2010)

    For those playing along at home, Ragged Right needs a specific setup, you need to have one extra column in the advanced section for the CR/LF. Basically,...

    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.

    December 6, 2010 at 5:01 am

    #1258951

  • RE: dropping a column doesnt create space at all..?

    PaulB-TheOneAndOnly (12/3/2010)

    Brandie Tarvin (12/3/2010)

    Repopulating a table isn't necessarily that easy. Especially if it has foreign keys, indexes, constraints, etc. If it's a heap, then not so bad. But you're also...

    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.

    December 6, 2010 at 4:56 am

    #1258949

  • RE: SQL Server 2005 Maintainaince Plan excution fails

    guruprasadurs (11/15/2010)

    hi brandie..

    Last time i resolved a issue with the help of u....

    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.

    December 3, 2010 at 11:45 am

    #1258582

  • RE: Are the posted questions getting worse?

    Roy Ernest (12/3/2010)

    Brandie Tarvin (12/3/2010)

    On an interesting side note, I did not know until today that SQL Server considered text, ntext, image, sql_variant, and XML data types as "variable-length."

    Oh, 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.

    December 3, 2010 at 8:50 am

    #1258457

  • RE: dropping a column doesnt create space at all..?

    Paul,

    Repopulating a table isn't necessarily that easy. Especially if it has foreign keys, indexes, constraints, etc. If it's a heap, then not so bad. But you're also forgetting the question...

    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.

    December 3, 2010 at 8:48 am

    #1258454

  • RE: Are the posted questions getting worse?

    Alvin Ramard (12/3/2010)

    I have a confession to make.

    While setting up WordPress yesterday, I had to create a MySQL database.

    I hope y'all will forgive me.

    Blasphemy! Blasphemy! Ban him from 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.

    December 3, 2010 at 8:45 am

    #1258452

  • RE: Are the posted questions getting worse?

    On an interesting side note, I did not know until today that SQL Server considered text, ntext, image, sql_variant, and XML data types as "variable-length."

    Oh, it makes sense when 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.

    December 3, 2010 at 8:33 am

    #1258443

  • RE: dropping a column doesnt create space at all..?

    sqldba_icon (12/3/2010)

    Brandie the column i have deleted is a ntext data type.

    Would DBCC Cleantable still help? If not how do i clear space , please advice.

    Do you have a...

    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.

    December 3, 2010 at 8:29 am

    #1258440

  • RE: SSMS & Database snapshot

    Patrick2525 (12/3/2010)

    Within SSMS, click on Replication -> Publications, right click -> New Publication, and follow the wizard for either a Merge or Snapshot replication, and a snapshot will be created!...

    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.

    December 3, 2010 at 8:08 am

    #1258429

  • RE: Are the posted questions getting worse?

    Articles like this always interest me. .

    http://education.yahoo.net/articles/quick_career_changes.htm?kid=1BOPU

    Forget about the paralegal reference. Look at the others. How many of you have ever been in a situation where salaries like this would...

    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.

    December 3, 2010 at 7:12 am

    #1258396

  • RE: replicating records w/o using a cursor

    Chris Morris-439714 (12/3/2010)

    What folks often forget about tally tables is that they are a source of rows as well as numbers.

    I've actually used a Tally Table to do that too,...

    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.

    December 3, 2010 at 6:43 am

    #1258369

  • RE: Loading the Data from different excel files to different excel sheets in one excel file

    stewartc-708166 (12/3/2010)

    There is a difference between the data providers to connect to Excel pre 2007 vs post 2007.

    Ah. Good to know. Thanks for clarifying.

    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.

    December 3, 2010 at 5:34 am

    #1258325

  • RE: replicating records w/o using a cursor

    Josh,

    Can you give us DDL code for the other tables too? And it would help to know which of those tables in the query is the one that #mytable 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.

    December 3, 2010 at 5:31 am

    #1258324

Viewing 15 posts - 6,916 through 6,930 (of 9,728 total)