Forum Replies Created

Viewing 15 posts - 4,201 through 4,215 (of 9,722 total)

  • RE: Short Cut commands not working -- Commenting code CNTRL+SHIFT+C

    Commenting for me is CTL - Shift - C and CTL - Shift - R to remove. But I'm using SQL 2008 with the keyboard option set to SQL 2000.

    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.

    July 11, 2012 at 11:25 am

    #1511703

  • RE: UTF - Multi Language Number System, need help, urgently!!!

    Sumit,

    Please don't make duplicate posts on the same issue. It is considered rude to repost the same question multiple times, especially to the people trying to help you.

    http://www.sqlservercentral.com/Forums/Topic1328029-391-1.aspx

    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.

    July 11, 2012 at 10:45 am

    #1511690

  • RE: Restore MSSQL 2000 backup into 2008 R2?

    Hadrian (7/11/2012)

    yes you can ,change the compatibility when it finish.

    That is not true. You can make the database compatible with SQL 2000 datatypes & such, but you cannot change 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.

    July 11, 2012 at 10:35 am

    #1511686

  • RE: SSIS Data Conversion

    Does your Flat File Connector have that column properly set as string?

    Can you show us an example of File to Table conversion? (I can't see 4000 only showing up as...

    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.

    July 11, 2012 at 10:32 am

    #1511683

  • RE: Pivot

    Clark,

    There are a lot of us that don't open attachments. Could you post your code in your reply, along with a CREATE TABLE statement (DDL) and an INSERT statement containing...

    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.

    July 11, 2012 at 10:25 am

    #1511680

  • RE: TSQL for result DB name, Size and Recovery model

    This type of code has already been posted on many sites using various methods, even this one. Try the search feature on this site and a search engine. If you...

    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.

    July 11, 2012 at 10:24 am

    #1511679

  • RE: MultiLanguage Support for Numerals

    Sumit,

    Please script out your table as a DDL (CREATE TABLE) statement and give us sample data in the form of an INSERT script so we can help you out.

    I assume...

    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.

    July 11, 2012 at 7:00 am

    #1511505

  • RE: query help

    Is this a homework assignment?

    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.

    July 11, 2012 at 6:57 am

    #1511502

  • RE: HI all . Glad to see you all . Need guidance :)

    I don't know any of the new books, but I do recommend studying recovery / backup, learning all variations on the SELECT statement, and security.

    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.

    July 10, 2012 at 8:37 am

    #1510977

  • RE: SQL Agent Job succeeds even though step should fail

    rmechaber (7/10/2012)

    Brandie, here's a link I found that suggests it is possible to fail a job step with RAISERROR:

    http://www.bidn.com/blogs/Daniel/ssas/2313/force-a-sql-agent-job-step-to-fail

    I just tested this by creating a dummy Agent job with 2...

    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.

    July 10, 2012 at 8:20 am

    #1510955

  • RE: Removing possible bad Indexes

    I've never heard of disabled indexes causing any problems.

    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.

    July 10, 2012 at 7:52 am

    #1510927

  • RE: Add Job History Manually..??

    Are your execs logging into Integration Services and executing the package from the Stored Packages folder? Or are they running them from the child jobs?

    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.

    July 10, 2012 at 7:44 am

    #1510919

  • RE: SQL Agent Job succeeds even though step should fail

    So far as I know, it's not possible to pass an error outside of a jobstep to cause the job itself to fail. The error is only relevant inside 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.

    July 10, 2012 at 7:30 am

    #1510907

  • RE: MSDB.dbo.sp_send_dbmail sending blank html body

    Thank you for letting us know. That will help with future questions.

    Glad you got it 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.

    July 10, 2012 at 6:20 am

    #1510859

  • RE: Today's Random Word!

    Daniel Bowlin (7/9/2012)

    Heatwave

    Heatstroke

    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.

    July 9, 2012 at 7:06 am

    #1510315

Viewing 15 posts - 4,201 through 4,215 (of 9,722 total)