Forum Replies Created

Viewing 15 posts - 4,936 through 4,950 (of 9,722 total)

  • RE: Are the posted questions getting worse?

    At the risk of being virtually lynched, I can see the use in underscores in table names and especially in constraint names.

    I shall now run away and hide before anyone...

    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 6, 2012 at 8:32 am

    #1429666

  • RE: SA Password Unknown

    AHA! Try using square brackets around the login name:

    http://blog.sqlauthority.com/2008/12/24/sql-server-disable-and-enable-user-sa/%5B/url%5D

    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 6, 2012 at 8:26 am

    #1429662

  • RE: Time dimension

    Here's a link to Books Online for creating tables in SQL Server:

    http://msdn.microsoft.com/en-us/library/ms174979.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.

    January 6, 2012 at 8:23 am

    #1429660

  • RE: Time dimension

    Delario (1/6/2012)

    so far I have created the table base on your advice, and my time table looks likes this:

    CREATE TABLE "DIM_TIME"

    (

    "TIME_KEY" NUMBER,

    ...

    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 6, 2012 at 8:21 am

    #1429657

  • RE: SA Password Unknown

    Are you logged in as a local admin / sysadmin when trying to make this change? If you read the entry, it says "local admin" must grant normal users permissions,...

    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 6, 2012 at 8:19 am

    #1429655

  • RE: Time dimension

    You create it the same way you would create a normal table, only you populate it with dates and date parts, depending on your needs.

    Do you need to keep...

    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 6, 2012 at 6:49 am

    #1429600

  • RE: SA Password Unknown

    What authentication are you using? Mixed Mode or Windows?

    SQL Express has a default of disabling the SA account in Windows authentication mode per MS: http://msdn.microsoft.com/en-US/library/ms345154(v=SQL.90).aspx

    ...

    The SA or System Admin account...

    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 6, 2012 at 5:50 am

    #1429568

  • RE: Today's Random Word!

    Paranoia

    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 6, 2012 at 5:05 am

    #1429559

  • RE: Are the posted questions getting worse?

    Evil Kraig F (1/5/2012)

    One of the things we almost have to discuss is issues and problems. The trick is who are you throwing under the bus when you discuss...

    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 6, 2012 at 4:45 am

    #1429555

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (1/5/2012)

    Speaking of venting vaguely, don't you just love when there's a third party tool (maybe even made by another group in your company) with a database you can'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 6, 2012 at 4:41 am

    #1429553

  • RE: Are the posted questions getting worse?

    This is an interesting twist for me. I think I've finally found myself in a freedom of speech vs. responsible employee situation. I've never been here before.

    We're having a discussion...

    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 5, 2012 at 11:43 am

    #1429265

  • RE: Are the posted questions getting worse?

    I don't know if anyone's posted this or not (my memory fails me after working a 22 hour shift):

    "Whatta ya mean it's 2012? I'm not done with 2011 yet. Bring...

    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 5, 2012 at 11:14 am

    #1429234

  • RE: Are the posted questions getting worse?

    Cadavre (1/5/2012)

    Brandie Tarvin (1/5/2012)

    Does anyone else have issues with the Edit Signature page on the control panel? It only ever shows 1 line of the .sig in the edit window...

    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 5, 2012 at 9:15 am

    #1429104

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (1/5/2012)

    I have some research, I have found a lot of items that are REAL match in the same store I bought them in in the first place. 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.

    January 5, 2012 at 9:04 am

    #1429087

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (1/5/2012)

    Brandie, maybe it's time to edit your sig!

    Come see me at A-Kon 22 for the launch of "The Ladies of Trade Town"! June 11th, 2011

    I don't see 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 5, 2012 at 8:57 am

    #1429085

Viewing 15 posts - 4,936 through 4,950 (of 9,722 total)