Forum Replies Created

Viewing 15 posts - 1 through 15 (of 136 total)

  • RE: What is your default database set to?

    We have always left master as default, as no users have any permissions there, and so far no sysadmin has done any harm; but I see the point, and perhaps...

  • RE: Barcode 128 generator (using scalar function)

    The way the barcode functions work is always the same: you pass a string with the source code ('bananas') and you get the coded barcode string ( ÑbananasÈÓ, always starts...

  • RE: Service Packing

    Nothing to do with a log chain: the resource database is specific to the SQL Server Build (and I believe has to keep version in step with the master...

  • RE: Service Packing

    On startup SQL Server reports "the resource database build version" and it seems as important as ever. The main difference in SQL2008 is the location of the resource db,...

  • RE: BACKUP to share over UNC path is very slow

    Lynn Pettis (8/23/2011)


    Had a similar issue at a previous employer, turned out the port on one of the switches was set to half-duplex. Just an idea.

    That was where my...

  • RE: System Database - MODEL corrupted

    Brandie Tarvin (6/20/2011)


    Ewan Hampson (6/20/2011)


    SQL Server should have a health warning about system databases and backups

    That's what the DBCC commands and the Alert system are for.

    No argument with that,...

  • RE: System Database - MODEL corrupted

    Another yes from me. When I lost the log drive (well, Ops mis-partitioned the drives), I hunted out a running Dev copy at the same Build, stopped it and...

  • RE: System Database - MODEL corrupted

    krn045 (6/14/2011)


    Started the default instance of SQL Server normally and it started successfully. Then restored model database from recent backup.

    ...

    I have used the data & log files of model database...

  • RE: System Database - MODEL corrupted

    I recovered model when I lost a log drive by

    • start sqlserver with -T3608
    • detach model
    • stop sqlserver
    • copy good model database files into place (these may be copies from another instance of the...

  • RE: In what circumstances are there no other option than to use cursors?

    I had a recent example where a developer had created a stats-related Stored Procedure that worked through a decently formed set of joins across tables and Views, applying an update...

  • RE: SQL2005 SP4 is here

    What's with the change since the CTP?

    CTP: "Supported Operating Systems:Windows 7;Windows Server 2003;Windows Server 2008;Windows Vista"

    RTM: "Supported Operating Systems:Windows 7;Windows Server 2008;Windows Server 2008 R2;Windows Vista"

    The readme seems...

  • RE: Where a Rose is not a rose…

    Unless we can devise special sounds for curly brackets (open and close), semi-colons and maybe an altered intonation for upper-case

    Not sure about upper/lower case, but Victor Borge's phonetic punctuation could...

  • RE: Green connected icon !

    This may be a problem with WMI permissions. See if it makes a difference if you apply the changes detailed in the link.

  • RE: No More NULL

    Good one!

    But surely it's more likely we'll see a new "Known Null", to contrast with "Unknown Null"....

  • Viewing 15 posts - 1 through 15 (of 136 total)