Post reply

"Null"

  • November 27, 2005 at 10:36 pm

    #110389

    1. What does this means: The default login should be set to “NULL”.? Is there any configuration for default login. What are the userID for Default users?

    2. What are the risks if MODEL which is a default SQL database is not remove from the SQL server?

    PLease advice.

    many many Thanks X)

  • November 29, 2005 at 1:53 pm

    #606539

    Zivx,

    2. The MODEL database is a database used by sql to create other databases. It is a system database, Please do NOT remove it.

    Cheers

    G

     

  • November 29, 2005 at 4:27 pm

    #606583

    For #1 please give the SQL that produced the informational/error message.

    For #2, quite simply stated, "SQL Server will not run <period>"

    The model database is used to create all databases, and the tempdb database is recreated based on the model database every time SQL Server is started. No model database means no tempdb database which in turn means no running instance of SQL Server.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • November 29, 2005 at 6:17 pm

    #606600

    Many thanks x)!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply