Forum Replies Created

Viewing 15 posts - 7,126 through 7,140 (of 9,720 total)

  • RE: Bundle/Group data elements linked in M-M table

    Kaj,

    Did you understand my comments about how to recode for the simple solution?

    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.

    October 21, 2010 at 7:50 am

    #1240320

  • RE: SQL Server Agent service can not start

    But do you see other errors before that which might be connected to the restart fail?

    John makes a good point about the log file. Find out what service SQL Agent...

    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.

    October 21, 2010 at 7:01 am

    #1240268

  • RE: Today's Random Word!

    bleary

    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.

    October 21, 2010 at 6:58 am

    #1240263

  • RE: SSIS Mapping documentation

    I think Computer Associates might have a tool too, but I don't know the name of it off the top of my head. Might look at Pragmatic Works. I don'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.

    October 21, 2010 at 6:13 am

    #1240224

  • RE: SQL Server Agent service can not start

    Check the Application and System logs in Event Viewer. That might help you track down the source of the issue.

    Is this a standalone server or a clustered node?

    Is this a...

    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.

    October 21, 2010 at 5:56 am

    #1240214

  • RE: Bulk Insert Error: Linked Server "(null)"

    Thanks, Chris. That does help.

    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.

    October 21, 2010 at 5:54 am

    #1240213

  • RE: How to Display SQL services account information using TSQL

    If you're looking for items outside of SQL Server entirely, that's not only a registry issue, but a possible Active Directory issue. There is no way for to use T-SQL...

    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.

    October 21, 2010 at 5:37 am

    #1240204

  • RE: transactions during full backup

    What Sag999 said. It depends on what transactions get committed and written to the data file during the backup, if any.

    And if your database backup is taking two hours, 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.

    October 21, 2010 at 5:33 am

    #1240200

  • RE: SQL Server Agent service can not start

    People are going to lynch me for this first question, but...

    When was the last time you rebooted the box?

    Has SQL Server Agent run before on this box or is...

    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.

    October 21, 2010 at 5:29 am

    #1240196

  • RE: SQL Server 2005 setup failing

    I don't know if it's the reason for this particular error message, but you do need .Net framework before you install SQL Server. In fact, you need several components 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.

    October 21, 2010 at 5:27 am

    #1240195

  • RE: sp_reset_connections - DORMANT connections

    Remember that connections are different from threads. One connection can spawn many threads.

    Which is it you're trying to control? Connections or threads?

    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.

    October 21, 2010 at 5:25 am

    #1240192

  • RE: Bundle/Group data elements linked in M-M table

    kajf (10/20/2010)

    Below query gives me all straight relations (have not created a BundleID but in this easy case I can set an unique BID per A) .

    ...

    Result:

    A3C3

    A4C4

    A4C5

    Is it a good...

    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.

    October 21, 2010 at 5:19 am

    #1240190

  • RE: Bundle/Group data elements linked in M-M table

    Kaj,

    Here's why no one's responded yet. Your question breaks down at this point.

    kajf (10/20/2010)

    I have a table AC containing two attributes A and C which have a many-many relationship. What...

    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.

    October 21, 2010 at 5:07 am

    #1240179

  • RE: Bundle/Group data elements linked in M-M table

    Do us a favor? When posting your DDL statements, remember to put quotes around string values that are to be inserted. It makes it easier on us when we don'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.

    October 21, 2010 at 5:00 am

    #1240171

  • RE: Bulk Insert Error: Linked Server "(null)"

    chris.stuart (10/21/2010)

    When I say manually, I love editing the packages outside of BIDS, and in 2008 it works much better (manual edit of the package) where as in 2005 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.

    October 21, 2010 at 4:45 am

    #1240158

Viewing 15 posts - 7,126 through 7,140 (of 9,720 total)