Link to Server via Windows Authentication

Well, then everyone who used the linked server will be
using the new account created. I want people to only use
what thier domain account has permissions to do.
Any way to do this?
>--Original Message--
>You'll need to create a domain account that has login
>permissions to SQL Server "A" and the appropriate
database
>permissions as well. Use this account for the user login
>credentials when you create the link.
>Steve
>.
>You can use delegation to accomplish this. You can find
information on this in books online under the topic:
Security Account Delegation
-Sue
On Mon, 1 Mar 2004 06:57:34 -0800, "Linda"
<anonymous@.discussions.microsoft.com> wrote:
>Well, then everyone who used the linked server will be
>using the new account created. I want people to only use
>what thier domain account has permissions to do.
>Any way to do this?
>database

LInk Tables

Hi,
I have created a link server within my enterprise. I can see the
server - which is on a c-isam db - and all the the tables.
What I am unable to do is query any of the tables.
Link Server = Rubicon
Table Name = qc_raw_mat_cat.
select * from rubicon..qc_raw_mat_cat
What have I missed / messed up?
Many thanks
example
select * from rubicon..qc_raw_mat_catTo reference a table in a linked server, you need to use
LinkedServer.CatalogOrDatabase.SchemaOrOwner.Object
Try:
select *
from rubicon...qc_raw_mat_cat
-Sue
On Thu, 7 Apr 2005 00:23:02 -0700, "MMouse99"
<MMouse99@.discussions.microsoft.com> wrote:

>Hi,
>I have created a link server within my enterprise. I can see the
>server - which is on a c-isam db - and all the the tables.
>What I am unable to do is query any of the tables.
>Link Server = Rubicon
>Table Name = qc_raw_mat_cat.
>select * from rubicon..qc_raw_mat_cat
>What have I missed / messed up?
>Many thanks
>
>example
>select * from rubicon..qc_raw_mat_cat

LInk Tables

Hi,
I have created a link server within my enterprise. I can see the
server - which is on a c-isam db - and all the the tables.
What I am unable to do is query any of the tables.
Link Server = Rubicon
Table Name = qc_raw_mat_cat.
select * from rubicon..qc_raw_mat_cat
What have I missed / messed up?
Many thanks
example
select * from rubicon..qc_raw_mat_cat
To reference a table in a linked server, you need to use
LinkedServer.CatalogOrDatabase.SchemaOrOwner.Objec t
Try:
select *
from rubicon...qc_raw_mat_cat
-Sue
On Thu, 7 Apr 2005 00:23:02 -0700, "MMouse99"
<MMouse99@.discussions.microsoft.com> wrote:

>Hi,
>I have created a link server within my enterprise. I can see the
>server - which is on a c-isam db - and all the the tables.
>What I am unable to do is query any of the tables.
>Link Server = Rubicon
>Table Name = qc_raw_mat_cat.
>select * from rubicon..qc_raw_mat_cat
>What have I missed / messed up?
>Many thanks
>
>example
>select * from rubicon..qc_raw_mat_cat
sql

Link server very slow

I created a link server to 'oracle', properties is below
Server Type : Microsoft OLE DB Provider for Oracle
Product name : ora
Data Source : sapdbproduction
Provider string : MSDAORA
Compare query response time (1 record)
PL-SQL : 0.5 sec
SQL Query Analyzer : 1.4 minute
How can i do?
Thanks in adv.
Hi
Post the DDL and DML.
Regards
Mike
"teera" wrote:

