I have a single data source view which contains 3 tables. Each table is a
completely denormalized (like a spreadsheet) dataset from a particular
business system. The tables themselves don't contain any foreign key
relationships, but within the data source view editor I created primary keys
on each table and created relationships between each table. However, when I
try to create a report in report builder, as soon as add an entity from one
table to my report, the other 2 tables disappear. I have found a few other
posts about this problem and the resolutions offered were (1) add a "refer",
but I don't know what that is; and (2) create or add relationships, but I
believe I have done that. What do I have to do to prevent the tables from
disappearing? Thanks.
Also, is there a good resource for reading up on Ad-Hoc reporting? The
books I have seen only cover it briefly.I figured this out. I need to add a role to each table in the Report Model
Designer. It is all in Books Online.
"Bodhicitta" wrote:
> I have a single data source view which contains 3 tables. Each table is a
> completely denormalized (like a spreadsheet) dataset from a particular
> business system. The tables themselves don't contain any foreign key
> relationships, but within the data source view editor I created primary keys
> on each table and created relationships between each table. However, when I
> try to create a report in report builder, as soon as add an entity from one
> table to my report, the other 2 tables disappear. I have found a few other
> posts about this problem and the resolutions offered were (1) add a "refer",
> but I don't know what that is; and (2) create or add relationships, but I
> believe I have done that. What do I have to do to prevent the tables from
> disappearing? Thanks.
> Also, is there a good resource for reading up on Ad-Hoc reporting? The
> books I have seen only cover it briefly.
>
Showing posts with label single. Show all posts
Showing posts with label single. Show all posts
Monday, March 26, 2012
Enterprise or Standard? Infinite Clickthrough??
We are going to separate reporting services from our database server by
putting RS on a single separate server. We need to know if we can use
Standard or if we have to purchase Enterprise. We have Enterprise for our DB
server. The major differences between the 2 editions are data driven
subscriptions, which we do not need at this time, and infinite clickthrough.
I cannot find a good definition of infinite clickthrough. We have reports
that navigate to other reports. In Standard, is some clickthrough still
available but only up to a certain number of clicks?
Any details would really be appreciated.
StephanieI searched a little on this because I run with Standard and I've never come
up across this limitation. I found out the reason for why I have never
noticed it. It has to do with Report Builder (which I do not use). Here is a
posting by a Program Manager for RS:
>>>>>>>>>>
Infinte Clickthrough is a feature of Report Builder. It allows you to
automatically drill between reports by using the relationships between
entities in the Report Model. The drillthroughs are created "on the fly"
without having to build them beforehand. Workgroup and standard edition only
get pre-defined drillthroughs.
----
Brian Welcker, Microsoft
>>>>>>>>>
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:2CAC3038-95EA-4D0D-9E84-8EDE1DE24D8A@.microsoft.com...
> We are going to separate reporting services from our database server by
> putting RS on a single separate server. We need to know if we can use
> Standard or if we have to purchase Enterprise. We have Enterprise for our
> DB
> server. The major differences between the 2 editions are data driven
> subscriptions, which we do not need at this time, and infinite
> clickthrough.
> I cannot find a good definition of infinite clickthrough. We have reports
> that navigate to other reports. In Standard, is some clickthrough still
> available but only up to a certain number of clicks?
> Any details would really be appreciated.
> Stephanie|||Bruce,
Thanks for the quick response. I read that article, too, and still was a
bit confused. I do not use Report Builder either. I do, however, have
navigation set up to jump from one report to another.
Is it your opinion as well that I should be able to run Reporting Services
Standard Edition on a separate server and still have the ability to use the
Navigation tab and jump from one report to another? If so, would there be a
limit on the number of jumps I can execute? I have a call in to MS but I am
looking for any feedback as well. The cost difference is enough to warrant
some research.
Stephanie
"Bruce L-C [MVP]" wrote:
> I searched a little on this because I run with Standard and I've never come
> up across this limitation. I found out the reason for why I have never
> noticed it. It has to do with Report Builder (which I do not use). Here is a
> posting by a Program Manager for RS:
> >>>>>>>>>>
> Infinte Clickthrough is a feature of Report Builder. It allows you to
> automatically drill between reports by using the relationships between
> entities in the Report Model. The drillthroughs are created "on the fly"
> without having to build them beforehand. Workgroup and standard edition only
> get pre-defined drillthroughs.
>
> ----
> Brian Welcker, Microsoft
> >>>>>>>>>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
>
>
>
> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
> news:2CAC3038-95EA-4D0D-9E84-8EDE1DE24D8A@.microsoft.com...
> > We are going to separate reporting services from our database server by
> > putting RS on a single separate server. We need to know if we can use
> > Standard or if we have to purchase Enterprise. We have Enterprise for our
> > DB
> > server. The major differences between the 2 editions are data driven
> > subscriptions, which we do not need at this time, and infinite
> > clickthrough.
> > I cannot find a good definition of infinite clickthrough. We have reports
> > that navigate to other reports. In Standard, is some clickthrough still
> > available but only up to a certain number of clicks?
> >
> > Any details would really be appreciated.
> >
> > Stephanie
>
>|||I think it was pretty clear that the infinite clickthrough was a report
builder feature. I run standard and have lots of drill through (that is what
jump to report is called). If there is a limit I have not seen it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:7DE14E7D-779B-4068-943B-69BA1D726A51@.microsoft.com...
> Bruce,
> Thanks for the quick response. I read that article, too, and still was a
> bit confused. I do not use Report Builder either. I do, however, have
> navigation set up to jump from one report to another.
> Is it your opinion as well that I should be able to run Reporting Services
> Standard Edition on a separate server and still have the ability to use
> the
> Navigation tab and jump from one report to another? If so, would there be
> a
> limit on the number of jumps I can execute? I have a call in to MS but I
> am
> looking for any feedback as well. The cost difference is enough to
> warrant
> some research.
> Stephanie
> "Bruce L-C [MVP]" wrote:
>> I searched a little on this because I run with Standard and I've never
>> come
>> up across this limitation. I found out the reason for why I have never
>> noticed it. It has to do with Report Builder (which I do not use). Here
>> is a
>> posting by a Program Manager for RS:
>> >>>>>>>>>>
>> Infinte Clickthrough is a feature of Report Builder. It allows you
>> to
>> automatically drill between reports by using the relationships between
>> entities in the Report Model. The drillthroughs are created "on the fly"
>> without having to build them beforehand. Workgroup and standard edition
>> only
>> get pre-defined drillthroughs.
>>
>> ----
>> Brian Welcker, Microsoft
>> >>>>>>>>>
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>>
>>
>>
>> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
>> news:2CAC3038-95EA-4D0D-9E84-8EDE1DE24D8A@.microsoft.com...
>> > We are going to separate reporting services from our database server by
>> > putting RS on a single separate server. We need to know if we can use
>> > Standard or if we have to purchase Enterprise. We have Enterprise for
>> > our
>> > DB
>> > server. The major differences between the 2 editions are data driven
>> > subscriptions, which we do not need at this time, and infinite
>> > clickthrough.
>> > I cannot find a good definition of infinite clickthrough. We have
>> > reports
>> > that navigate to other reports. In Standard, is some clickthrough
>> > still
>> > available but only up to a certain number of clicks?
>> >
>> > Any details would really be appreciated.
>> >
>> > Stephanie
>>|||First of all, SSRS is bundled with SQL Server for free. If you have
SQL Enterprise 2005 then you have all the SSRS enterprise features,
including clickthrough reporting.
Infinite Clickthrough is indeed a feature of Report Builder. If you
have a Report Model created for your database, what this allows is
dynamic ad-hoc reports generated by SSRS itself. Basically it allows
you to drill-down indefinitely with the Report Builder dynamically
creating reports which are based off of the fields and relationships
on your database from the Report Model.
Basically, if the report your looking at references data that has a
relationship to another table, those fields will be hyperlinks. If
you click on the hyperlink SSRS will create a report based on the
table refereced by the link you clicked on. This can be done
indefinitely, like a virtual tour of your database. So, for example,
from a customer report you can click on their order total to see a
report showing their orders, from there you can click on a particular
order's details to see the actual items ordered, from there you can
click on a line item to see the item's general details, from there you
can click on the last PO for the item, etc.
You can always create your own reports that you drill-through. There
is no limit to how many of these manual reports you can create or
drill-through. The difference is SSRS will actually do all this for
you if you have Enterprise. This seems like a really basic feature
since all the infrastructure is in place with SSRS standard. We would
like to take advantage of clickthrough reporting but we don't have
enterprise. The cost to upgrade is pretty astronomical for this
feature.|||Thanks for the description.
Just a little clarification of why this matters to the person who posted.
They are putting RS on a different server than the database. It is not free
in that case. You have to have a license for each machine that RS is
installed on. So let's say you have a web farm (which required enterprise).
For each server on the web farm that has RS installed you need an enterprise
license on that server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Matt Penner" <mattpenner2007@.gmail.com> wrote in message
news:1194451200.927016.283220@.z24g2000prh.googlegroups.com...
> First of all, SSRS is bundled with SQL Server for free. If you have
> SQL Enterprise 2005 then you have all the SSRS enterprise features,
> including clickthrough reporting.
> Infinite Clickthrough is indeed a feature of Report Builder. If you
> have a Report Model created for your database, what this allows is
> dynamic ad-hoc reports generated by SSRS itself. Basically it allows
> you to drill-down indefinitely with the Report Builder dynamically
> creating reports which are based off of the fields and relationships
> on your database from the Report Model.
> Basically, if the report your looking at references data that has a
> relationship to another table, those fields will be hyperlinks. If
> you click on the hyperlink SSRS will create a report based on the
> table refereced by the link you clicked on. This can be done
> indefinitely, like a virtual tour of your database. So, for example,
> from a customer report you can click on their order total to see a
> report showing their orders, from there you can click on a particular
> order's details to see the actual items ordered, from there you can
> click on a line item to see the item's general details, from there you
> can click on the last PO for the item, etc.
> You can always create your own reports that you drill-through. There
> is no limit to how many of these manual reports you can create or
> drill-through. The difference is SSRS will actually do all this for
> you if you have Enterprise. This seems like a really basic feature
> since all the infrastructure is in place with SSRS standard. We would
> like to take advantage of clickthrough reporting but we don't have
> enterprise. The cost to upgrade is pretty astronomical for this
> feature.
>|||First of all, SSRS is bundled with SQL Server for free. If you have
SQL Enterprise 2005 then you have all the SSRS enterprise features,
including clickthrough reporting.
Infinite Clickthrough is indeed a feature of Report Builder. If you
have a Report Model created for your database, what this allows is
dynamic ad-hoc reports generated by SSRS itself. Basically it allows
you to drill-down indefinitely with the Report Builder dynamically
creating reports which are based off of the fields and relationships
on your database from the Report Model.
Basically, if the report your looking at references data that has a
relationship to another table, those fields will be hyperlinks. If
you click on the hyperlink SSRS will create a report based on the
table refereced by the link you clicked on. This can be done
indefinitely, like a virtual tour of your database. So, for example,
from a customer report you can click on their order total to see a
report showing their orders, from there you can click on a particular
order's details to see the actual items ordered, from there you can
click on a line item to see the item's general details, from there you
can click on the last PO for the item, etc.
You can always create your own reports that you drill-through. There
is no limit to how many of these manual reports you can create or
drill-through. The difference is SSRS will actually do all this for
you if you have Enterprise. This seems like a really basic feature
since all the infrastructure is in place with SSRS standard. We would
like to take advantage of clickthrough reporting but we don't have
enterprise. The cost to upgrade is pretty astronomical for this
feature.
putting RS on a single separate server. We need to know if we can use
Standard or if we have to purchase Enterprise. We have Enterprise for our DB
server. The major differences between the 2 editions are data driven
subscriptions, which we do not need at this time, and infinite clickthrough.
I cannot find a good definition of infinite clickthrough. We have reports
that navigate to other reports. In Standard, is some clickthrough still
available but only up to a certain number of clicks?
Any details would really be appreciated.
StephanieI searched a little on this because I run with Standard and I've never come
up across this limitation. I found out the reason for why I have never
noticed it. It has to do with Report Builder (which I do not use). Here is a
posting by a Program Manager for RS:
>>>>>>>>>>
Infinte Clickthrough is a feature of Report Builder. It allows you to
automatically drill between reports by using the relationships between
entities in the Report Model. The drillthroughs are created "on the fly"
without having to build them beforehand. Workgroup and standard edition only
get pre-defined drillthroughs.
----
Brian Welcker, Microsoft
>>>>>>>>>
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:2CAC3038-95EA-4D0D-9E84-8EDE1DE24D8A@.microsoft.com...
> We are going to separate reporting services from our database server by
> putting RS on a single separate server. We need to know if we can use
> Standard or if we have to purchase Enterprise. We have Enterprise for our
> DB
> server. The major differences between the 2 editions are data driven
> subscriptions, which we do not need at this time, and infinite
> clickthrough.
> I cannot find a good definition of infinite clickthrough. We have reports
> that navigate to other reports. In Standard, is some clickthrough still
> available but only up to a certain number of clicks?
> Any details would really be appreciated.
> Stephanie|||Bruce,
Thanks for the quick response. I read that article, too, and still was a
bit confused. I do not use Report Builder either. I do, however, have
navigation set up to jump from one report to another.
Is it your opinion as well that I should be able to run Reporting Services
Standard Edition on a separate server and still have the ability to use the
Navigation tab and jump from one report to another? If so, would there be a
limit on the number of jumps I can execute? I have a call in to MS but I am
looking for any feedback as well. The cost difference is enough to warrant
some research.
Stephanie
"Bruce L-C [MVP]" wrote:
> I searched a little on this because I run with Standard and I've never come
> up across this limitation. I found out the reason for why I have never
> noticed it. It has to do with Report Builder (which I do not use). Here is a
> posting by a Program Manager for RS:
> >>>>>>>>>>
> Infinte Clickthrough is a feature of Report Builder. It allows you to
> automatically drill between reports by using the relationships between
> entities in the Report Model. The drillthroughs are created "on the fly"
> without having to build them beforehand. Workgroup and standard edition only
> get pre-defined drillthroughs.
>
> ----
> Brian Welcker, Microsoft
> >>>>>>>>>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
>
>
>
> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
> news:2CAC3038-95EA-4D0D-9E84-8EDE1DE24D8A@.microsoft.com...
> > We are going to separate reporting services from our database server by
> > putting RS on a single separate server. We need to know if we can use
> > Standard or if we have to purchase Enterprise. We have Enterprise for our
> > DB
> > server. The major differences between the 2 editions are data driven
> > subscriptions, which we do not need at this time, and infinite
> > clickthrough.
> > I cannot find a good definition of infinite clickthrough. We have reports
> > that navigate to other reports. In Standard, is some clickthrough still
> > available but only up to a certain number of clicks?
> >
> > Any details would really be appreciated.
> >
> > Stephanie
>
>|||I think it was pretty clear that the infinite clickthrough was a report
builder feature. I run standard and have lots of drill through (that is what
jump to report is called). If there is a limit I have not seen it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:7DE14E7D-779B-4068-943B-69BA1D726A51@.microsoft.com...
> Bruce,
> Thanks for the quick response. I read that article, too, and still was a
> bit confused. I do not use Report Builder either. I do, however, have
> navigation set up to jump from one report to another.
> Is it your opinion as well that I should be able to run Reporting Services
> Standard Edition on a separate server and still have the ability to use
> the
> Navigation tab and jump from one report to another? If so, would there be
> a
> limit on the number of jumps I can execute? I have a call in to MS but I
> am
> looking for any feedback as well. The cost difference is enough to
> warrant
> some research.
> Stephanie
> "Bruce L-C [MVP]" wrote:
>> I searched a little on this because I run with Standard and I've never
>> come
>> up across this limitation. I found out the reason for why I have never
>> noticed it. It has to do with Report Builder (which I do not use). Here
>> is a
>> posting by a Program Manager for RS:
>> >>>>>>>>>>
>> Infinte Clickthrough is a feature of Report Builder. It allows you
>> to
>> automatically drill between reports by using the relationships between
>> entities in the Report Model. The drillthroughs are created "on the fly"
>> without having to build them beforehand. Workgroup and standard edition
>> only
>> get pre-defined drillthroughs.
>>
>> ----
>> Brian Welcker, Microsoft
>> >>>>>>>>>
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>>
>>
>>
>> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
>> news:2CAC3038-95EA-4D0D-9E84-8EDE1DE24D8A@.microsoft.com...
>> > We are going to separate reporting services from our database server by
>> > putting RS on a single separate server. We need to know if we can use
>> > Standard or if we have to purchase Enterprise. We have Enterprise for
>> > our
>> > DB
>> > server. The major differences between the 2 editions are data driven
>> > subscriptions, which we do not need at this time, and infinite
>> > clickthrough.
>> > I cannot find a good definition of infinite clickthrough. We have
>> > reports
>> > that navigate to other reports. In Standard, is some clickthrough
>> > still
>> > available but only up to a certain number of clicks?
>> >
>> > Any details would really be appreciated.
>> >
>> > Stephanie
>>|||First of all, SSRS is bundled with SQL Server for free. If you have
SQL Enterprise 2005 then you have all the SSRS enterprise features,
including clickthrough reporting.
Infinite Clickthrough is indeed a feature of Report Builder. If you
have a Report Model created for your database, what this allows is
dynamic ad-hoc reports generated by SSRS itself. Basically it allows
you to drill-down indefinitely with the Report Builder dynamically
creating reports which are based off of the fields and relationships
on your database from the Report Model.
Basically, if the report your looking at references data that has a
relationship to another table, those fields will be hyperlinks. If
you click on the hyperlink SSRS will create a report based on the
table refereced by the link you clicked on. This can be done
indefinitely, like a virtual tour of your database. So, for example,
from a customer report you can click on their order total to see a
report showing their orders, from there you can click on a particular
order's details to see the actual items ordered, from there you can
click on a line item to see the item's general details, from there you
can click on the last PO for the item, etc.
You can always create your own reports that you drill-through. There
is no limit to how many of these manual reports you can create or
drill-through. The difference is SSRS will actually do all this for
you if you have Enterprise. This seems like a really basic feature
since all the infrastructure is in place with SSRS standard. We would
like to take advantage of clickthrough reporting but we don't have
enterprise. The cost to upgrade is pretty astronomical for this
feature.|||Thanks for the description.
Just a little clarification of why this matters to the person who posted.
They are putting RS on a different server than the database. It is not free
in that case. You have to have a license for each machine that RS is
installed on. So let's say you have a web farm (which required enterprise).
For each server on the web farm that has RS installed you need an enterprise
license on that server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Matt Penner" <mattpenner2007@.gmail.com> wrote in message
news:1194451200.927016.283220@.z24g2000prh.googlegroups.com...
> First of all, SSRS is bundled with SQL Server for free. If you have
> SQL Enterprise 2005 then you have all the SSRS enterprise features,
> including clickthrough reporting.
> Infinite Clickthrough is indeed a feature of Report Builder. If you
> have a Report Model created for your database, what this allows is
> dynamic ad-hoc reports generated by SSRS itself. Basically it allows
> you to drill-down indefinitely with the Report Builder dynamically
> creating reports which are based off of the fields and relationships
> on your database from the Report Model.
> Basically, if the report your looking at references data that has a
> relationship to another table, those fields will be hyperlinks. If
> you click on the hyperlink SSRS will create a report based on the
> table refereced by the link you clicked on. This can be done
> indefinitely, like a virtual tour of your database. So, for example,
> from a customer report you can click on their order total to see a
> report showing their orders, from there you can click on a particular
> order's details to see the actual items ordered, from there you can
> click on a line item to see the item's general details, from there you
> can click on the last PO for the item, etc.
> You can always create your own reports that you drill-through. There
> is no limit to how many of these manual reports you can create or
> drill-through. The difference is SSRS will actually do all this for
> you if you have Enterprise. This seems like a really basic feature
> since all the infrastructure is in place with SSRS standard. We would
> like to take advantage of clickthrough reporting but we don't have
> enterprise. The cost to upgrade is pretty astronomical for this
> feature.
>|||First of all, SSRS is bundled with SQL Server for free. If you have
SQL Enterprise 2005 then you have all the SSRS enterprise features,
including clickthrough reporting.
Infinite Clickthrough is indeed a feature of Report Builder. If you
have a Report Model created for your database, what this allows is
dynamic ad-hoc reports generated by SSRS itself. Basically it allows
you to drill-down indefinitely with the Report Builder dynamically
creating reports which are based off of the fields and relationships
on your database from the Report Model.
Basically, if the report your looking at references data that has a
relationship to another table, those fields will be hyperlinks. If
you click on the hyperlink SSRS will create a report based on the
table refereced by the link you clicked on. This can be done
indefinitely, like a virtual tour of your database. So, for example,
from a customer report you can click on their order total to see a
report showing their orders, from there you can click on a particular
order's details to see the actual items ordered, from there you can
click on a line item to see the item's general details, from there you
can click on the last PO for the item, etc.
You can always create your own reports that you drill-through. There
is no limit to how many of these manual reports you can create or
drill-through. The difference is SSRS will actually do all this for
you if you have Enterprise. This seems like a really basic feature
since all the infrastructure is in place with SSRS standard. We would
like to take advantage of clickthrough reporting but we don't have
enterprise. The cost to upgrade is pretty astronomical for this
feature.
Monday, March 19, 2012
Enterprise Manager Shortcuts for Remote Servers
Hello and thank you in advance.
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to find the database I am seeking.
I'd like to have shortcuts to each specific database so I can connect and
get to the tables with one click.
Anyone know how to do this?
Thanks,
JulianHi Julian,
Do you have restriction for using Query Analyzer also? If not, while
configuring the client ODBC, you can specify the default database you wish to
connect to.
--
Thanks
Yogish|||Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.
Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.
"Yogish" wrote:
> Hi Julian,
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish to
> connect to.
> --
> Thanks
> Yogish|||Hi Julian,
You can do lot of operations with Query Analyzer (QA). If you are using SQL
Server 2000 client, you can use Object Browser to access all the database
objects, provided you have the permission.
Check out Books online.
--
Thanks
Yogish
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to find the database I am seeking.
I'd like to have shortcuts to each specific database so I can connect and
get to the tables with one click.
Anyone know how to do this?
Thanks,
JulianHi Julian,
Do you have restriction for using Query Analyzer also? If not, while
configuring the client ODBC, you can specify the default database you wish to
connect to.
--
Thanks
Yogish|||Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.
Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.
"Yogish" wrote:
> Hi Julian,
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish to
> connect to.
> --
> Thanks
> Yogish|||Hi Julian,
You can do lot of operations with Query Analyzer (QA). If you are using SQL
Server 2000 client, you can use Object Browser to access all the database
objects, provided you have the permission.
Check out Books online.
--
Thanks
Yogish
Enterprise Manager Shortcuts for Remote Servers
Hello and thank you in advance.
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to find the database I am seeking.
I'd like to have shortcuts to each specific database so I can connect and
get to the tables with one click.
Anyone know how to do this?
Thanks,
Julian
Hi Julian,
Do you have restriction for using Query Analyzer also? If not, while
configuring the client ODBC, you can specify the default database you wish to
connect to.
Thanks
Yogish
|||Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.
Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.
"Yogish" wrote:
> Hi Julian,
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish to
> connect to.
> --
> Thanks
> Yogish
|||Hi Julian,
You can do lot of operations with Query Analyzer (QA). If you are using SQL
Server 2000 client, you can use Object Browser to access all the database
objects, provided you have the permission.
Check out Books online.
Thanks
Yogish
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to find the database I am seeking.
I'd like to have shortcuts to each specific database so I can connect and
get to the tables with one click.
Anyone know how to do this?
Thanks,
Julian
Hi Julian,
Do you have restriction for using Query Analyzer also? If not, while
configuring the client ODBC, you can specify the default database you wish to
connect to.
Thanks
Yogish
|||Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.
Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.
"Yogish" wrote:
> Hi Julian,
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish to
> connect to.
> --
> Thanks
> Yogish
|||Hi Julian,
You can do lot of operations with Query Analyzer (QA). If you are using SQL
Server 2000 client, you can use Object Browser to access all the database
objects, provided you have the permission.
Check out Books online.
Thanks
Yogish
Enterprise Manager Shortcuts for Remote Servers
Hello and thank you in advance.
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to find the database I am seeking
.
I'd like to have shortcuts to each specific database so I can connect and
get to the tables with one click.
Anyone know how to do this?
Thanks,
JulianHi Julian,
Do you have restriction for using Query Analyzer also? If not, while
configuring the client ODBC, you can specify the default database you wish t
o
connect to.
Thanks
Yogish|||Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.
Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.
"Yogish" wrote:
> Hi Julian,
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish
to
> connect to.
> --
> Thanks
> Yogish|||Hi Julian,
You can do lot of operations with Query Analyzer (QA). If you are using SQL
Server 2000 client, you can use Object Browser to access all the database
objects, provided you have the permission.
Check out Books online.
Thanks
Yogish
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to find the database I am seeking
.
I'd like to have shortcuts to each specific database so I can connect and
get to the tables with one click.
Anyone know how to do this?
Thanks,
JulianHi Julian,
Do you have restriction for using Query Analyzer also? If not, while
configuring the client ODBC, you can specify the default database you wish t
o
connect to.
Thanks
Yogish|||Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.
Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.
"Yogish" wrote:
> Hi Julian,
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish
to
> connect to.
> --
> Thanks
> Yogish|||Hi Julian,
You can do lot of operations with Query Analyzer (QA). If you are using SQL
Server 2000 client, you can use Object Browser to access all the database
objects, provided you have the permission.
Check out Books online.
Thanks
Yogish
Subscribe to:
Posts (Atom)