Forum Replies Created

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

  • 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

  • RE: Service Account - SQL service configuration Manager

    Is there a problem with restarting SQL Agent? (which is required when you change accounts).

    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 6:28 am

    #1359157

  • RE: Which book to study

    You'll want to start posting in the Certification thread to get answers. But just an FYI: No SQL 2005 exams are open anymore. They all closed in June. The only...

    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 6:26 am

    #1359154

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

    Lowell (7/27/2011)

    Riskworks (7/26/2011)

    I have a SP that returns a table variable. It compiles and runs with no issues.

    When I call it from another Proc I get an error saying...

    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 6:21 am

    #1359147

  • RE: remove last character from string

    Look into the Patindex and Charindex functions (you can find them in Books Online by searching for those keywords). You can use those to determine where the @ is, then...

    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 6:15 am

    #1359141

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