Forum Replies Created

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

  • RE: Drop and recreate vs alter stored procedure

    I'll have to check into that myself. I never bothered to look and we do need that info.

    Thanks, Lynn & Grant.

    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 28, 2010 at 8:35 am

    #1158986

  • RE: Tempdb GROWS

    Your best bet is to run a day long session of Profiler and PerfMon to identify your issues.

    Or have both run sample traces every X number of minutes. But that's...

    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 28, 2010 at 5:21 am

    #1158774

  • RE: Tempdb GROWS

    2cams (4/28/2010)

    MANU-J. your query gives me NULL in all the rows listed ...

    If you're getting NULLS, there's not a whole lot happening. But just an FYI, MANU-J is using an...

    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 28, 2010 at 4:19 am

    #1158752

  • RE: Job Failed

    The maintenance plans will always look in the system tables for backup file names when cleaning up old data. The only way to delete old backups without affecting the system...

    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 28, 2010 at 4:14 am

    #1158751

  • RE: Just a doubt

    I know a SAN admin who holds on to information like a Scottish miser holds on to money. Anytime he's asked a question about setup, his first response is "Why?...

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

    #1158276

  • 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

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