> I created a link server to 'oracle', properties is below
> Server Type : Microsoft OLE DB Provider for Oracle
> Product name : ora
> Data Source : sapdbproduction
> Provider string : MSDAORA
> Compare query response time (1 record)
> PL-SQL : 0.5 sec
> SQL Query Analyzer : 1.4 minute
> How can i do?
> Thanks in adv.
>
>
|||Mike
What is DDL and DML? Please explain me more?
Thanks
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:68EECFB8-4739-4277-A78A-A21F3F6CA33B@.microsoft.com...[vbcol=seagreen]
> Hi
> Post the DDL and DML.
> Regards
> Mike
> "teera" wrote:
|||DDL = Data Definition Language. It's basically the schema of the
associated DB objects (table(s), index(es), view(s), trigger(s), etc.).
DML = Data Manipulation Language. It's the queries that you're running
against those DB objects (SELECT, INSERT, UPDATE, DELETE). The queries
about which you say the response time through the linked server is slow.
Basically, nobody can help you if you don't give any details about the
problem. To help we'll need to see things like execution plans,
indexing of search arguments, etc. We can't do that if we don't know
what your schema looks like and what query you're trying to execute
against that schema. It's possible that the entire table data is being
sent from the Oracle box to the SQL box (through the linked server) and
then any WHERE clause is being applied (which would explain the slow
performance through the link but not direct to Oracle) but we can't tell
if you don't show us the schema & queries involved.
Cheers,
Mike.
teera wrote:
> Mike
> What is DDL and DML? Please explain me more?
> Thanks
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:68EECFB8-4739-4277-A78A-A21F3F6CA33B@.microsoft.com...
>
>
C

Link server very slow

I created a link server to 'oracle', properties is below
Server Type : Microsoft OLE DB Provider for Oracle
Product name : ora
Data Source : sapdbproduction
Provider string : MSDAORA
Compare query response time (1 record)
PL-SQL : 0.5 sec
SQL Query Analyzer : 1.4 minute
How can i do?
Thanks in adv.Hi
Post the DDL and DML.
Regards
Mike
"teera" wrote:

> I created a link server to 'oracle', properties is below
> Server Type : Microsoft OLE DB Provider for Oracle
> Product name : ora
> Data Source : sapdbproduction
> Provider string : MSDAORA
> Compare query response time (1 record)
> PL-SQL : 0.5 sec
> SQL Query Analyzer : 1.4 minute
> How can i do?
> Thanks in adv.
>
>|||Mike
What is DDL and DML? Please explain me more?
Thanks
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:68EECFB8-4739-4277-A78A-A21F3F6CA33B@.microsoft.com...[vbcol=seagreen]
> Hi
> Post the DDL and DML.
> Regards
> Mike
> "teera" wrote:
>|||DDL = Data Definition Language. It's basically the schema of the
associated DB objects (table(s), index(es), view(s), trigger(s), etc.).
DML = Data Manipulation Language. It's the queries that you're running
against those DB objects (SELECT, INSERT, UPDATE, DELETE). The queries
about which you say the response time through the linked server is slow.
Basically, nobody can help you if you don't give any details about the
problem. To help we'll need to see things like execution plans,
indexing of search arguments, etc. We can't do that if we don't know
what your schema looks like and what query you're trying to execute
against that schema. It's possible that the entire table data is being
sent from the Oracle box to the SQL box (through the linked server) and
then any WHERE clause is being applied (which would explain the slow
performance through the link but not direct to Oracle) but we can't tell
if you don't show us the schema & queries involved.
Cheers,
Mike.
teera wrote:
> Mike
> What is DDL and DML? Please explain me more?
> Thanks
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:68EECFB8-4739-4277-A78A-A21F3F6CA33B@.microsoft.com...
>
>
>
C

Link server very slow

