Multiple instances of MSDE on same server?

can I install 2 separate apps from 2 separate vendors on the same machine,
if they both use MSDE? If so, is it simply installing a separate instance
for the 2nd install? Thanks.
Greg.
r3gbrewer@.health.nb.ca
Yes, that's usually what happens. Though different vendors do it
differently. Some will detect existing instances and ask if you want to use
one of them. I also remember seeing apps that just picked an arbitrary
existing instance if it found one.
http://www.aspfaq.com/
(Reverse address to reply.)
"Greg Brewer" <r3gbrewer@.xspamhealth.nb.ca> wrote in message
news:u5kQehx1EHA.3120@.TK2MSFTNGP12.phx.gbl...
> can I install 2 separate apps from 2 separate vendors on the same machine,
> if they both use MSDE? If so, is it simply installing a separate instance
> for the 2nd install? Thanks.
> Greg.
> r3gbrewer@.health.nb.ca
>
sql

Multiple Instances - Properties tuning

Hope you don't mind another few questions about tuning this multiple
instances server.
When installing 2 separate instances on MS SQL server 2000 Sp3a, would
I best leave the configurationof server Memory to SQL server
(dynamically), or should I allocate manually say 300 MB for each
instance (Total MB RAM = 1 GB). The applications will not be heavily
used.
If I were to audit, would I benefit from only auditing failure, or
would you yourself choose to audit All or None ? Do I audit only when
necessary or all the time ?
The BOL say that this file will grow max to 200 MB and that I should
specify immediately during setup a new directory for these audit
files. I can't see where I should enter this new directory.
Is this the SQL server error log ? BOL suggests making a directory
like MSSQL$instance\audit. That would be in the data directory right ?
Where do I register this directory in SQL server as the audit
directory? Do I need to use profiler to set auditing on and off ?
In the Remote Server connections, would you deny remote RPC
connections to your SQL server or not? Why ?
For your first question, checkout the page titled "Multiple Instance
Recommendations" in SQL Server 2000 Books Online.
Regarding auting, I generally look for failures, in the SQL Errorlog.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Citizen" <citizen_NOSPAM@.hotmail.com> wrote in message
news:ogaie0tdj18cb194ubpp7vm971obqsva1j@.4ax.com...
Hope you don't mind another few questions about tuning this multiple
instances server.
When installing 2 separate instances on MS SQL server 2000 Sp3a, would
I best leave the configurationof server Memory to SQL server
(dynamically), or should I allocate manually say 300 MB for each
instance (Total MB RAM = 1 GB). The applications will not be heavily
used.
If I were to audit, would I benefit from only auditing failure, or
would you yourself choose to audit All or None ? Do I audit only when
necessary or all the time ?
The BOL say that this file will grow max to 200 MB and that I should
specify immediately during setup a new directory for these audit
files. I can't see where I should enter this new directory.
Is this the SQL server error log ? BOL suggests making a directory
like MSSQL$instance\audit. That would be in the data directory right ?
Where do I register this directory in SQL server as the audit
directory? Do I need to use profiler to set auditing on and off ?
In the Remote Server connections, would you deny remote RPC
connections to your SQL server or not? Why ?
|||Hi,
Why do you want to install mutiple instances of SQL Server since you have
only 1 GB of physical
memory in machine.
Better option will be create 2 databases and allocate 1 db for each
application.
If you need to install multiple instances of SQL Server always it is
recommended to fix the
memory usage for each instance of SQL Server. If you do not have any other
application other than
SQL Server in your machine then you can go for even 400 MB for each
instamce. THis memory parameter
should be changed based on usage of each instance. You can use Performance
monitor to identify the usage.
If I were to audit, would I benefit from only auditing failure, or
would you yourself choose to audit All or None ? Do I audit only when
necessary or all the time ?
I recommend you to audit only the failure, Otherwise you need to enable the
c2 Audit mode
which will audit all the activity. SO it uses more resources. During the
requirement stages
you can use Profiler to trace the activity.
Do I need to use profiler to set auditing on and off ?
No need, From Query Analyser execute
sp_configure 'c2 audit mode',1
To diable to audit
sp_configure 'c2 audit mode',0
(restart SQL Server service)
I can't see where I should enter this new directory.Is this the SQL server
error log ?
As far as i know,You have to change the default data directory
Thanks
Hari
MCDBA
"Citizen" <citizen_NOSPAM@.hotmail.com> wrote in message
news:ogaie0tdj18cb194ubpp7vm971obqsva1j@.4ax.com...
> Hope you don't mind another few questions about tuning this multiple
> instances server.
> When installing 2 separate instances on MS SQL server 2000 Sp3a, would
> I best leave the configurationof server Memory to SQL server
> (dynamically), or should I allocate manually say 300 MB for each
> instance (Total MB RAM = 1 GB). The applications will not be heavily
> used.
> If I were to audit, would I benefit from only auditing failure, or
> would you yourself choose to audit All or None ? Do I audit only when
> necessary or all the time ?
> The BOL say that this file will grow max to 200 MB and that I should
> specify immediately during setup a new directory for these audit
> files. I can't see where I should enter this new directory.
> Is this the SQL server error log ? BOL suggests making a directory
> like MSSQL$instance\audit. That would be in the data directory right ?
> Where do I register this directory in SQL server as the audit
> directory? Do I need to use profiler to set auditing on and off ?
> In the Remote Server connections, would you deny remote RPC
> connections to your SQL server or not? Why ?
>
|||Hi,
Why do you want to install mutiple instances of SQL Server since you have only 1 GB of physical
memory in machine.
Better option will be create 2 databases and allocate 1 db for each application.
If you need to install multiple instances of SQL Server always it is recommended to fix the
memory usage for each instance of SQL Server. If you do not have any other application other than
SQL Server in your machine then you can go for even 400 MB for each instamce. THis memory parameter
should be changed based on usage of each instance. You can use Performance monitor to identify the usage.
If I were to audit, would I benefit from only auditing failure, or
would you yourself choose to audit All or None ? Do I audit only when
necessary or all the time ?
I recommend you to audit only the failure, Otherwise you need to enable the c2 Audit mode
which will audit all the activity. SO it uses more resources. During the requirement stages
you can use Profiler to trace the activity.
Do I need to use profiler to set auditing on and off ?
No need, From Query Analyser execute
sp_configure 'c2 audit mode',1
To diable to audit
sp_configure 'c2 audit mode',0
(restart SQL Server service)
I can't see where I should enter this new directory.Is this the SQL server error log ?
As far as i know,You have to change the default data directory
Thanks
Hari
MCDBA
"Citizen" wrote:

