how to create new database in SQl Server 2000

hi
please explain how to create new database in Sql server 2000.what i do for start the starting step?:confused:Start by reading the documentation.

No, seriously.|||Create the database using this wizard (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_design_4g8p.asp), then move on to Creating and Modifying a Table (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_04_8jtx.asp).

-PatP

How to create database in runtime ??

Please explain how to create database in runtime ?

Well,

for example running a predefined SQL script which containsCREATE DATABASE statement along with others. So basically it is just running a certain set of scripts to create the database (define physicalk location etc) and its structure (tables, procs, functions etc)

Provide more information about your case if you want more precise reply.

How to create an Excel formula in a table footer?

Hello, I need some help with the generation of formulas when rendering to Excel.
Let's take a small table to explain the problem, with the columns quantity, price per article and total price. The last column is a calculated column which could look like:
=ReportItems!tbQuantity.value * ReportItems!tbPricePerArticle.value
So far no problems, this works fine and generates a correct formula in Excel. However, I also need a total value in the table footer, which gives me the total quantity and the total overall price. The values in the footer also need to be implemented as formulas, since the end user needs to get an Excel file which enables him to see the effects of changing the quantity and price per article.
How do I get this to work? On a table row basis this seems to work fine, but in the table footer there is no way that I can reference the calculated fields from the table row. I get a message that says that I can only reference report items inside the same grouping scope...
Any help is welcome, since this looks like a basic functionality that is either missing or needs to be implemented in a way that I haven't discovered yet.
Thanks,
VincentAggregate formulas are not currently implemented in the Excel renderer.
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Vincent" <Vincent@.discussions.microsoft.com> wrote in message
news:2B8C24ED-0506-4297-9EBC-9DB8C43616B6@.microsoft.com...
> Hello, I need some help with the generation of formulas when rendering to
Excel.
> Let's take a small table to explain the problem, with the columns
quantity, price per article and total price. The last column is a calculated
column which could look like:
> =ReportItems!tbQuantity.value * ReportItems!tbPricePerArticle.value
> So far no problems, this works fine and generates a correct formula in
Excel. However, I also need a total value in the table footer, which gives
me the total quantity and the total overall price. The values in the footer
also need to be implemented as formulas, since the end user needs to get an
Excel file which enables him to see the effects of changing the quantity and
price per article.
> How do I get this to work? On a table row basis this seems to work fine,
but in the table footer there is no way that I can reference the calculated
fields from the table row. I get a message that says that I can only
reference report items inside the same grouping scope...
> Any help is welcome, since this looks like a basic functionality that is
either missing or needs to be implemented in a way that I haven't discovered
yet.
> Thanks,
> Vincent
>|||Is this planned for the next release or update (SP2)?
"Chris Hays [MSFT]" wrote:
> Aggregate formulas are not currently implemented in the Excel renderer.
> --
> This post is provided 'AS IS' with no warranties, and confers no rights. All
> rights reserved. Some assembly required. Batteries not included. Your
> mileage may vary. Objects in mirror may be closer than they appear. No user
> serviceable parts inside. Opening cover voids warranty. Keep out of reach of
> children under 3.
> "Vincent" <Vincent@.discussions.microsoft.com> wrote in message
> news:2B8C24ED-0506-4297-9EBC-9DB8C43616B6@.microsoft.com...
> > Hello, I need some help with the generation of formulas when rendering to
> Excel.
> >
> > Let's take a small table to explain the problem, with the columns
> quantity, price per article and total price. The last column is a calculated
> column which could look like:
> > =ReportItems!tbQuantity.value * ReportItems!tbPricePerArticle.value
> >
> > So far no problems, this works fine and generates a correct formula in
> Excel. However, I also need a total value in the table footer, which gives
> me the total quantity and the total overall price. The values in the footer
> also need to be implemented as formulas, since the end user needs to get an
> Excel file which enables him to see the effects of changing the quantity and
> price per article.
> >
> > How do I get this to work? On a table row basis this seems to work fine,
> but in the table footer there is no way that I can reference the calculated
> fields from the table row. I get a message that says that I can only
> reference report items inside the same grouping scope...
> >
> > Any help is welcome, since this looks like a basic functionality that is
> either missing or needs to be implemented in a way that I haven't discovered
> yet.
> >
> > Thanks,
> > Vincent
> >
>
>|||No. It is on our wishlist for some future version, but there are no
immediate plans to implement it.
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Vincent" <Vincent@.discussions.microsoft.com> wrote in message
news:4C49ABA5-825A-4758-AE88-5A00CD828D73@.microsoft.com...
> Is this planned for the next release or update (SP2)?
>
> "Chris Hays [MSFT]" wrote:
> > Aggregate formulas are not currently implemented in the Excel renderer.
> >
> > --
> > This post is provided 'AS IS' with no warranties, and confers no rights.
All
> > rights reserved. Some assembly required. Batteries not included. Your
> > mileage may vary. Objects in mirror may be closer than they appear. No
user
> > serviceable parts inside. Opening cover voids warranty. Keep out of
reach of
> > children under 3.
> > "Vincent" <Vincent@.discussions.microsoft.com> wrote in message
> > news:2B8C24ED-0506-4297-9EBC-9DB8C43616B6@.microsoft.com...
> > > Hello, I need some help with the generation of formulas when rendering
to
> > Excel.
> > >
> > > Let's take a small table to explain the problem, with the columns
> > quantity, price per article and total price. The last column is a
calculated
> > column which could look like:
> > > =ReportItems!tbQuantity.value * ReportItems!tbPricePerArticle.value
> > >
> > > So far no problems, this works fine and generates a correct formula in
> > Excel. However, I also need a total value in the table footer, which
gives
> > me the total quantity and the total overall price. The values in the
footer
> > also need to be implemented as formulas, since the end user needs to get
an
> > Excel file which enables him to see the effects of changing the quantity
and
> > price per article.
> > >
> > > How do I get this to work? On a table row basis this seems to work
fine,
> > but in the table footer there is no way that I can reference the
calculated
> > fields from the table row. I get a message that says that I can only
> > reference report items inside the same grouping scope...
> > >
> > > Any help is welcome, since this looks like a basic functionality that
is
> > either missing or needs to be implemented in a way that I haven't
discovered
> > yet.
> > >
> > > Thanks,
> > > Vincent
> > >
> >
> >
> >

How to create a new schema

How can I create a new schema inside a database from Managment studio express.

Also can someone explain me the concept of schema clearly. If database is like a house, then is schema like a room in it ?

if you use the metaphor House, you could say that the house is the database, the appartments are the schemas, though they can be owned by someone on have kinds of objects in them (tables, views --> rooms). If the owner of the appartment or the actual person who rent the appartment wants to quit the contract, you will first have to find another owner / contract partner vefore moving out of the appartment.

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

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Thanks. Have another question. When we create a new schema is some part of database memory allocated to it and hence having too many schemas... leads to memory fragmentation problems and hence not efficient ?