I created a link server to 'oracle', properties is below
Server Type : Microsoft OLE DB Provider for Oracle
Product name : ora
Data Source : sapdbproduction
Provider string : MSDAORA
Compare query response time (1 record)
PL-SQL : 0.5 sec
SQL Query Analyzer : 1.4 minute
How can i do?
Thanks in adv.Hi
Post the DDL and DML.
Regards
Mike
"teera" wrote:
> I created a link server to 'oracle', properties is below
> Server Type : Microsoft OLE DB Provider for Oracle
> Product name : ora
> Data Source : sapdbproduction
> Provider string : MSDAORA
> Compare query response time (1 record)
> PL-SQL : 0.5 sec
> SQL Query Analyzer : 1.4 minute
> How can i do?
> Thanks in adv.
>
>|||Mike
What is DDL and DML? Please explain me more?
Thanks
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:68EECFB8-4739-4277-A78A-A21F3F6CA33B@.microsoft.com...
> Hi
> Post the DDL and DML.
> Regards
> Mike
> "teera" wrote:
>> I created a link server to 'oracle', properties is below
>> Server Type : Microsoft OLE DB Provider for Oracle
>> Product name : ora
>> Data Source : sapdbproduction
>> Provider string : MSDAORA
>> Compare query response time (1 record)
>> PL-SQL : 0.5 sec
>> SQL Query Analyzer : 1.4 minute
>> How can i do?
>> Thanks in adv.
>>|||DDL = Data Definition Language. It's basically the schema of the
associated DB objects (table(s), index(es), view(s), trigger(s), etc.).
DML = Data Manipulation Language. It's the queries that you're running
against those DB objects (SELECT, INSERT, UPDATE, DELETE). The queries
about which you say the response time through the linked server is slow.
Basically, nobody can help you if you don't give any details about the
problem. To help we'll need to see things like execution plans,
indexing of search arguments, etc. We can't do that if we don't know
what your schema looks like and what query you're trying to execute
against that schema. It's possible that the entire table data is being
sent from the Oracle box to the SQL box (through the linked server) and
then any WHERE clause is being applied (which would explain the slow
performance through the link but not direct to Oracle) but we can't tell
if you don't show us the schema & queries involved.
Cheers,
Mike.
teera wrote:
> Mike
> What is DDL and DML? Please explain me more?
> Thanks
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:68EECFB8-4739-4277-A78A-A21F3F6CA33B@.microsoft.com...
>>Hi
>>Post the DDL and DML.
>>Regards
>>Mike
>>"teera" wrote:
>>
>>I created a link server to 'oracle', properties is below
>> Server Type : Microsoft OLE DB Provider for Oracle
>> Product name : ora
>> Data Source : sapdbproduction
>> Provider string : MSDAORA
>>Compare query response time (1 record)
>> PL-SQL : 0.5 sec
>> SQL Query Analyzer : 1.4 minute
>>How can i do?
>>Thanks in adv.
>>
>
>
--
ÿþC

Link Server Error: [SQLSTATE 42000] (Error 7399)

I have created a link server between SQL Server 2000 and
MS Access. If I run the job manually, the job runs fine.
But, if I schedule the job, it fails with the follwoing
error message.
Executed as user: raj. OLE DB
provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error
7312) OLE DB error trace [OLE/DB
Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80004005: ].
[SQLSTATE 01000] (Error 7300). The step failed.
I have also created a DTS package to update another Access
database, if I execute the package, it runs. If I schedule
the job, the job fails.
I have checked the permissions for the user Raj and it has
all the privilges.
Any help will be greatly appreciated!
Please suggest, how to fix this issue.
Thanks,
Raj
With what account do you use to start the sqlagent with? Does that have
necessary permissions?
thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
|||HRIS and that acount has read write privilges on the
folder where Access database is residing.
Thanks,
Raj

>--Original Message--
>With what account do you use to start the sqlagent with?
Does that have
>necessary permissions?
>thanks,
>Vikram Jayaram
>Microsoft, SQL Server
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Subscribe to MSDN & use
http://msdn.microsoft.com/newsgroups.
>
>.
>
|||I was experiencing the exact same issue.
I solved it by using absolute paths in place of drive letters when defining the linked server
So in place of z:\folder\file.mdb I wrote \\servername\share\folder\file.mdb
this solved the issue for me

Quote:

Originally Posted by Raj

HRIS and that acount has read write privilges on the
folder where Access database is residing.
Thanks,
Raj

>--Original Message--
>With what account do you use to start the sqlagent with?
Does that have
>necessary permissions?
>thanks,
>Vikram Jayaram
>Microsoft, SQL Server
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Subscribe to MSDN & use
http://msdn.microsoft.com/newsgroups.
>
>.
>