> Hope you don't mind another few questions about tuning this multiple
> instances server.
> When installing 2 separate instances on MS SQL server 2000 Sp3a, would
> I best leave the configurationof server Memory to SQL server
> (dynamically), or should I allocate manually say 300 MB for each
> instance (Total MB RAM = 1 GB). The applications will not be heavily
> used.
> If I were to audit, would I benefit from only auditing failure, or
> would you yourself choose to audit All or None ? Do I audit only when
> necessary or all the time ?
> The BOL say that this file will grow max to 200 MB and that I should
> specify immediately during setup a new directory for these audit
> files. I can't see where I should enter this new directory.
> Is this the SQL server error log ? BOL suggests making a directory
> like MSSQL$instance\audit. That would be in the data directory right ?
> Where do I register this directory in SQL server as the audit
> directory? Do I need to use profiler to set auditing on and off ?
> In the Remote Server connections, would you deny remote RPC
> connections to your SQL server or not? Why ?
>
>
|||On Mon, 5 Jul 2004 12:03:07 +0100, "Narayana Vyas Kondreddi"
<answer_me@.hotmail.com> wrote:

>For your first question, checkout the page titled "Multiple Instance
>Recommendations" in SQL Server 2000 Books Online.
>Regarding auting, I generally look for failures, in the SQL Errorlog.
Thanks,
Just one little question : In the database settings tab from the SQL
Server Properties, you can see New databases location.
Do they mean transaction log or error log or audit log when they ask
the default log directory ? I think transaction log (LDF), is that
correct ?
|||You see two text boxes there, one for database and the other for transaction
log files.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Citizen" <citizen_NOSPAM@.hotmail.com> wrote in message
news:emlie0dba1fo913c3d1m0rrhifj12frvlv@.4ax.com...
On Mon, 5 Jul 2004 12:03:07 +0100, "Narayana Vyas Kondreddi"
<answer_me@.hotmail.com> wrote:

