Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

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

    After much work this fixed the issue

    use tempdb

    dbcc shrinkfile ('tempdev',7)

    dbcc shrinkfile ('templog',7)

    USE MASTER

    GO

    ALTER DATABASE tempdb

    MODIFY FILE (NAME = tempdev,

    SIZE=2000 MB,

    FILENAME = 'D:\MSSQL.1\MSSQL\Data\tempdb.mdf')

    GO

    ALTER DATABASE tempdb

    MODIFY FILE (NAME = templog,

    SIZE = 1000...

  • RE: Easy Listening

    This is rather a short set of music from 5 Icons of music history!!!

    Miles Davis - In A Silent Way

    Frank Zappa - Hot Rats

    John Coltrane - My Favorite Things

    Steely Dan...

Viewing 2 posts - 1 through 2 (of 2 total)