Forum Replies Created

Viewing 15 posts - 5,461 through 5,475 (of 9,726 total)

  • RE: Query is not summarizing results

    I'm taking a look at this now.

    Just an FYI: Your DROP TABLE script will error out for those of us who don't have your table in our dbs. 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 28, 2011 at 4:57 am

    #1359931

  • RE: Are the posted questions getting worse?

    WhineWhine, RantRant, ComplainComplain.

    Why does morning have to come so early? Can't it wait until I wake up for real?

    [/rant]

    So, are there any pastries or donuts at the water cooler today?...

    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 28, 2011 at 4:48 am

    #1359928

  • RE: Except vs. Left Join vs. Not Exists

    Paul,

    Thank you for that post. It was very informative.

    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 28, 2011 at 4:39 am

    #1359922

  • RE: Convert() Functionality -> MS webpage error?

    Ah. Thank you for pointing that out.

    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 27, 2011 at 12:07 pm

    #1359581

  • RE: sys.objects$ (with a Dollar sign)

    I don't see either view or table called sys.objects$ (just did the Resource user db on my local dev copy).

    Lowell, make sure to rename the db before you try...

    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 27, 2011 at 11:55 am

    #1359570

  • RE: sys.objects$ (with a Dollar sign)

    Lowell (7/27/2011)

    so is that the super secret resource database? how can i select from it, if i reeeallly wanted to?

    Bad Lowell. We're not supposed to be selecting from Microsoft's secret...

    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 27, 2011 at 11:32 am

    #1359542

  • RE: Today's Random Word!

    ...but I still love you guys. @=)

    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 27, 2011 at 11:10 am

    #1359518

  • RE: Today's Random Word!

    Spam.

    This thread and The Thread are killing my inbox!

    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 27, 2011 at 11:10 am

    #1359516

  • RE: sp_send_dbmail

    An ANSI character set is a set of numbers that represent every letter in the alphabet and every number from 0-9. They also represent punctuation marks, spaces, tabs, line breaks,...

    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 27, 2011 at 11:04 am

    #1359512

  • RE: Stored proc returning puzzling error - Invalid column name

    Glad we could help. And very glad it wasn't something worse.

    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 27, 2011 at 10:55 am

    #1359505

  • RE: select SERVERPROPERTY('COLLATION')

    chandan_jha18 (7/27/2011)

    Lowell (7/27/2011)

    based on this ms doc, where changing the server collation requires a rebuild:

    http://msdn.microsoft.com/en-us/library/ms179254.aspx,

    i'm guessing that the server collation is actually the collation of the resource database, regardless...

    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 27, 2011 at 7:22 am

    #1359227

  • RE: Query is not summarizing results

    Could you clarify what you're looking for in the result set. As you can see from the back-n-forth here, we all have different thoughts about what you're looking for.

    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 27, 2011 at 7:19 am

    #1359222

  • RE: Today's Random Word!

    bopeavy (7/27/2011)

    Ray K (7/27/2011)

    WOTD: coffee

    Tea

    Green

    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 27, 2011 at 7:17 am

    #1359219

  • RE: Service Account - SQL service configuration Manager

    - Win. (7/27/2011)

    If you are on Win 2003 box, you can give a try ,

    Administrative Tools -> Local Security Policy -> New window - >Local Policies -> User Rights 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 27, 2011 at 7:16 am

    #1359217

  • RE: Service Account - SQL service configuration Manager

    SQL_Surfer (7/27/2011)

    SQLServerAgent could not be started (reason: SQLServerAgent must be able to connect to SQLServer as SysAdmin,

    but '(Unknown)' is not a member of the SysAdmin role).

    Does the new 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.

    July 27, 2011 at 7:15 am

    #1359214

Viewing 15 posts - 5,461 through 5,475 (of 9,726 total)