Link Server Error: [SQLSTATE 42000] (Error 7399)

I have created a link server between SQL Server 2000 and
MS Access. If I run the job manually, the job runs fine.
But, if I schedule the job, it fails with the follwoing
error message.
Executed as user: raj. OLE DB
provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error
7312) OLE DB error trace [OLE/DB
Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80004005: ].
[SQLSTATE 01000] (Error 7300). The step failed.
I have also created a DTS package to update another Access
database, if I execute the package, it runs. If I schedule
the job, the job fails.
I have checked the permissions for the user Raj and it has
all the privilges.
Any help will be greatly appreciated!
Please suggest, how to fix this issue.
Thanks,
RajWith what account do you use to start the sqlagent with? Does that have
necessary permissions?
thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||HRIS and that acount has read write privilges on the
folder where Access database is residing.
Thanks,
Raj

>--Original Message--
>With what account do you use to start the sqlagent with?
Does that have
>necessary permissions?
>thanks,
>Vikram Jayaram
>Microsoft, SQL Server
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Subscribe to MSDN & use
http://msdn.microsoft.com/newsgroups.
>
>.
>

Link Server Error: [SQLSTATE 42000] (Error 7399)

I have created a link server between SQL Server 2000 and
MS Access. If I run the job manually, the job runs fine.
But, if I schedule the job, it fails with the follwoing
error message.
Executed as user: raj. OLE DB
provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error
7312) OLE DB error trace [OLE/DB
Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80004005: ].
[SQLSTATE 01000] (Error 7300). The step failed.
I have also created a DTS package to update another Access
database, if I execute the package, it runs. If I schedule
the job, the job fails.
I have checked the permissions for the user Raj and it has
all the privilges.
Any help will be greatly appreciated!
Please suggest, how to fix this issue.
Thanks,
RajWith what account do you use to start the sqlagent with? Does that have
necessary permissions?
thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||HRIS and that acount has read write privilges on the
folder where Access database is residing.
Thanks,
Raj
>--Original Message--
>With what account do you use to start the sqlagent with?
Does that have
>necessary permissions?
>thanks,
>Vikram Jayaram
>Microsoft, SQL Server
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Subscribe to MSDN & use
http://msdn.microsoft.com/newsgroups.
>
>.
>sql

Link Report Builder with Visual Studio C#

How call a method of Visual Studio after close Report Builder?

Then in this method I must obtain the path and the name of created report with Report Builder.

Thanks for help me.

This is not supported. Interesting idea, though.

Link Report

I have a report A under FolderA , I created a link report for reportA under Folder B.

I am trying to access the names of the reports under FolderB through ASP.Net web application.

But when I do this the link report name is not being displayed since it has the path \FolderA\ReportA.

But the report is visible in the report manager under folder B. Is there a work around to display the name of the link report.please let me know.

Thanks!!

SqlNew

The link report name "does" appear !! it was problem with refresh.

Line Chart

I have created a line chart and the line for each series is very thick. Does anyone know if it is possible to set the width of these?
Thanks
DarrenGo to Chart Propertties Dialog -> Data tab -> Values -> Edit ->
Appearance -> Series Style -> Border and Fill tab and change the Width value
accordingly (this can also be an expression.)
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Darren" <Darren@.discussions.microsoft.com> wrote in message
news:F730A02E-B52E-4C99-B7C4-10F5C7BF4710@.microsoft.com...
> I have created a line chart and the line for each series is very thick.
Does anyone know if it is possible to set the width of these?
> Thanks
> Darren|||You will need SP1 installed on client and server to modify the thickness of
line charts:
In report designer, right click on the chart -> Chart Properties Dialog ->
Data tab -> Values -> Edit -> Edit Chart Value dialog -> Appearance tab ->
click Series Styles -> Style properties dialog -> select Width from dropdown
or use an expression like ="1pt"
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Darren" <Darren@.discussions.microsoft.com> wrote in message
news:F730A02E-B52E-4C99-B7C4-10F5C7BF4710@.microsoft.com...
> I have created a line chart and the line for each series is very thick.
Does anyone know if it is possible to set the width of these?
> Thanks
> Darren

