creating a server instance on SQL server 2005 enterprise

I got sql 2000 installed on my machine. I got a sql 2000 database instance on my computer and I installed sql 2005 server enterprise but I have got no server instance from sql 2005 like what i have in sql 2000 when i first install, i can have an own server instance on my computer.

is it becos when i have a previous sql 2000 server instance on my computer?

Your SQL server 2000 is probably installed as the 'default' instance. You can keep the default instance at version 2000, and install a 'named' instance for 2005. Or upgrade your default instance to 2005.

Look for the screen during setup that asks (radio buttons)

1) default instance, or

2) named instance. (to create a new named instance you need to type in a name for the instance)

|||how do i install a named instance? i need to uninstall sql 2005?|||i tried upgrading but the sql 2000 instance has errors when upgrading...|||i dun have the adventure works database....only northwind in sql 2000|||

You can create several named instances on the same computer, so you don't need to uninstall. (you can have 50 named instances with enterprise version)

To create a named instance from the command line you can type this: (this is a single command)

start /wait setup.exe /qb INSTANCENAME=brohans ADDLOCAL=SQL_Engine,Client_Components,SQLXML SAPWD=b2r0o0h6ans

Or use the setup interface and select the radio button for a named instance then type in brohans for the instance name.

|||

i install the adventureworks database....in my sql 2005

this article is helpful.

http://msdn2.microsoft.com/en-us/library/ms143804.aspx

Creating a new shell db

I have MSDE installed on a WinXP laptop. How do I create a shell db
without an Enterprise Manager?
hi Robert,
"Robert" <robert@.nospam.com> ha scritto nel messaggio
news:%23$JCQkQPEHA.640@.TK2MSFTNGP12.phx.gbl...
> I have MSDE installed on a WinXP laptop. How do I create a shell db
> without an Enterprise Manager?
you can use the command line client tool oSql.exe as described in
http://support.microsoft.com/default...;EN-US;q325003 , you can
write your own tool or use third parties tools as those provided in
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
hth
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea Montanari woke up on Tue, 18 May 2004 19:35:53 GMT and sat in
microsoft.public.sqlserver.msde writing in message news:2gv6spF779uqU1
@.uni-berlin.de

> hi Robert,
> "Robert" <robert@.nospam.com> ha scritto nel messaggio
> news:%23$JCQkQPEHA.640@.TK2MSFTNGP12.phx.gbl...
> you can use the command line client tool oSql.exe as described in
> http://support.microsoft.com/default...;EN-US;q325003 , you
can
> write your own tool or use third parties tools as those provided in
> http://www.microsoft.com/sql/msde/partners/default.asp and/or
> http://www.aspfaq.com/show.asp?id=2442
> hth
thank you Andrea, I ran across your DBAMgr2k and am using that.

Creating a diagram automatically through Enterprise Manager

Hi all,
I'm wondering, is there any way to have SQL Server automatically generate
a diagram via Enterprise Manager?
The situation is, I have created a database by executing a big as script
of SQL. The script created the tables and views and added the primary key
constraints etc. However there isnt a diagram available to help me understan
d
the schema a bit easier.
Is there some way to have Enterprise Manager interpret the schema and the
constraints and reverse engineer a pretty diagram for me?
Thanks to anyone who can advise
Kindest Regards
tce
Kindest Regards
tceIsn't it as easy as creating a new Diagram and adding all the tables?
Not to belittle the task, but the wizard is pretty good? It isn't the
automated approach but works none the less.
Clint Hill
H3O Software
http://www.h3osoftware.com
thechaosengine wrote:
> Hi all,
> I'm wondering, is there any way to have SQL Server automatically
> generate a diagram via Enterprise Manager?
> The situation is, I have created a database by executing a big as script
> of SQL. The script created the tables and views and added the primary
> key constraints etc. However there isnt a diagram available to help me
> understand the schema a bit easier.
> Is there some way to have Enterprise Manager interpret the schema and
> the constraints and reverse engineer a pretty diagram for me?
> Thanks to anyone who can advise
> Kindest Regards
> tce
> Kindest Regards
> tce
>|||Hi Clint
Thanks for your reply. You are quite right, the wizard does generate the
diagram! I must confess to being a bit stupid here. I normally use Access
connected to SQL Server to develop the database and access doesn't have quit
e
the same functionality in this regard. I actually assumed that the diagramin
g
features were identical. They certainly seem very similar.
Thanks for your help!
Kindest Regards
tce
[vbcol=seagreen]
> Isn't it as easy as creating a new Diagram and adding all the tables?
> Not to belittle the task, but the wizard is pretty good? It isn't the
> automated approach but works none the less.
> Clint Hill
> H3O Software
> http://www.h3osoftware.com
> thechaosengine wrote:
>

Creating a diagram automatically through Enterprise Manager