>For your first question, checkout the page titled "Multiple Instance
>Recommendations" in SQL Server 2000 Books Online.
>Regarding auting, I generally look for failures, in the SQL Errorlog.
Thanks,
Just one little question : In the database settings tab from the SQL
Server Properties, you can see New databases location.
Do they mean transaction log or error log or audit log when they ask
the default log directory ? I think transaction log (LDF), is that
correct ?
|||On Mon, 5 Jul 2004 14:37:13 +0100, "Narayana Vyas Kondreddi"
<answer_me@.hotmail.com> wrote:

>You see two text boxes there, one for database and the other for transaction
>log files.
thanks a million
sql

Multiple Instances - Properties tuning

Hope you don't mind another few questions about tuning this multiple
instances server.
When installing 2 separate instances on MS SQL server 2000 Sp3a, would
I best leave the configurationof server Memory to SQL server
(dynamically), or should I allocate manually say 300 MB for each
instance (Total MB RAM = 1 GB). The applications will not be heavily
used.
If I were to audit, would I benefit from only auditing failure, or
would you yourself choose to audit All or None ? Do I audit only when
necessary or all the time ?
The BOL say that this file will grow max to 200 MB and that I should
specify immediately during setup a new directory for these audit
files. I can't see where I should enter this new directory.
Is this the SQL server error log ? BOL suggests making a directory
like MSSQL$instance\audit. That would be in the data directory right ?
Where do I register this directory in SQL server as the audit
directory? Do I need to use profiler to set auditing on and off ?
In the Remote Server connections, would you deny remote RPC
connections to your SQL server or not? Why ?For your first question, checkout the page titled "Multiple Instance
Recommendations" in SQL Server 2000 Books Online.
Regarding auting, I generally look for failures, in the SQL Errorlog.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Citizen" <citizen_NOSPAM@.hotmail.com> wrote in message
news:ogaie0tdj18cb194ubpp7vm971obqsva1j@.
4ax.com...
Hope you don't mind another few questions about tuning this multiple
instances server.
When installing 2 separate instances on MS SQL server 2000 Sp3a, would
I best leave the configurationof server Memory to SQL server
(dynamically), or should I allocate manually say 300 MB for each
instance (Total MB RAM = 1 GB). The applications will not be heavily
used.
If I were to audit, would I benefit from only auditing failure, or
would you yourself choose to audit All or None ? Do I audit only when
necessary or all the time ?
The BOL say that this file will grow max to 200 MB and that I should
specify immediately during setup a new directory for these audit
files. I can't see where I should enter this new directory.
Is this the SQL server error log ? BOL suggests making a directory
like MSSQL$instance\audit. That would be in the data directory right ?
Where do I register this directory in SQL server as the audit
directory? Do I need to use profiler to set auditing on and off ?
In the Remote Server connections, would you deny remote RPC
connections to your SQL server or not? Why ?|||Hi,
Why do you want to install mutiple instances of SQL Server since you have
only 1 GB of physical
memory in machine.
Better option will be create 2 databases and allocate 1 db for each
application.
If you need to install multiple instances of SQL Server always it is
recommended to fix the
memory usage for each instance of SQL Server. If you do not have any other
application other than
SQL Server in your machine then you can go for even 400 MB for each
instamce. THis memory parameter
should be changed based on usage of each instance. You can use Performance
monitor to identify the usage.
If I were to audit, would I benefit from only auditing failure, or
would you yourself choose to audit All or None ? Do I audit only when
necessary or all the time ?
I recommend you to audit only the failure, Otherwise you need to enable the
c2 Audit mode
which will audit all the activity. SO it uses more resources. During the
requirement stages
you can use Profiler to trace the activity.
Do I need to use profiler to set auditing on and off ?
No need, From Query Analyser execute
sp_configure 'c2 audit mode',1
To diable to audit
sp_configure 'c2 audit mode',0
(restart SQL Server service)
I can't see where I should enter this new directory.Is this the SQL server
error log ?
As far as i know,You have to change the default data directory
Thanks
Hari
MCDBA
"Citizen" <citizen_NOSPAM@.hotmail.com> wrote in message
news:ogaie0tdj18cb194ubpp7vm971obqsva1j@.
4ax.com...
> Hope you don't mind another few questions about tuning this multiple
> instances server.
> When installing 2 separate instances on MS SQL server 2000 Sp3a, would
> I best leave the configurationof server Memory to SQL server
> (dynamically), or should I allocate manually say 300 MB for each
> instance (Total MB RAM = 1 GB). The applications will not be heavily
> used.
> If I were to audit, would I benefit from only auditing failure, or
> would you yourself choose to audit All or None ? Do I audit only when
> necessary or all the time ?
> The BOL say that this file will grow max to 200 MB and that I should
> specify immediately during setup a new directory for these audit
> files. I can't see where I should enter this new directory.
> Is this the SQL server error log ? BOL suggests making a directory
> like MSSQL$instance\audit. That would be in the data directory right ?
> Where do I register this directory in SQL server as the audit
> directory? Do I need to use profiler to set auditing on and off ?
> In the Remote Server connections, would you deny remote RPC
> connections to your SQL server or not? Why ?
>|||Hi,
Why do you want to install mutiple instances of SQL Server since you have on
ly 1 GB of physical
memory in machine.
Better option will be create 2 databases and allocate 1 db for each applicat
ion.
If you need to install multiple instances of SQL Server always it is recomme
nded to fix the
memory usage for each instance of SQL Server. If you do not have any other a
pplication other than
SQL Server in your machine then you can go for even 400 MB for each instamce
. THis memory parameter
should be changed based on usage of each instance. You can use Performance m
onitor to identify the usage.
If I were to audit, would I benefit from only auditing failure, or
would you yourself choose to audit All or None ? Do I audit only when
necessary or all the time ?
I recommend you to audit only the failure, Otherwise you need to enable the
c2 Audit mode
which will audit all the activity. SO it uses more resources. During the req
uirement stages
you can use Profiler to trace the activity.
Do I need to use profiler to set auditing on and off ?
No need, From Query Analyser execute
sp_configure 'c2 audit mode',1
To diable to audit
sp_configure 'c2 audit mode',0
(restart SQL Server service)
I can't see where I should enter this new directory.Is this the SQL server e
rror log ?
As far as i know,You have to change the default data directory
Thanks
Hari
MCDBA
"Citizen" wrote:

