Showing posts with label page. Show all posts
Showing posts with label page. Show all posts

Monday, March 26, 2012

Entities

I got a problem trying to determine entities from a piece of text:
SEE ATTACHMENT (see page 3 of the attachment pls (KWEA case study))

This is what i did, but i jus want someone to tell me if it look correct or what i need to do?
Entities
 STAFF_MEMBER
 PROPERTY
 TENANT
 SERVICE
 PLACEMENT
 WAITING_LIST
 OWNER

thanks wud appreciatethank you for the lovely example database design assignment paper

i have not read it, i just glanced at it

you know, like if you're shipwrecked on a lonely island with only a volleyball for company, and you find all these wonderful packages floating ashore -- first you rescue it (saves pdf to hard drive) and then you open it at leisure

anyway, regarding your question:

Entities
 STAFF_MEMBER
 PROPERTY
 TENANT
 SERVICE
 PLACEMENT
 WAITING_LIST
 OWNER

looks like a list of entities to me, so i guess that's okay

or were you asking whether i think there might be one missing?

let me give you a big hint about how to do data modelling and database design -- you need to know the data, inside and out

study the information that is given for the assignment, all the entities are in there

:)

Friday, February 24, 2012

Enterprise Manager automatic backup

The "Schedule" checkbox on the backup page in Enterprise Manager
doesn't stay checked when I close it. All of the schedule options
revert to default values. What am I doing wrong? Otherwise, backup and
restore works fine. Running MSDE over network with Windows XP Home
Edition on all machines. Thanks.That only creates an Agent Job. For every time you open that dialog, select "schedule", a new job is
created for you.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Brian2401" <brian.nutsch@.gmail.com> wrote in message
news:1159249821.610783.70390@.m7g2000cwm.googlegroups.com...
> The "Schedule" checkbox on the backup page in Enterprise Manager
> doesn't stay checked when I close it. All of the schedule options
> revert to default values. What am I doing wrong? Otherwise, backup and
> restore works fine. Running MSDE over network with Windows XP Home
> Edition on all machines. Thanks.
>|||Thanks Tibor! -Brian
Tibor Karaszi wrote:
> That only creates an Agent Job. For every time you open that dialog, select "schedule", a new job is
> created for you.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Brian2401" <brian.nutsch@.gmail.com> wrote in message
> news:1159249821.610783.70390@.m7g2000cwm.googlegroups.com...
> > The "Schedule" checkbox on the backup page in Enterprise Manager
> > doesn't stay checked when I close it. All of the schedule options
> > revert to default values. What am I doing wrong? Otherwise, backup and
> > restore works fine. Running MSDE over network with Windows XP Home
> > Edition on all machines. Thanks.
> >

Enterprise Manager automatic backup

The "Schedule" checkbox on the backup page in Enterprise Manager
doesn't stay checked when I close it. All of the schedule options
revert to default values. What am I doing wrong? Otherwise, backup and
restore works fine. Running MSDE over network with Windows XP Home
Edition on all machines. Thanks.
That only creates an Agent Job. For every time you open that dialog, select "schedule", a new job is
created for you.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Brian2401" <brian.nutsch@.gmail.com> wrote in message
news:1159249821.610783.70390@.m7g2000cwm.googlegrou ps.com...
> The "Schedule" checkbox on the backup page in Enterprise Manager
> doesn't stay checked when I close it. All of the schedule options
> revert to default values. What am I doing wrong? Otherwise, backup and
> restore works fine. Running MSDE over network with Windows XP Home
> Edition on all machines. Thanks.
>
|||Thanks Tibor! -Brian
Tibor Karaszi wrote:[vbcol=seagreen]
> That only creates an Agent Job. For every time you open that dialog, select "schedule", a new job is
> created for you.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Brian2401" <brian.nutsch@.gmail.com> wrote in message
> news:1159249821.610783.70390@.m7g2000cwm.googlegrou ps.com...

Enterprise Manager automatic backup

The "Schedule" checkbox on the backup page in Enterprise Manager
doesn't stay checked when I close it. All of the schedule options
revert to default values. What am I doing wrong? Otherwise, backup and
restore works fine. Running MSDE over network with Windows XP Home
Edition on all machines. Thanks.That only creates an Agent Job. For every time you open that dialog, select
"schedule", a new job is
created for you.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Brian2401" <brian.nutsch@.gmail.com> wrote in message
news:1159249821.610783.70390@.m7g2000cwm.googlegroups.com...
> The "Schedule" checkbox on the backup page in Enterprise Manager
> doesn't stay checked when I close it. All of the schedule options
> revert to default values. What am I doing wrong? Otherwise, backup and
> restore works fine. Running MSDE over network with Windows XP Home
> Edition on all machines. Thanks.
>|||Thanks Tibor! -Brian
Tibor Karaszi wrote:[vbcol=seagreen]
> That only creates an Agent Job. For every time you open that dialog, selec
t "schedule", a new job is
> created for you.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Brian2401" <brian.nutsch@.gmail.com> wrote in message
> news:1159249821.610783.70390@.m7g2000cwm.googlegroups.com...

Wednesday, February 15, 2012

Enterprise Edition doesnt install the SQL server instance.

I am trying to install the SQL Server 2005 Enterprise Edition, but on the components selection page, the only options I can check are Sample Book/Docs and Tools(Business Intelligence Studio, SQL Management Studio).

Even on the advanced page, those are the only options. Everything runs with no problem, except the SQL server instance.

I checked on the SQL Server Configuration Manager, and it does not show any SQL instances installed.

I tried adding a new instance using the add/remove>change for Microsoft SQL Server 2005 by selecting the setup.exe file in the Enterprise CD, but the it has the same options. If I select the setup.exe file from my Workgroup Edition CD, the option for adding new instances works.

What should I Do?

Cant I add SQL server instances using the Enterprise Edition? I was unable to install even the first instance.

The computer I am using meets all requirements and no SQL versions have been installed yet.

Thanks for the help.

go to the tools and servers folders respectively and install the components individually,.....dunno if it works just a surmise.....also you can refer this link might be useful........

http://dumthata.com/sqlchn/articles/install/insql.htm

|||

Enterprise Edition REQUIRES a server OS.

As you can see from the chart on this page, it does NOT install on Windows XP or VISTA.