RE: Advice on Create a SQL Server

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Linchi,

Thanks for your input.

I read about collation, but I didn't quite understand what collation is.
Can you tell me what collation is and what I need to have for collation
requirements?

Are there anything else that I need to look for or to communicate with IT?

Thanks.

"Linchi Shea" wrote:

Hopefully, you have communicated your collation requirement to your IT. You
don't want them just to create the instance with whatever assumption they may
have about the default collation if there is a chance that is not what you
want.

Linchi

"Accesshelp" wrote:

Hello all,

After lunch today, I will meet with our IT department to have a discussion
on creating a new SQL Server instance. We already have instances in our
server, and the IT will create a new instance for my databases. I have never
created a SQL Server before, and I don't know what to look for. It will be
SQL Server 2005.

I have read materials from SQL Server 2005 Books Online and from SQL Server
2005 Bible by Paul Nielsen about setting up SQL Server. However, they do not
discuss things that I need to know when I work with IT department.

From my understanding, IT will create an instance (a shell) for me with
basic setups and basic securities. I will then create databases in the
instance.

Can you guys share some items that I need to mention during the meeting in
case IT misses or so that I won't act like I do not know anything?

Thanks.
.

Relevant Pages

  • Re: Different Collation designator Settings
    ... You can have databases with different collations on SQL ... That wasn't possible on SQL Server 7. ... values in temporary tables while assuming that tempdb has the same collation ...
    (microsoft.public.sqlserver.odbc)
  • Re: Different Collation designator Settings
    ... You can have databases with different collations on SQL ... That wasn't possible on SQL Server 7. ... values in temporary tables while assuming that tempdb has the same collation ...
    (microsoft.public.sqlserver.connect)
  • Re: Different Collation designator Settings
    ... You can have databases with different collations on SQL ... That wasn't possible on SQL Server 7. ... values in temporary tables while assuming that tempdb has the same collation ...
    (microsoft.public.sqlserver.server)
  • Re: Different Collation designator Settings
    ... You can have databases with different collations on SQL ... That wasn't possible on SQL Server 7. ... values in temporary tables while assuming that tempdb has the same collation ...
    (microsoft.public.sqlserver.setup)
  • RE: Advice on Create a SQL Server
    ... Use the default collation. ... domain, and running on a windows domain account, it is better to run under ... Windows Authentication mode. ... to SQL Server using a username/password. ...
    (microsoft.public.sqlserver.setup)