> Hope you don't mind another few questions about tuning this multiple
> instances server.
> When installing 2 separate instances on MS SQL server 2000 Sp3a, would
> I best leave the configurationof server Memory to SQL server
> (dynamically), or should I allocate manually say 300 MB for each
> instance (Total MB RAM = 1 GB). The applications will not be heavily
> used.
> If I were to audit, would I benefit from only auditing failure, or
> would you yourself choose to audit All or None ? Do I audit only when
> necessary or all the time ?
> The BOL say that this file will grow max to 200 MB and that I should
> specify immediately during setup a new directory for these audit
> files. I can't see where I should enter this new directory.
> Is this the SQL server error log ? BOL suggests making a directory
> like MSSQL$instance\audit. That would be in the data directory right ?
> Where do I register this directory in SQL server as the audit
> directory? Do I need to use profiler to set auditing on and off ?
> In the Remote Server connections, would you deny remote RPC
> connections to your SQL server or not? Why ?
>
>|||On Mon, 5 Jul 2004 12:03:07 +0100, "Narayana Vyas Kondreddi"
<answer_me@.hotmail.com> wrote:

>For your first question, checkout the page titled "Multiple Instance
>Recommendations" in SQL Server 2000 Books Online.
>Regarding auting, I generally look for failures, in the SQL Errorlog.
Thanks,
Just one little question : In the database settings tab from the SQL
Server Properties, you can see New databases location.
Do they mean transaction log or error log or audit log when they ask
the default log directory ? I think transaction log (LDF), is that
correct ?|||You see two text boxes there, one for database and the other for transaction
log files.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Citizen" <citizen_NOSPAM@.hotmail.com> wrote in message
news:emlie0dba1fo913c3d1m0rrhifj12frvlv@.
4ax.com...
On Mon, 5 Jul 2004 12:03:07 +0100, "Narayana Vyas Kondreddi"
<answer_me@.hotmail.com> wrote:

