Question about installation of SQL Sever


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: Question about installation of SQL Sever

  1. #1
    Yan Guest

    Question about installation of SQL Sever


    Is there any way to create 2 database ( one is case sensitive, the other is
    case insensitive) in one Sever in SQL Sever 2000?

    Thanks.

  2. #2
    Glynne Guest

    Re: Question about installation of SQL Sever


    Sure.
    Just specify the COLLATION name you want. It is in the drop down in EM or
    use the COLLATION statement as part of the CREATE DATABASE.

    Glynne

    "Yan" <hlin@mathsoft.com> wrote:
    >
    >Is there any way to create 2 database ( one is case sensitive, the other

    is
    >case insensitive) in one Sever in SQL Sever 2000?
    >
    >Thanks.



  3. #3
    Yan Guest

    Re: Question about installation of SQL Sever


    Thanks for you info.
    I was confused.
    My understanding is that once you set the Collation setting when doing installation,
    changing it will need exporting data and importing data.
    How can you specify the COLLATION? And where?
    Could you please explain this in a little bit detail?
    Thanks.


    "Glynne" <smithgly@nabisco.com> wrote:
    >
    >Sure.
    >Just specify the COLLATION name you want. It is in the drop down in EM or
    >use the COLLATION statement as part of the CREATE DATABASE.
    >
    >Glynne
    >
    >"Yan" <hlin@mathsoft.com> wrote:
    >>
    >>Is there any way to create 2 database ( one is case sensitive, the other

    >is
    >>case insensitive) in one Sever in SQL Sever 2000?
    >>
    >>Thanks.

    >



  4. #4
    DaveSatz Guest

    Re: Question about installation of SQL Sever

    that's was true prior to SQL 2000
    "Yan" <hlin@mathsoft.com> wrote in message news:3b978029$1@news.devx.com...
    >
    > Thanks for you info.
    > I was confused.
    > My understanding is that once you set the Collation setting when doing

    installation,
    > changing it will need exporting data and importing data.
    > How can you specify the COLLATION? And where?
    > Could you please explain this in a little bit detail?
    > Thanks.
    >
    >
    > "Glynne" <smithgly@nabisco.com> wrote:
    > >
    > >Sure.
    > >Just specify the COLLATION name you want. It is in the drop down in EM or
    > >use the COLLATION statement as part of the CREATE DATABASE.
    > >
    > >Glynne
    > >
    > >"Yan" <hlin@mathsoft.com> wrote:
    > >>
    > >>Is there any way to create 2 database ( one is case sensitive, the other

    > >is
    > >>case insensitive) in one Sever in SQL Sever 2000?
    > >>
    > >>Thanks.

    > >

    >




  5. #5
    Yan Guest

    Re: Question about installation of SQL Sever


    Thanks all. I think I figure out how to do it.
    Acturally, I really want to do here is to update a case-sensitive database
    from version 7 to sql 2000(default collation is case-insensitive).
    SQL Sever 2000 really saves my world.

    "DaveSatz" <davidNOSPAMsatz@yahoo.com> wrote:
    >that's was true prior to SQL 2000
    >"Yan" <hlin@mathsoft.com> wrote in message news:3b978029$1@news.devx.com...
    >>
    >> Thanks for you info.
    >> I was confused.
    >> My understanding is that once you set the Collation setting when doing

    >installation,
    >> changing it will need exporting data and importing data.
    >> How can you specify the COLLATION? And where?
    >> Could you please explain this in a little bit detail?
    >> Thanks.
    >>
    >>
    >> "Glynne" <smithgly@nabisco.com> wrote:
    >> >
    >> >Sure.
    >> >Just specify the COLLATION name you want. It is in the drop down in EM

    or
    >> >use the COLLATION statement as part of the CREATE DATABASE.
    >> >
    >> >Glynne
    >> >
    >> >"Yan" <hlin@mathsoft.com> wrote:
    >> >>
    >> >>Is there any way to create 2 database ( one is case sensitive, the other
    >> >is
    >> >>case insensitive) in one Sever in SQL Sever 2000?
    >> >>
    >> >>Thanks.
    >> >

    >>

    >
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center