Limits on Number of database...

I have created "around 25 excluding system databases" number of databases in
one SQL server instance. Is there any limits on number of SQL server
databases which affects the performance of SQL Server.
I am using SQL 2K.
Thanks,
Akshay
"Akshay Sen" <ASen89@.hotmail.com> wrote in message
news:eblLuwVCFHA.328@.tk2msftngp13.phx.gbl...
>I have created "around 25 excluding system databases" number of databases
>in
> one SQL server instance. Is there any limits on number of SQL server
> databases which affects the performance of SQL Server.
> I am using SQL 2K.
> Thanks,
> Akshay
>
It depends..
How heavily is each database used?
How big is your system (processors, memory etc.).
It's not really the number of databases that is an issue, but rather how
they are being used. One thing to note however is that with a lot of
databases, it may take longer for the SQL Server to come back online as it
does some work with each database when the system is restarted.
HTH
Rick Sawtell
MCT, MCSD, MCDBA
|||Makes sense. Thanks
Akshay
"Rick Sawtell" <quickening@.msn.com> wrote in message
news:#azT90VCFHA.520@.TK2MSFTNGP09.phx.gbl...
> "Akshay Sen" <ASen89@.hotmail.com> wrote in message
> news:eblLuwVCFHA.328@.tk2msftngp13.phx.gbl...
>
> It depends..
> How heavily is each database used?
> How big is your system (processors, memory etc.).
> It's not really the number of databases that is an issue, but rather how
> they are being used. One thing to note however is that with a lot of
> databases, it may take longer for the SQL Server to come back online as it
> does some work with each database when the system is restarted.
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||Also keep in mind that the SQLServer:Database performance counters are only
collected on the first 99 databses.
Sincerely,
Anthony Thomas

"Akshay Sen" <ASen89@.hotmail.com> wrote in message
news:e1aaZ3VCFHA.868@.TK2MSFTNGP10.phx.gbl...
Makes sense. Thanks
Akshay
"Rick Sawtell" <quickening@.msn.com> wrote in message
news:#azT90VCFHA.520@.TK2MSFTNGP09.phx.gbl...
> "Akshay Sen" <ASen89@.hotmail.com> wrote in message
> news:eblLuwVCFHA.328@.tk2msftngp13.phx.gbl...
>
> It depends..
> How heavily is each database used?
> How big is your system (processors, memory etc.).
> It's not really the number of databases that is an issue, but rather how
> they are being used. One thing to note however is that with a lot of
> databases, it may take longer for the SQL Server to come back online as it
> does some work with each database when the system is restarted.
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>

Limits on Number of database...