>For your first question, checkout the page titled "Multiple Instance
>Recommendations" in SQL Server 2000 Books Online.
>Regarding auting, I generally look for failures, in the SQL Errorlog.
Thanks,
Just one little question : In the database settings tab from the SQL
Server Properties, you can see New databases location.
Do they mean transaction log or error log or audit log when they ask
the default log directory ? I think transaction log (LDF), is that
correct ?|||On Mon, 5 Jul 2004 14:37:13 +0100, "Narayana Vyas Kondreddi"
<answer_me@.hotmail.com> wrote:

>You see two text boxes there, one for database and the other for transactio
n
>log files.
thanks a million

Multiple Instances - Properties tuning

Hope you don't mind another few questions about tuning this multiple
instances server.
When installing 2 separate instances on MS SQL server 2000 Sp3a, would
I best leave the configurationof server Memory to SQL server
(dynamically), or should I allocate manually say 300 MB for each
instance (Total MB RAM = 1 GB). The applications will not be heavily
used.
If I were to audit, would I benefit from only auditing failure, or
would you yourself choose to audit All or None ? Do I audit only when
necessary or all the time ?
The BOL say that this file will grow max to 200 MB and that I should
specify immediately during setup a new directory for these audit
files. I can't see where I should enter this new directory.
Is this the SQL server error log ? BOL suggests making a directory
like MSSQL$instance\audit. That would be in the data directory right ?
Where do I register this directory in SQL server as the audit
directory? Do I need to use profiler to set auditing on and off ?
In the Remote Server connections, would you deny remote RPC
connections to your SQL server or not? Why ?For your first question, checkout the page titled "Multiple Instance
Recommendations" in SQL Server 2000 Books Online.
Regarding auting, I generally look for failures, in the SQL Errorlog.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Citizen" <citizen_NOSPAM@.hotmail.com> wrote in message
news:ogaie0tdj18cb194ubpp7vm971obqsva1j@.4ax.com...
Hope you don't mind another few questions about tuning this multiple
instances server.
When installing 2 separate instances on MS SQL server 2000 Sp3a, would
I best leave the configurationof server Memory to SQL server
(dynamically), or should I allocate manually say 300 MB for each
instance (Total MB RAM = 1 GB). The applications will not be heavily
used.
If I were to audit, would I benefit from only auditing failure, or
would you yourself choose to audit All or None ? Do I audit only when
necessary or all the time ?
The BOL say that this file will grow max to 200 MB and that I should
specify immediately during setup a new directory for these audit
files. I can't see where I should enter this new directory.
Is this the SQL server error log ? BOL suggests making a directory
like MSSQL$instance\audit. That would be in the data directory right ?
Where do I register this directory in SQL server as the audit
directory? Do I need to use profiler to set auditing on and off ?
In the Remote Server connections, would you deny remote RPC
connections to your SQL server or not? Why ?|||Hi,
Why do you want to install mutiple instances of SQL Server since you have
only 1 GB of physical
memory in machine.
Better option will be create 2 databases and allocate 1 db for each
application.
If you need to install multiple instances of SQL Server always it is
recommended to fix the
memory usage for each instance of SQL Server. If you do not have any other
application other than
SQL Server in your machine then you can go for even 400 MB for each
instamce. THis memory parameter
should be changed based on usage of each instance. You can use Performance
monitor to identify the usage.
If I were to audit, would I benefit from only auditing failure, or
would you yourself choose to audit All or None ? Do I audit only when
necessary or all the time ?
I recommend you to audit only the failure, Otherwise you need to enable the
c2 Audit mode
which will audit all the activity. SO it uses more resources. During the
requirement stages
you can use Profiler to trace the activity.
Do I need to use profiler to set auditing on and off ?
No need, From Query Analyser execute
sp_configure 'c2 audit mode',1
To diable to audit
sp_configure 'c2 audit mode',0
(restart SQL Server service)
I can't see where I should enter this new directory.Is this the SQL server
error log ?
As far as i know,You have to change the default data directory
--
Thanks
Hari
MCDBA
"Citizen" <citizen_NOSPAM@.hotmail.com> wrote in message
news:ogaie0tdj18cb194ubpp7vm971obqsva1j@.4ax.com...
> Hope you don't mind another few questions about tuning this multiple
> instances server.
> When installing 2 separate instances on MS SQL server 2000 Sp3a, would
> I best leave the configurationof server Memory to SQL server
> (dynamically), or should I allocate manually say 300 MB for each
> instance (Total MB RAM = 1 GB). The applications will not be heavily
> used.
> If I were to audit, would I benefit from only auditing failure, or
> would you yourself choose to audit All or None ? Do I audit only when
> necessary or all the time ?
> The BOL say that this file will grow max to 200 MB and that I should
> specify immediately during setup a new directory for these audit
> files. I can't see where I should enter this new directory.
> Is this the SQL server error log ? BOL suggests making a directory
> like MSSQL$instance\audit. That would be in the data directory right ?
> Where do I register this directory in SQL server as the audit
> directory? Do I need to use profiler to set auditing on and off ?
> In the Remote Server connections, would you deny remote RPC
> connections to your SQL server or not? Why ?
>|||Hi,
Why do you want to install mutiple instances of SQL Server since you have only 1 GB of physical
memory in machine.
Better option will be create 2 databases and allocate 1 db for each application.
If you need to install multiple instances of SQL Server always it is recommended to fix the
memory usage for each instance of SQL Server. If you do not have any other application other than
SQL Server in your machine then you can go for even 400 MB for each instamce. THis memory parameter
should be changed based on usage of each instance. You can use Performance monitor to identify the usage.
If I were to audit, would I benefit from only auditing failure, or
would you yourself choose to audit All or None ? Do I audit only when
necessary or all the time ?
I recommend you to audit only the failure, Otherwise you need to enable the c2 Audit mode
which will audit all the activity. SO it uses more resources. During the requirement stages
you can use Profiler to trace the activity.
Do I need to use profiler to set auditing on and off ?
No need, From Query Analyser execute
sp_configure 'c2 audit mode',1
To diable to audit
sp_configure 'c2 audit mode',0
(restart SQL Server service)
I can't see where I should enter this new directory.Is this the SQL server error log ?
As far as i know,You have to change the default data directory
Thanks
Hari
MCDBA
"Citizen" wrote:
> Hope you don't mind another few questions about tuning this multiple
> instances server.
> When installing 2 separate instances on MS SQL server 2000 Sp3a, would
> I best leave the configurationof server Memory to SQL server
> (dynamically), or should I allocate manually say 300 MB for each
> instance (Total MB RAM = 1 GB). The applications will not be heavily
> used.
> If I were to audit, would I benefit from only auditing failure, or
> would you yourself choose to audit All or None ? Do I audit only when
> necessary or all the time ?
> The BOL say that this file will grow max to 200 MB and that I should
> specify immediately during setup a new directory for these audit
> files. I can't see where I should enter this new directory.
> Is this the SQL server error log ? BOL suggests making a directory
> like MSSQL$instance\audit. That would be in the data directory right ?
> Where do I register this directory in SQL server as the audit
> directory? Do I need to use profiler to set auditing on and off ?
> In the Remote Server connections, would you deny remote RPC
> connections to your SQL server or not? Why ?
>
>|||On Mon, 5 Jul 2004 12:03:07 +0100, "Narayana Vyas Kondreddi"
<answer_me@.hotmail.com> wrote:
>For your first question, checkout the page titled "Multiple Instance
>Recommendations" in SQL Server 2000 Books Online.
>Regarding auting, I generally look for failures, in the SQL Errorlog.
Thanks,
Just one little question : In the database settings tab from the SQL
Server Properties, you can see New databases location.
Do they mean transaction log or error log or audit log when they ask
the default log directory ? I think transaction log (LDF), is that
correct ?|||You see two text boxes there, one for database and the other for transaction
log files.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Citizen" <citizen_NOSPAM@.hotmail.com> wrote in message
news:emlie0dba1fo913c3d1m0rrhifj12frvlv@.4ax.com...
On Mon, 5 Jul 2004 12:03:07 +0100, "Narayana Vyas Kondreddi"
<answer_me@.hotmail.com> wrote:
>For your first question, checkout the page titled "Multiple Instance
>Recommendations" in SQL Server 2000 Books Online.
>Regarding auting, I generally look for failures, in the SQL Errorlog.
Thanks,
Just one little question : In the database settings tab from the SQL
Server Properties, you can see New databases location.
Do they mean transaction log or error log or audit log when they ask
the default log directory ? I think transaction log (LDF), is that
correct ?|||On Mon, 5 Jul 2004 14:37:13 +0100, "Narayana Vyas Kondreddi"
<answer_me@.hotmail.com> wrote:
>You see two text boxes there, one for database and the other for transaction
>log files.
thanks a million :)

