Forum Replies Created

Viewing 15 posts - 8,986 through 9,000 (of 9,725 total)

  • RE: Data Modelers - Alternatives to Erwin

    Really?

    Hmmm. Looks like ER/Studio merits a second look from me. I'm one of those poor souls whose job it is to wade through all that documentation and 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.

  • RE: The Easy Poll

    Matt Miller said:

    They put the hot fix out with the warning WHILE they're incorporating it into the next service pack. Doesn't help the timing problem through...

    Use SQLServerCentral;

    GO

    Set Rant_Warning ThisThread On;

    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.

  • RE: The Easy Poll

    YesYesYesYesYES... On both.

    How many times have we gone out to the websites looking for the solution to a problem and seen the line "This fix is only for X problem,...

    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.

  • RE: Data Modelers - Alternatives to Erwin

    IMHO, both are better than Visio. Visio just doesn't have the toolset to do all the things I want it to do.

    I've only looked at ER/Studio for about 5...

    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.

  • RE: The SQL * Wildcard

    Matt,

    I like that one! Of course, it doesn't work if the table doesn't actually exist in the database you've got the query editor set at (forgot to change over...

    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.

  • RE: The SQL * Wildcard

    Neat trick to get around not knowing column names...

    Select Distinct sc.Name + ', '

    from sys.objects so

    join sys.columns sc

    on so.Object_ID = sc.Object_ID

    where so.Name = 'MyTable'

    Cut & Paste the result set...

    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.

  • RE: Data Modelers - Alternatives to Erwin

    What version are you guys using that ER/Studio converts Erwin? And what type of files have you saved in Erwin that makes the conversion so easy?

    When I tried 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.

  • RE: Would you use sql_variant?

    Actually, Lynn, I've only given you a small portion of the entire piece, so that might be why you're having problems with it.

    I've decided to go with the four individual...

    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.

  • RE: Data Modelers - Alternatives to Erwin

    Actually, my problem may be resolved. I thought we weren't going to be able to get the latest version of Erwin, but now I'm hearing differently.

    Here's hoping! @=)

    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.

  • RE: List of SQL 2005 features incompatible with level 80?

    Yes, this thread was hijacked by smk for different questions.

    s.rich, did you get your question answered?

    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.

  • RE: Send SQLReport Snapshot through email (database mail)

    Have you tried testing this report with your own internal email address? It might be you're having problems because you're trying to send the report to an external address.

    I'm...

    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.

  • RE: I am so depressed after I work on Question of the Day

    That's an old Customer Service / Retail adage too. You never tell your customer "I don't know" or risk losing their business. You always make an effort 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.

  • RE: List of SQL 2005 features incompatible with level 80?

    Let us know how that works for 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.

  • RE: Job failed:The owner does not have server access.

    Hmm. I just went and looked at the Group name that we're using for our jobs. In MSDB, this group has Public, RSExecRole, SQLAgentOperatorRole, SQLAgentReaderRole and SQLAgentUserRole all...

    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.

  • RE: Job failed:The owner does not have server access.

    DB_Owner shouldn't matter. You are correct in assuming that SysAdmin will override that. I was worried about possible DENY permissions getting into the mix. Maybe there are...

    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.

Viewing 15 posts - 8,986 through 9,000 (of 9,725 total)