I have created "around 25 excluding system databases" number of databases in
one SQL server instance. Is there any limits on number of SQL server
databases which affects the performance of SQL Server.
I am using SQL 2K.
Thanks,
Akshay"Akshay Sen" <ASen89@.hotmail.com> wrote in message
news:eblLuwVCFHA.328@.tk2msftngp13.phx.gbl...
>I have created "around 25 excluding system databases" number of databases
>in
> one SQL server instance. Is there any limits on number of SQL server
> databases which affects the performance of SQL Server.
> I am using SQL 2K.
> Thanks,
> Akshay
>
It depends..
How heavily is each database used?
How big is your system (processors, memory etc.).
It's not really the number of databases that is an issue, but rather how
they are being used. One thing to note however is that with a lot of
databases, it may take longer for the SQL Server to come back online as it
does some work with each database when the system is restarted.
HTH
Rick Sawtell
MCT, MCSD, MCDBA|||Makes sense. Thanks
Akshay
"Rick Sawtell" <quickening@.msn.com> wrote in message
news:#azT90VCFHA.520@.TK2MSFTNGP09.phx.gbl...
> "Akshay Sen" <ASen89@.hotmail.com> wrote in message
> news:eblLuwVCFHA.328@.tk2msftngp13.phx.gbl...
>
> It depends..
> How heavily is each database used?
> How big is your system (processors, memory etc.).
> It's not really the number of databases that is an issue, but rather how
> they are being used. One thing to note however is that with a lot of
> databases, it may take longer for the SQL Server to come back online as it
> does some work with each database when the system is restarted.
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Also keep in mind that the SQLServer:Database performance counters are only
collected on the first 99 databses.
Sincerely,
Anthony Thomas
"Akshay Sen" <ASen89@.hotmail.com> wrote in message
news:e1aaZ3VCFHA.868@.TK2MSFTNGP10.phx.gbl...
Makes sense. Thanks
Akshay
"Rick Sawtell" <quickening@.msn.com> wrote in message
news:#azT90VCFHA.520@.TK2MSFTNGP09.phx.gbl...
> "Akshay Sen" <ASen89@.hotmail.com> wrote in message
> news:eblLuwVCFHA.328@.tk2msftngp13.phx.gbl...
>
> It depends..
> How heavily is each database used?
> How big is your system (processors, memory etc.).
> It's not really the number of databases that is an issue, but rather how
> they are being used. One thing to note however is that with a lot of
> databases, it may take longer for the SQL Server to come back online as it
> does some work with each database when the system is restarted.
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>

Limits on Number of database...

I have created "around 25 excluding system databases" number of databases in
one SQL server instance. Is there any limits on number of SQL server
databases which affects the performance of SQL Server.
I am using SQL 2K.
Thanks,
Akshay"Akshay Sen" <ASen89@.hotmail.com> wrote in message
news:eblLuwVCFHA.328@.tk2msftngp13.phx.gbl...
>I have created "around 25 excluding system databases" number of databases
>in
> one SQL server instance. Is there any limits on number of SQL server
> databases which affects the performance of SQL Server.
> I am using SQL 2K.
> Thanks,
> Akshay
>
It depends..
How heavily is each database used?
How big is your system (processors, memory etc.).
It's not really the number of databases that is an issue, but rather how
they are being used. One thing to note however is that with a lot of
databases, it may take longer for the SQL Server to come back online as it
does some work with each database when the system is restarted.
HTH
Rick Sawtell
MCT, MCSD, MCDBA|||Makes sense. Thanks
Akshay
"Rick Sawtell" <quickening@.msn.com> wrote in message
news:#azT90VCFHA.520@.TK2MSFTNGP09.phx.gbl...
> "Akshay Sen" <ASen89@.hotmail.com> wrote in message
> news:eblLuwVCFHA.328@.tk2msftngp13.phx.gbl...
> >I have created "around 25 excluding system databases" number of databases
> >in
> > one SQL server instance. Is there any limits on number of SQL server
> > databases which affects the performance of SQL Server.
> > I am using SQL 2K.
> > Thanks,
> > Akshay
> >
> >
>
> It depends..
> How heavily is each database used?
> How big is your system (processors, memory etc.).
> It's not really the number of databases that is an issue, but rather how
> they are being used. One thing to note however is that with a lot of
> databases, it may take longer for the SQL Server to come back online as it
> does some work with each database when the system is restarted.
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Also keep in mind that the SQLServer:Database performance counters are only
collected on the first 99 databses.
Sincerely,
Anthony Thomas
"Akshay Sen" <ASen89@.hotmail.com> wrote in message
news:e1aaZ3VCFHA.868@.TK2MSFTNGP10.phx.gbl...
Makes sense. Thanks
Akshay
"Rick Sawtell" <quickening@.msn.com> wrote in message
news:#azT90VCFHA.520@.TK2MSFTNGP09.phx.gbl...
> "Akshay Sen" <ASen89@.hotmail.com> wrote in message
> news:eblLuwVCFHA.328@.tk2msftngp13.phx.gbl...
> >I have created "around 25 excluding system databases" number of databases
> >in
> > one SQL server instance. Is there any limits on number of SQL server
> > databases which affects the performance of SQL Server.
> > I am using SQL 2K.
> > Thanks,
> > Akshay
> >
> >
>
> It depends..
> How heavily is each database used?
> How big is your system (processors, memory etc.).
> It's not really the number of databases that is an issue, but rather how
> they are being used. One thing to note however is that with a lot of
> databases, it may take longer for the SQL Server to come back online as it
> does some work with each database when the system is restarted.
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>