Multiple DataSets

Can a single report (same layout) have multiple MATRIXES with all referring
to either SAME or SEPARATE tables with different conditions mentioned for
each matrix?
ThanksYes, you can do that. You can drop the matrixes with different datasets
directly on the report body. Matrixes inside a list need to either have the
same dataset as the list; or (if they need to have a different dataset) put
them inside a subreport on the list.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Asim" <Asim@.discussions.microsoft.com> wrote in message
news:70420480-8D78-426F-824B-BCA6F533F01B@.microsoft.com...
> Can a single report (same layout) have multiple MATRIXES with all
> referring
> to either SAME or SEPARATE tables with different conditions mentioned for
> each matrix?
> Thanks
>

Multiple databases and SQL

I am facing a problem within SQL server. Is it possible to create SQL query to two separate databases at the same time ?

There are logical relations between tables in separate databases and I need to create some JOINs between tables in separate dbs into my SQL query. I there any solutions to this problem ?is the databases are on the same server you just need to use a three part nameing convention <Database Name>.<Owner Name>.<Table Name>

So if in db1 you have a table named tbl1 owned by usr1 and in db2 you have a table named tbl2 owned by dbo you would...

select *
from db1.usr1.tbl1 t1
join db2.dbo.tbl2 t2 on t1.ParentKey = t2.ChildKey|||On the same server?
If so, just do a
select * from database1.owner1.table1
join database2.owner2.table2 on table1.field1=table2.field2

