Forum Replies Created

Viewing 4 posts - 16 through 19 (of 19 total)

  • RE: Detecting Detached Databases

    Nearly...

    You need to enable XP_cmdshell beforehand

    I've also done a bit of tidying up

    ---- enable these jobs

    ---- show advanced options

    sp_configure 'show advanced options', 1;

    GO

    RECONFIGURE;

    GO

    ---- enable xp_cmdshell

    sp_configure 'xp_cmdshell', 1;

    GO

    RECONFIGURE;

    GO

    ----...

  • RE: Need work around to lower initial size and shrink database

    I have a database where the initial size was larger than required at 1500Mb

    I tried this code:

    USE master;

    GO

    ALTER DATABASE [dbname]

    MODIFY FILE

    (NAME = [logicalfilename],

    ...

  • RE: Set a Networking Goal For The Year

    I entirely agree with Andy's original idea - build your network before you need it. It helps enormously when you need to change. Out of the blue in...

  • RE: Does It Help

    When I started my current job, I had a single monitor. Company policy is for everyone to have a single monitor. But there was a spare monitor sitting...

Viewing 4 posts - 16 through 19 (of 19 total)