Forum Replies Created

Viewing 15 posts - 8,056 through 8,070 (of 9,720 total)

  • RE: Just a doubt

    Ahh. For some reason all the SANs I've come across use multiple disk controllers. I've never heard of one with only one controller, unless the SAN used logical drives 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.

    April 27, 2010 at 8:19 am

    #1158266

  • RE: Shemas(DBO, UserDefined) Security Problem with Recovered Database

    Lynn Pettis (4/27/2010)

    Sounds like all you may have restored is the production database. Did you setup the logins/users as they were setup on the hosted system? 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.

    April 27, 2010 at 8:16 am

    #1158263

  • RE: Just a doubt

    Grant Fritchey (4/27/2010)

    Brandie Tarvin (4/27/2010)

    If you have multiple physical drives, you might consider having a file on each separate drive to help with I/O. It might speed up processing 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.

    April 27, 2010 at 8:07 am

    #1158255

  • RE: Drop and recreate vs alter stored procedure

    homebrew01 (4/27/2010)

    Brandie Tarvin (4/27/2010)

    For the purposes of SDLC, Drop and Create gives you a date to which you can trace back changes that broke the proc, if something gets broken....

    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.

    April 27, 2010 at 8:04 am

    #1158252

  • RE: Linked server connection issue.

    What is Data Provider "MSDASQL"?

    I've never heard of this one before.

    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.

    April 27, 2010 at 8:02 am

    #1158249

  • RE: Job Failed

    I'm glad it's working now. Sounds like the filename was kept in a table and re-running might have cleared the cache.

    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.

    April 27, 2010 at 8:00 am

    #1158247

  • RE: Job Failed

    Well that seems to be the problem right there. The job is failing by trying to delete a file that doesn't exist.

    Perhaps you should check the job, see if...

    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.

    April 27, 2010 at 6:17 am

    #1158144

  • RE: Job Failed

    Does that file even exist? If so, is it perhaps locked by another process?

    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.

    April 27, 2010 at 6:06 am

    #1158138

  • RE: Shemas(DBO, UserDefined) Security Problem with Recovered Database

    Could be several issues. Do you have access to SSMS?

    Check to make sure the recovery actually recovered the schema and the objects involved. Check to make sure the user hasn'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.

    April 27, 2010 at 6:04 am

    #1158137

  • RE: SQL Server Reporting Service

    Create an Active Directory security group, add the users to the group, then give the group the necessary permissions. This way, when a user leaves or joins, all you have...

    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.

    April 27, 2010 at 6:01 am

    #1158135

  • RE: Drop and recreate vs alter stored procedure

    For the purposes of SDLC, Drop and Create gives you a date to which you can trace back changes that broke the proc, if something gets broken. The system tables...

    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.

    April 27, 2010 at 6:00 am

    #1158134

  • RE: Linked server connection issue.

    SQL 2k5 has dropped support for a lot of the older or "other" database types in linked server OLE DB availability. Also in SSIS, unfortunately.

    If you don't have a Teradata...

    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.

    April 27, 2010 at 5:57 am

    #1158132

  • RE: Just a doubt

    If you have multiple physical drives, you might consider having a file on each separate drive to help with I/O. It might speed up processing a bit. But this 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.

    April 27, 2010 at 5:41 am

    #1158118

  • RE: Tempdb GROWS

    2cams (4/27/2010)

    I tried to shrink the database but it wont budge.

    Why will it be this side if there is so much free space? Do you need to maintain this DB...

    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.

    April 27, 2010 at 5:38 am

    #1158115

  • RE: Where are you?

    There are probably several folks in Albany that don't frequent this group, so don't allow lack of replies to this thread to deter you from starting a local users group.

    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.

    April 27, 2010 at 4:48 am

    #1158083

Viewing 15 posts - 8,056 through 8,070 (of 9,720 total)