Estimating growth

h
how can i find the below from database
Average Record Size (KB)
Total Master Table Storage (GB
Index Storage for 1 Record
Regard
RahLook up the chapter "Estimating the size of a database" in SQL Server 2000
Books Online.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Rah" <anonymous@.discussions.microsoft.com> wrote in message
news:811C9279-BEE1-43FA-9085-B3BD63A8FC61@.microsoft.com...
hi
how can i find the below from database.
Average Record Size (KB)
Total Master Table Storage (GB)
Index Storage for 1 Record
Regards
Rah

Estimating growth

hi
how can i find the below from database.
Average Record Size (KB)
Total Master Table Storage (GB)
Index Storage for 1 Record
Regards
RahLook up the chapter "Estimating the size of a database" in SQL Server 2000
Books Online.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Rah" <anonymous@.discussions.microsoft.com> wrote in message
news:811C9279-BEE1-43FA-9085-B3BD63A8FC61@.microsoft.com...
hi
how can i find the below from database.
Average Record Size (KB)
Total Master Table Storage (GB)
Index Storage for 1 Record
Regards
Rah

ERwin

Hi,
I have just installed ERwin data modeler and can't seem to get past
the 'connection manager'. In 'Master dafatase' I have put: master but
it is saying invalid object master..m7License. I have enteretd the
license keys during installation. Do I have to make any changes in the
database too?
Thanks
It looks like the problem was either with your installation, your
configuration, or your rights. (I have not installed any of the more recent
versions of ERwin, so just things to look for.)
Installation: The installation apparently should have created the table
m7License in the master database, but perhaps that step failed.
Configuration: The table m7License was successfully created in another
database, but the ERwin application configuration does not know where the
table is.
Rights: Everything is where it should be, but you personally do not have
rights to the m7License table in master.
FWIW,
RLF
<othellomy@.yahoo.com> wrote in message
news:1175056298.365698.98030@.d57g2000hsg.googlegro ups.com...
> Hi,
> I have just installed ERwin data modeler and can't seem to get past
> the 'connection manager'. In 'Master dafatase' I have put: master but
> it is saying invalid object master..m7License. I have enteretd the
> license keys during installation. Do I have to make any changes in the
> database too?
> Thanks
>

ERwin

Hi,
I have just installed ERwin data modeler and can't seem to get past
the 'connection manager'. In 'Master dafatase' I have put: master but
it is saying invalid object master..m7License. I have enteretd the
license keys during installation. Do I have to make any changes in the
database too?
ThanksIt looks like the problem was either with your installation, your
configuration, or your rights. (I have not installed any of the more recent
versions of ERwin, so just things to look for.)
Installation: The installation apparently should have created the table
m7License in the master database, but perhaps that step failed.
Configuration: The table m7License was successfully created in another
database, but the ERwin application configuration does not know where the
table is.
Rights: Everything is where it should be, but you personally do not have
rights to the m7License table in master.
FWIW,
RLF
<othellomy@.yahoo.com> wrote in message
news:1175056298.365698.98030@.d57g2000hsg.googlegroups.com...
> Hi,
> I have just installed ERwin data modeler and can't seem to get past
> the 'connection manager'. In 'Master dafatase' I have put: master but
> it is saying invalid object master..m7License. I have enteretd the
> license keys during installation. Do I have to make any changes in the
> database too?
> Thanks
>

ERwin

Hi,
I have just installed ERwin data modeler and can't seem to get past
the 'connection manager'. In 'Master dafatase' I have put: master but
it is saying invalid object master..m7License. I have enteretd the
license keys during installation. Do I have to make any changes in the
database too?
ThanksIt looks like the problem was either with your installation, your
configuration, or your rights. (I have not installed any of the more recent
versions of ERwin, so just things to look for.)
Installation: The installation apparently should have created the table
m7License in the master database, but perhaps that step failed.
Configuration: The table m7License was successfully created in another
database, but the ERwin application configuration does not know where the
table is.
Rights: Everything is where it should be, but you personally do not have
rights to the m7License table in master.
FWIW,
RLF
<othellomy@.yahoo.com> wrote in message
news:1175056298.365698.98030@.d57g2000hsg.googlegroups.com...
> Hi,
> I have just installed ERwin data modeler and can't seem to get past
> the 'connection manager'. In 'Master dafatase' I have put: master but
> it is saying invalid object master..m7License. I have enteretd the
> license keys during installation. Do I have to make any changes in the
> database too?
> Thanks
>

Error: Subreport could not be shown 2

Hi
I have a "master" report that has 10 chart sub reports that don't have any
parameter. I get a "Error: Subreport could not be shown" error if one of
them are snapshot based.
Any ideas?
Regards,
AndresOn Apr 14, 8:12 pm, "Andres" <andresfon...@.hotmail.com> wrote:
> Hi
> I have a "master" report that has 10 chart sub reports that don't have any
> parameter. I get a "Error: Subreport could not be shown" error if one of
> them are snapshot based.
> Any ideas?
> Regards,
> Andres
You might be able to resolve this error by returning a default empty
resultset. Also, make sure that all the dependencies of the subreport
are available (i.e., if you are developing reports in a development
environment and then need to transfer them to the production
environment along w/all dependent stored procedures, tables, etc).
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi Enrique
Which report should return a default empty resultset?
And, what's a default empty resultset?
The main report don't have any resultset. I think sub reports have all they
need. They work fine when I use them directly in default mode (no snapshot)
and in snapshot mode.
Regards,
Andrés
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1176659677.215808.157620@.e65g2000hsc.googlegroups.com...
> On Apr 14, 8:12 pm, "Andres" <andresfon...@.hotmail.com> wrote:
>> Hi
>> I have a "master" report that has 10 chart sub reports that don't have
>> any
>> parameter. I get a "Error: Subreport could not be shown" error if one of
>> them are snapshot based.
>> Any ideas?
>> Regards,
>> Andres
>
> You might be able to resolve this error by returning a default empty
> resultset. Also, make sure that all the dependencies of the subreport
> are available (i.e., if you are developing reports in a development
> environment and then need to transfer them to the production
> environment along w/all dependent stored procedures, tables, etc).
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>