Forum Replies Created

Viewing 15 posts - 8,356 through 8,370 (of 9,725 total)

  • RE: principal, disconnected / In Recovery when failing over on 2005 STD cluster

    Ah, yes. You're absolutely correct on that. @=)

    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: principal, disconnected / In Recovery when failing over on 2005 STD cluster

    If it's an Active / Passive cluster, Steve, there won't be necessarily be multiple instances. One instance that swaps back and forth between the cluster as it fails is the...

    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: Logins for applications in SQL2005 across the web

    Gift Peddie (4/21/2009)


    You could do that but some of your intranet users will error out with Login failed and Null user errors because AD does not resolve Asp.net and 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.

  • RE: Logins for applications in SQL2005 across the web

    Dan,

    I'm a little confused. Are you trying to create logins on a user-by-user basis or on an application-by-application basis?

    I previously thought you were talking about the later. Now it sounds...

    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: principal, disconnected / In Recovery when failing over on 2005 STD cluster

    Mackempete (4/21/2009)


    Ahh good idea I didnt think of that! I've just checked and it is set to use the SQL network name cluster resource rather than the individual node name....

    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: Bulk Insert Task woes

    DOH!

    Ignore this problem / question, please. Sorry for wasting the bandwidth.

    The developer who created the package forgot to put the destination connection strings in the config file, so on those...

    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: principal, disconnected / In Recovery when failing over on 2005 STD cluster

    Question, do you have your mirroring looking at the literal server name for the source? Or are you using the virtual cluster name for your mirrored source?

    I'd say, at 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.

  • RE: Logins for applications in SQL2005 across the web

    Consider creating individual Domain User (plain vanilla, not admin) accounts and grouping them together in a AD Security Group. This way, you can manage all the actual group policies 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: Change multiple rows to Distinct in Data Flow Task

    All eight rows will show the same output. But package design was already completed a couple of weeks ago. I'm hoping to avoid major redesign given the dependencies on this...

    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: stored procedure resul set

    This post is in the wrong forum. It should be in the T-SQL Forum, not SSIS. Ask the moderator to move it.

    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: SSIS-Package help

    Is this a homework 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.

  • RE: Deployment of a package

    Who created the package? What permissions did they save the package with?

    It sounds like access to the package itself is restricted to a specific Username / password.

    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: Group By clause

    Matt,

    Just found a case in code I'm doing right now that failed the check because I didn't put the conditional check field in the GROUP BY.

    Create Table #Detail_REIFeed (DetREIFeedID int...

    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: Temp Jr DBA job available in Northeast Florida

    In today's economy? @=)

    Actually, though, for those of you who haven't joined PASS or LinkedIn, I've been seeing a lot of job postings coming through that group on LinkedIn. None...

    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: Reg. Upgrade Sql Server 2005 RTM to stable version

    Prakash, look at the Summary.txt error more closely. It says your versions are mismatched. The service pack won't work if your editions are different on the cluster nodes. An example...

    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,356 through 8,370 (of 9,725 total)