Hi all,
I'm wondering, is there any way to have SQL Server automatically generate
a diagram via Enterprise Manager?
The situation is, I have created a database by executing a big as script
of SQL. The script created the tables and views and added the primary key
constraints etc. However there isnt a diagram available to help me understand
the schema a bit easier.
Is there some way to have Enterprise Manager interpret the schema and the
constraints and reverse engineer a pretty diagram for me?
Thanks to anyone who can advise
Kindest Regards
tce
Kindest Regards
tce
Isn't it as easy as creating a new Diagram and adding all the tables?
Not to belittle the task, but the wizard is pretty good? It isn't the
automated approach but works none the less.
Clint Hill
H3O Software
http://www.h3osoftware.com
thechaosengine wrote:
> Hi all,
> I'm wondering, is there any way to have SQL Server automatically
> generate a diagram via Enterprise Manager?
> The situation is, I have created a database by executing a big as script
> of SQL. The script created the tables and views and added the primary
> key constraints etc. However there isnt a diagram available to help me
> understand the schema a bit easier.
> Is there some way to have Enterprise Manager interpret the schema and
> the constraints and reverse engineer a pretty diagram for me?
> Thanks to anyone who can advise
> Kindest Regards
> tce
> Kindest Regards
> tce
>
|||Hi Clint
Thanks for your reply. You are quite right, the wizard does generate the
diagram! I must confess to being a bit stupid here. I normally use Access
connected to SQL Server to develop the database and access doesn't have quite
the same functionality in this regard. I actually assumed that the diagraming
features were identical. They certainly seem very similar.
Thanks for your help!
Kindest Regards
tce
[vbcol=seagreen]
> Isn't it as easy as creating a new Diagram and adding all the tables?
> Not to belittle the task, but the wizard is pretty good? It isn't the
> automated approach but works none the less.
> Clint Hill
> H3O Software
> http://www.h3osoftware.com
> thechaosengine wrote:

Creating a diagram automatically through Enterprise Manager

Hi all,
I'm wondering, is there any way to have SQL Server automatically generate
a diagram via Enterprise Manager?
The situation is, I have created a database by executing a big as script
of SQL. The script created the tables and views and added the primary key
constraints etc. However there isnt a diagram available to help me understand
the schema a bit easier.
Is there some way to have Enterprise Manager interpret the schema and the
constraints and reverse engineer a pretty diagram for me?
Thanks to anyone who can advise
Kindest Regards
tce
Kindest Regards
tceIsn't it as easy as creating a new Diagram and adding all the tables?
Not to belittle the task, but the wizard is pretty good? It isn't the
automated approach but works none the less.
Clint Hill
H3O Software
http://www.h3osoftware.com
thechaosengine wrote:
> Hi all,
> I'm wondering, is there any way to have SQL Server automatically
> generate a diagram via Enterprise Manager?
> The situation is, I have created a database by executing a big as script
> of SQL. The script created the tables and views and added the primary
> key constraints etc. However there isnt a diagram available to help me
> understand the schema a bit easier.
> Is there some way to have Enterprise Manager interpret the schema and
> the constraints and reverse engineer a pretty diagram for me?
> Thanks to anyone who can advise
> Kindest Regards
> tce
> Kindest Regards
> tce
>

Creating a Database

Hi. Im brand new to using SQL. I downloaded the SQL Server 2005 Trial Edition (Enterprise Evaluation Edition) and installed it. How do i create a database ? The only thing i can seem to open is the SQL Server Configuration Manager which just lets me start the Server. Did I install it wrong or open the wrong program? If someone could help I would greatly appreciate it.

you should be able to find the enterprise manager

probably you have downloaded the Express edition or

you failed to set up the database engine and the client tools

|||well how would I install those ?
|||Because neither of those were an option when installing SQL
|||try reinstalling again|||

Snyper

This should get you going....

http://msdn2.microsoft.com/en-us/library/ms233763.aspx

Patrick

|||Um, im not using Express. Im using the Trial Version, the 180 day one.
|||Did you install the client tools as well? If you did, you should be able to see Microsoft SQL Server 2005 in your Program Files which contains SQL Server Management Studio|||Yes, i missed it on the first installation. Thanks.
|||

How the hell did you get the trial version to install Enterprise Manager? Why is everything Microsoft so poorly developed

Creating a Database

Hi. Im brand new to using SQL. I downloaded the SQL Server 2005 Trial Edition (Enterprise Evaluation Edition) and installed it. How do i create a database ? The only thing i can seem to open is the SQL Server Configuration Manager which just lets me start the Server. Did I install it wrong or open the wrong program? If someone could help I would greatly appreciate it.

you should be able to find the enterprise manager

probably you have downloaded the Express edition or

you failed to set up the database engine and the client tools

|||well how would I install those ?|||Because neither of those were an option when installing SQL|||try reinstalling again|||

Snyper

This should get you going....

http://msdn2.microsoft.com/en-us/library/ms233763.aspx

Patrick

|||Um, im not using Express. Im using the Trial Version, the 180 day one.|||Did you install the client tools as well? If you did, you should be able to see Microsoft SQL Server 2005 in your Program Files which contains SQL Server Management Studio|||Yes, i missed it on the first installation. Thanks.|||

How the hell did you get the trial version to install Enterprise Manager? Why is everything Microsoft so poorly developed

create UTF-8 database using enterprise manager sqlserver2000

Friends
I know how to create a database using enterprise manager in sql server 7 or 2000.
But i want to create a database where i have to set the unicode as UTF8 for the whole database.
is it possible?
if yes, how can i do that.
thanks
sathyguySo you only want it to allow 8 bit OEM values in your database ?!?! No, that is not possible in SQL 2000.

-PatP|||thanks for your reply.
my problem is the new database which im going to create is having some 10 tables. In those 10 tables i have to insert all sorts of languages. ie., chinese, arabic, english etc.....
instead of setting the datatype of each coloumn in each table.
is there any posssibility to set it for the whole database. i mean the character set for the whole database.

thanks
sathyguy|||I think what you really want is SQL N types (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_3ss4.asp) (including NTEXT (http://msdn.microsoft.com/library/en-us/tsqlref/ts_nos-nz_0lyd.asp)) that allow you to store Unicode data.

-PatP