If the're on different servers (but still mssql) then use a linked server (heterogenous join)
select * from server1.database1.owner1.table1
join server2.database2.owner2.table2 on table1.field1=table2.field2

If it's a different dbms, use openquery or openrowset (depending on what exactly you're trying to do)

Originally posted by asset1
I am facing a problem within SQL server. Is it possible to create SQL query to two separate databases at the same time ?

There are logical relations between tables in separate databases and I need to create some JOINs between tables in separate dbs into my SQL query. I there any solutions to this problem ?

Multiple data sources, single cube?

Newbie question...

I need to create a report with data coming from two entirely separate data sources, the only common factor being the date.

I can see that I could create a single DSV and cube by using views to point to the second database. But is it considered best practice to create a second cube and join the cubes with MDX?

Thanks

This is not so much of a technical question as a how you solve these problems generally. If there is a point of joining information in separate sources you should do it, not in the cubes, but in a data warehouse.

These integration problems should be handled in extract-, transfer-, load processes before you build a cube.

Have a look here(http://www.kimballgroup.com/) for support and ideas.

HTH

Thomas Ivarsson

|||

Thanks Thomas,

That ties in with advice from the Project REAL docs too.

Multiple character separation

Here's my situation, I have a database of stock trades that I need to separate into two lists. one containing trades in stocks that have 4 letters in thier symbols, and the other which has any trades in symbols that have 1,2,or 3 symbols.

I cant seem to figure this one out, can anyone offer any help?Can you give an example of what is stored in your database and what you want the output to be ?|||select * from trade_table where datalength(cast(stock_symbol as varchar(4))) = 4

select * from trade_table where datalength(cast(stock_symbol as varchar(4))) < 4|||thanks, that looks to be exactly what I needed.

-Chamber

Multiple BinaryWrite() calls

I have two byte[] arrays, objResult1 and objResult2, which contain data from
two separate calls to Render().
I would like to somehow write the results for both reports to the Reponse
object.
This is the code I have:
HttpResponse objResponse = System.Web.HttpContext.Current.Response;
objResponse.ClearContent();
objResponse.ClearHeaders();
string fileName = Path.GetFileName(this.ReportPath) +
".pdf";
objResponse.ContentType = this.strMimeType;
objResponse.AddHeader ("content-disposition",
"attachment; filename=\"" + fileName + "\"");
objResponse.BinaryWrite(objResult1);
objResponse.BinaryWrite(objResult2);
objResponse.Flush();
objResponse.Close();
Unfortunately when I do this, the contents of objResult1 are not visible
i.e. the 2nd call to BinaryWrite overwrites the first one.
How can i simply append the second byte array?
Any help will be much appreciated...
Thanks.You can combine two arrays by using static Array.Copy call. Just create a
new array sized as a sum of two and copy your array one by
one to the new one. Be aware, if the mime types of the webresponses are
different you'll get a garbled output.
Also, BinaryWrite should not override the previous write.
The reason of missing the first write is writing file header information
twice, thus only one will be visible, if you lucky enough, otherwise you can
get some garbage
I'd use frames or iframes, if needed to display output from two different
pages on a single one.
"Aparna" <Aparna@.discussions.microsoft.com> wrote in message
news:53A315A1-FFD7-48BF-99D0-84D63BD062C3@.microsoft.com...
>I have two byte[] arrays, objResult1 and objResult2, which contain data
>from
> two separate calls to Render().
> I would like to somehow write the results for both reports to the Reponse
> object.
> This is the code I have:
> HttpResponse objResponse => System.Web.HttpContext.Current.Response;
> objResponse.ClearContent();
> objResponse.ClearHeaders();
> string fileName = Path.GetFileName(this.ReportPath) +
> ".pdf";
> objResponse.ContentType = this.strMimeType;
> objResponse.AddHeader ("content-disposition",
> "attachment; filename=\"" + fileName + "\"");
> objResponse.BinaryWrite(objResult1);
> objResponse.BinaryWrite(objResult2);
> objResponse.Flush();
> objResponse.Close();
> Unfortunately when I do this, the contents of objResult1 are not visible
> i.e. the 2nd call to BinaryWrite overwrites the first one.
> How can i simply append the second byte array?
> Any help will be much appreciated...
> Thanks.