Forum Replies Created

Viewing 15 posts - 706 through 720 (of 2,436 total)

  • RE: What is recommended space allocated for msdb and model?

    Definitely leave model alone. Hpwever the answer to resizing is the #1 answer in the Top 10 Things you do not want to hear from your DBA ... It depends...

  • RE: The 800lb Gorilla

    Windows Defender actually allows Gator ... there was an article or discussion about this some time ago ...

  • RE: Surface Computing

    Marketing, Marketing, Marketing.

    It is cool, but for who ? It is not a great paradigm shift, nor is it a wonderful technilogical breakthrough. Just glitz and glimmer in my opinion....

  • RE: The 800lb Gorilla

    SET CARTOON_CHARACTER_RANT_MODE OFF

  • RE: The 800lb Gorilla

    SET CARTOON_CHARACTER_RANT_MODE ON

    A picture of Magilla Gorilla being used to humorously depict MS and Google.  Tsk ... Tsk ... Tsk ... Steve, how could you even fathom taking such...

  • RE: slow down of server

    Here's my 'short list' for tuning:

    Round I

        DBCC UPDATEUSAGE

        UPDATE STATISTICS (with FULL scan) for all tables

        exec sp_recompile for all tables

        exec sp_refreshview for all views

    Round II

        DBCC DBREINDEX

       ...

  • RE: windows command help

    "net use" merely establishes and vailidates your credentials and access to the resource. You still have to copy something it appears whether you use robo-copy, xcopy or copy.

  • RE: Connection Problem with Enterprise Manager but not with Query Analyzer

    Have your 'host' check for port UDP 1434. My guess is that they closed it off by default when slammer hit a while back. That would be the difference between...

  • RE: Remove Files Older Than...

    I just want to confirm Lynn's post. This has been an extremely sporadic issue in SQL 2000. The only solution was to drop and recreate the maintenance plan.

  • RE: Error in Maintenanceplan

    Here is a solution provided to me quite some time ago for this 'issue' by MS PSS. It ias not 'elegant' but it works:

    SET ANSI_NULLS ON

    SET ANSI_PADDING ON

    SET ANSI_WARNINGS ON

    SET...

  • RE: Connection Problem with Enterprise Manager but not with Query Analyzer

    Try an uninstall/reinstall of SQL Client 'stuff' on your laptop first. If that does not work maybe there is a firewall stopping you. To check this try using telnet to...

  • RE: Idiosyncrasy

    Karma, I guess that you idiosyncrasy is long-windedness ...

  • RE: Burnt Out

    There is only one thing that you can change about the weather - that is how you perceive it. Being 'burnt out' is the same thing. Do not say or think...

  • RE: Idiosyncrasy

    I mix corn, mashed potatoes and butter together or baked beans, mashed potatoes and ground black pepper together. It is not because I was raised that way I just found out that...

  • RE: More xp_cmdshell - Proxy Server

    ahhh ,...but you can check your windows account to see if it has administrator authority ...

     

    xp_logininfo 'domain\username'

Viewing 15 posts - 706 through 720 (of 2,436 total)