limited connections on the developer edition

hi all,

I installed sql server developer edition on

xp box. created a new ssis project and

then when i right click on control flow

then click new connections

i see only limited connection available.

how can i install the other connection option

such as oledb. etc.

thanks

joey

got it

my integration service

is running with limited rights

Limitation on Multiple parameters with Multi-Select and default values

Dear Anyone,

I created 6 parameters in my report. Each of these parameters are multi-select enabled. Each of their available values comes from a data set. Their default values also comes from a data set in order to have the select all check box selected by default.

My problem is only the first 2 parameters gets to have the select all selected. And the rest just have blank values. I was wondering if RS parameters have some sort of limitation that I cannot enable data set default values in all of my parameters.
Thanks,
JosephThere seems to be a bug in RS2005 in the parameters section. Filter the data set your using for the parameters to not include blanks. This is aparently whats causing your problem.|||

Hello,

I need to create reports with parameters that allow for multi-selection values.

How can I make them multi-select enabled?

Appreciate your reponse.

SK

Limitation on Multiple parameters with Multi-Select and default values

Dear Anyone,

I created 6 parameters in my report. Each of these parameters are multi-select enabled. Each of their available values comes from a data set. Their default values also comes from a data set in order to have the select all check box selected by default.

My problem is only the first 2 parameters gets to have the select all selected. And the rest just have blank values. I was wondering if RS parameters have some sort of limitation that I cannot enable data set default values in all of my parameters.
Thanks,
JosephThere seems to be a bug in RS2005 in the parameters section. Filter the data set your using for the parameters to not include blanks. This is aparently whats causing your problem.|||

Hello,

I need to create reports with parameters that allow for multi-selection values.

How can I make them multi-select enabled?

Appreciate your reponse.

SK

Limitation of # cubes inside a base Analysis Services

Does anyone

have any idea which is the limitation of # cubes inside a base Analysis Services,

because I created 50 cubes, and when I tried to connect to the base, i was

enable to do that because the CPU was at

100 %.

I think

that is a problem when analysis services tried to read the xmla and print all the cubes.

Tks

Well. There is a point where number of cubes and size of your data requre you to go and get a bigger machine.

It would be wrong to assume you can create any number of cubes and expect from Analysis Services not to use more CPU or memory trying to handle them all. The question what is reasonable. If you think that you got poweful machine with multiple processors and fast I/O and you see Analysis Services cannot handle large number of objects, there could be somehting. As a reference you can use Project REAL that handle large number of objects. http://www.microsoft.com/sql/solutions/bi/projectreal.mspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hallo Calacean,

the problem, you have accounted is not a SSAS with its limitations, but the client you use.

Some clients read copletely all metadata (available cubes, dimensins, hierarhies, levels, measures etc.) immediately after connection to the database.

Take a time to monitor with the SQL Profiler what commands and queries are sent from your client to the sever. You do find some interesting for you.

|||

Thanks, is

very useful, but i have another question if i don't bother you.

I have a data warehouse with 50 mil. dates. And i have 6 measures group with

relations many 2 many. When i query the cube, first is very slow( and i design aggregations

for all the measures), and second (I have proactive caching setup), when i want to

modify some data from the tables of proactive caching , the proactive caching

is working very god, but it decrease very much the performance of the server,

and the performance of the applications. I forget to mention that I have P4

2Ghz(2CPU), 2GB Memory, and I run Sql Server 2005 and Analysis Services in the

same server.