Forum Replies Created

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

  • 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

  • RE: Why would the same query use 2 different indexes based on date?

    RICHTER-311234 (10/20/2010)

    I have rebuilt the index and ran a updatestats full on the index I am wanting both queries to use, Just a bit at a loss as to 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 4:37 am

    #1240150

  • RE: Delete Records older than 90 days

    Could you please post your table structure and some sample data so we could verify the advice we're giving you before we give it? It's hard to help you when...

    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:33 am

    #1240148

  • RE: Can any one please guide,how to split this result,

    There are several ways to split strings in addition to the method Chris mentioned. Google "SQL Server Split Strings," choose one that seems to work, and apply that methodology 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.

    October 21, 2010 at 4:32 am

    #1240146

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

    chris.stuart (10/21/2010)

    When you select the table to be populated in the drop down list in the OLE Destination component, you have the "Name of the table or the view:", 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 4:19 am

    #1240141

  • RE: Today's Random Word!

    CirquedeSQLeil (10/20/2010)

    Ray K (10/20/2010)

    Word Code of the day . . .select cup from coffee

    where caffeine = 'high'

    You won't get any that way, try this:

    select coffee

    Into #Mug

    from Pot

    where caffeine = 'high'

    Boys,...

    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 20, 2010 at 9:02 am

    #1239748

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