I have sql server 2000 setup on 2003. When users are running queries agains
t
SQL Server from MS Access it opens up 10 - 18 instances for that user instea
d
of just 1 instance. Why would this happen and how can I fix it.
Your help/suggestion is greatly appreciated.
Thank youhelpplease wrote:
> I have sql server 2000 setup on 2003. When users are running queries
> against SQL Server from MS Access it opens up 10 - 18 instances for
> that user instead of just 1 instance. Why would this happen and how
> can I fix it.
> Your help/suggestion is greatly appreciated.
> Thank you
Sounds like an application design issue, not a SQL Server issue. You're
not saying you are seeing the same spid in sysprocesses listed multiple
times, are you? Either the application is programmed to perform multiple
connections to the database or this is happening automatically; possibly
because of active result sets in the application. Not an Access expert.
Probably better to ask this question in an Access ng.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Yes, I am seeing the same spid in sysprocesses listed multiple times.
What could be the problem?
Thank you
Divya
"David Gugick" wrote:
> helpplease wrote:
> Sounds like an application design issue, not a SQL Server issue. You're
> not saying you are seeing the same spid in sysprocesses listed multiple
> times, are you? Either the application is programmed to perform multiple
> connections to the database or this is happening automatically; possibly
> because of active result sets in the application. Not an Access expert.
> Probably better to ask this question in an Access ng.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>|||helpplease wrote:
> Yes, I am seeing the same spid in sysprocesses listed multiple times.
> What could be the problem?
> Thank you
> Divya
>
That's probably because the same spid is running in multiple threads on
multiple CPUs. 10-18 instances of a SPID sounds high. Not sure what is
really going on. What version (and SP) of SQL Server are you using? How
many CPUs?
David Gugick
Quest Software
www.imceda.com
www.quest.com|||SQL Server 2000, Service Pack 3.
I have 4 Processors.
Thank you
"David Gugick" wrote:
> helpplease wrote:
> That's probably because the same spid is running in multiple threads on
> multiple CPUs. 10-18 instances of a SPID sounds high. Not sure what is
> really going on. What version (and SP) of SQL Server are you using? How
> many CPUs?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>|||Any Suggestions on this one.
Thank you
"helpplease" wrote:
[vbcol=seagreen]
> SQL Server 2000, Service Pack 3.
> I have 4 Processors.
> Thank you
> "David Gugick" wrote:
>
Showing posts with label setup. Show all posts
Showing posts with label setup. Show all posts
Wednesday, March 28, 2012
multiple instances of spid's
I have sql server 2000 setup on 2003. When users are running queries against
SQL Server from MS Access it opens up 10 - 18 instances for that user instead
of just 1 instance. Why would this happen and how can I fix it.
Your help/suggestion is greatly appreciated.
Thank you
helpplease wrote:
> I have sql server 2000 setup on 2003. When users are running queries
> against SQL Server from MS Access it opens up 10 - 18 instances for
> that user instead of just 1 instance. Why would this happen and how
> can I fix it.
> Your help/suggestion is greatly appreciated.
> Thank you
Sounds like an application design issue, not a SQL Server issue. You're
not saying you are seeing the same spid in sysprocesses listed multiple
times, are you? Either the application is programmed to perform multiple
connections to the database or this is happening automatically; possibly
because of active result sets in the application. Not an Access expert.
Probably better to ask this question in an Access ng.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Yes, I am seeing the same spid in sysprocesses listed multiple times.
What could be the problem?
Thank you
Divya
"David Gugick" wrote:
> helpplease wrote:
> Sounds like an application design issue, not a SQL Server issue. You're
> not saying you are seeing the same spid in sysprocesses listed multiple
> times, are you? Either the application is programmed to perform multiple
> connections to the database or this is happening automatically; possibly
> because of active result sets in the application. Not an Access expert.
> Probably better to ask this question in an Access ng.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>
|||helpplease wrote:
> Yes, I am seeing the same spid in sysprocesses listed multiple times.
> What could be the problem?
> Thank you
> Divya
>
That's probably because the same spid is running in multiple threads on
multiple CPUs. 10-18 instances of a SPID sounds high. Not sure what is
really going on. What version (and SP) of SQL Server are you using? How
many CPUs?
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||SQL Server 2000, Service Pack 3.
I have 4 Processors.
Thank you
"David Gugick" wrote:
> helpplease wrote:
> That's probably because the same spid is running in multiple threads on
> multiple CPUs. 10-18 instances of a SPID sounds high. Not sure what is
> really going on. What version (and SP) of SQL Server are you using? How
> many CPUs?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>
|||Any Suggestions on this one.
Thank you
"helpplease" wrote:
[vbcol=seagreen]
> SQL Server 2000, Service Pack 3.
> I have 4 Processors.
> Thank you
> "David Gugick" wrote:
sql
SQL Server from MS Access it opens up 10 - 18 instances for that user instead
of just 1 instance. Why would this happen and how can I fix it.
Your help/suggestion is greatly appreciated.
Thank you
helpplease wrote:
> I have sql server 2000 setup on 2003. When users are running queries
> against SQL Server from MS Access it opens up 10 - 18 instances for
> that user instead of just 1 instance. Why would this happen and how
> can I fix it.
> Your help/suggestion is greatly appreciated.
> Thank you
Sounds like an application design issue, not a SQL Server issue. You're
not saying you are seeing the same spid in sysprocesses listed multiple
times, are you? Either the application is programmed to perform multiple
connections to the database or this is happening automatically; possibly
because of active result sets in the application. Not an Access expert.
Probably better to ask this question in an Access ng.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Yes, I am seeing the same spid in sysprocesses listed multiple times.
What could be the problem?
Thank you
Divya
"David Gugick" wrote:
> helpplease wrote:
> Sounds like an application design issue, not a SQL Server issue. You're
> not saying you are seeing the same spid in sysprocesses listed multiple
> times, are you? Either the application is programmed to perform multiple
> connections to the database or this is happening automatically; possibly
> because of active result sets in the application. Not an Access expert.
> Probably better to ask this question in an Access ng.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>
|||helpplease wrote:
> Yes, I am seeing the same spid in sysprocesses listed multiple times.
> What could be the problem?
> Thank you
> Divya
>
That's probably because the same spid is running in multiple threads on
multiple CPUs. 10-18 instances of a SPID sounds high. Not sure what is
really going on. What version (and SP) of SQL Server are you using? How
many CPUs?
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||SQL Server 2000, Service Pack 3.
I have 4 Processors.
Thank you
"David Gugick" wrote:
> helpplease wrote:
> That's probably because the same spid is running in multiple threads on
> multiple CPUs. 10-18 instances of a SPID sounds high. Not sure what is
> really going on. What version (and SP) of SQL Server are you using? How
> many CPUs?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>
|||Any Suggestions on this one.
Thank you
"helpplease" wrote:
[vbcol=seagreen]
> SQL Server 2000, Service Pack 3.
> I have 4 Processors.
> Thank you
> "David Gugick" wrote:
sql
multiple instances of spid's
I have sql server 2000 setup on 2003. When users are running queries against
SQL Server from MS Access it opens up 10 - 18 instances for that user instead
of just 1 instance. Why would this happen and how can I fix it.
Your help/suggestion is greatly appreciated.
Thank youhelpplease wrote:
> I have sql server 2000 setup on 2003. When users are running queries
> against SQL Server from MS Access it opens up 10 - 18 instances for
> that user instead of just 1 instance. Why would this happen and how
> can I fix it.
> Your help/suggestion is greatly appreciated.
> Thank you
Sounds like an application design issue, not a SQL Server issue. You're
not saying you are seeing the same spid in sysprocesses listed multiple
times, are you? Either the application is programmed to perform multiple
connections to the database or this is happening automatically; possibly
because of active result sets in the application. Not an Access expert.
Probably better to ask this question in an Access ng.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Yes, I am seeing the same spid in sysprocesses listed multiple times.
What could be the problem?
Thank you
Divya
"David Gugick" wrote:
> helpplease wrote:
> > I have sql server 2000 setup on 2003. When users are running queries
> > against SQL Server from MS Access it opens up 10 - 18 instances for
> > that user instead of just 1 instance. Why would this happen and how
> > can I fix it.
> >
> > Your help/suggestion is greatly appreciated.
> >
> > Thank you
> Sounds like an application design issue, not a SQL Server issue. You're
> not saying you are seeing the same spid in sysprocesses listed multiple
> times, are you? Either the application is programmed to perform multiple
> connections to the database or this is happening automatically; possibly
> because of active result sets in the application. Not an Access expert.
> Probably better to ask this question in an Access ng.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>|||helpplease wrote:
> Yes, I am seeing the same spid in sysprocesses listed multiple times.
> What could be the problem?
> Thank you
> Divya
>
That's probably because the same spid is running in multiple threads on
multiple CPUs. 10-18 instances of a SPID sounds high. Not sure what is
really going on. What version (and SP) of SQL Server are you using? How
many CPUs?
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||SQL Server 2000, Service Pack 3.
I have 4 Processors.
Thank you
"David Gugick" wrote:
> helpplease wrote:
> > Yes, I am seeing the same spid in sysprocesses listed multiple times.
> >
> > What could be the problem?
> >
> > Thank you
> > Divya
> >
> That's probably because the same spid is running in multiple threads on
> multiple CPUs. 10-18 instances of a SPID sounds high. Not sure what is
> really going on. What version (and SP) of SQL Server are you using? How
> many CPUs?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>|||Any Suggestions on this one.
Thank you
"helpplease" wrote:
> SQL Server 2000, Service Pack 3.
> I have 4 Processors.
> Thank you
> "David Gugick" wrote:
> > helpplease wrote:
> > > Yes, I am seeing the same spid in sysprocesses listed multiple times.
> > >
> > > What could be the problem?
> > >
> > > Thank you
> > > Divya
> > >
> >
> > That's probably because the same spid is running in multiple threads on
> > multiple CPUs. 10-18 instances of a SPID sounds high. Not sure what is
> > really going on. What version (and SP) of SQL Server are you using? How
> > many CPUs?
> >
> > --
> > David Gugick
> > Quest Software
> > www.imceda.com
> > www.quest.com
> >
> >
SQL Server from MS Access it opens up 10 - 18 instances for that user instead
of just 1 instance. Why would this happen and how can I fix it.
Your help/suggestion is greatly appreciated.
Thank youhelpplease wrote:
> I have sql server 2000 setup on 2003. When users are running queries
> against SQL Server from MS Access it opens up 10 - 18 instances for
> that user instead of just 1 instance. Why would this happen and how
> can I fix it.
> Your help/suggestion is greatly appreciated.
> Thank you
Sounds like an application design issue, not a SQL Server issue. You're
not saying you are seeing the same spid in sysprocesses listed multiple
times, are you? Either the application is programmed to perform multiple
connections to the database or this is happening automatically; possibly
because of active result sets in the application. Not an Access expert.
Probably better to ask this question in an Access ng.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Yes, I am seeing the same spid in sysprocesses listed multiple times.
What could be the problem?
Thank you
Divya
"David Gugick" wrote:
> helpplease wrote:
> > I have sql server 2000 setup on 2003. When users are running queries
> > against SQL Server from MS Access it opens up 10 - 18 instances for
> > that user instead of just 1 instance. Why would this happen and how
> > can I fix it.
> >
> > Your help/suggestion is greatly appreciated.
> >
> > Thank you
> Sounds like an application design issue, not a SQL Server issue. You're
> not saying you are seeing the same spid in sysprocesses listed multiple
> times, are you? Either the application is programmed to perform multiple
> connections to the database or this is happening automatically; possibly
> because of active result sets in the application. Not an Access expert.
> Probably better to ask this question in an Access ng.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>|||helpplease wrote:
> Yes, I am seeing the same spid in sysprocesses listed multiple times.
> What could be the problem?
> Thank you
> Divya
>
That's probably because the same spid is running in multiple threads on
multiple CPUs. 10-18 instances of a SPID sounds high. Not sure what is
really going on. What version (and SP) of SQL Server are you using? How
many CPUs?
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||SQL Server 2000, Service Pack 3.
I have 4 Processors.
Thank you
"David Gugick" wrote:
> helpplease wrote:
> > Yes, I am seeing the same spid in sysprocesses listed multiple times.
> >
> > What could be the problem?
> >
> > Thank you
> > Divya
> >
> That's probably because the same spid is running in multiple threads on
> multiple CPUs. 10-18 instances of a SPID sounds high. Not sure what is
> really going on. What version (and SP) of SQL Server are you using? How
> many CPUs?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>|||Any Suggestions on this one.
Thank you
"helpplease" wrote:
> SQL Server 2000, Service Pack 3.
> I have 4 Processors.
> Thank you
> "David Gugick" wrote:
> > helpplease wrote:
> > > Yes, I am seeing the same spid in sysprocesses listed multiple times.
> > >
> > > What could be the problem?
> > >
> > > Thank you
> > > Divya
> > >
> >
> > That's probably because the same spid is running in multiple threads on
> > multiple CPUs. 10-18 instances of a SPID sounds high. Not sure what is
> > really going on. What version (and SP) of SQL Server are you using? How
> > many CPUs?
> >
> > --
> > David Gugick
> > Quest Software
> > www.imceda.com
> > www.quest.com
> >
> >
Monday, March 26, 2012
Multiple Instance cluster
Hi,
I am going to setup 2 instances of SQL Server 2000 in a 2-nodes clustered
environment with each instance running on each node in a normal operation.
Each node will act as a failover of the other node. I am not very certain
that I understand how to do it. Here's what I am going to do.
1) Setup the 2 nodes cluster.
2) Create 2 SQL Cluster group2 with each group having their own resources
(e.g. disk, IP, DTC, etc)
3) Install the 1st instance and assign it with a virtual name.
4) Install the 2nd instance and assgin another virtual name.
Do I miss out anything or anything that I need to take note?
Thanks You,
Alex
Looks like you are well on your way. Make sure and set the correct
preferred nodes order on the cluster administration tool so that each
instance knows where it wants to live under 'normal' operating conditions.
Also, make sure you don't overcommit memory. You will need to leave enough
memory so you can 'stack' both instances on a single server in a failure
condition.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Alex" <Yukon@.nospam.nospam> wrote in message
news:%231IbTEUrEHA.3848@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I am going to setup 2 instances of SQL Server 2000 in a 2-nodes clustered
> environment with each instance running on each node in a normal operation.
> Each node will act as a failover of the other node. I am not very certain
> that I understand how to do it. Here's what I am going to do.
> 1) Setup the 2 nodes cluster.
> 2) Create 2 SQL Cluster group2 with each group having their own resources
> (e.g. disk, IP, DTC, etc)
> 3) Install the 1st instance and assign it with a virtual name.
> 4) Install the 2nd instance and assgin another virtual name.
> Do I miss out anything or anything that I need to take note?
>
> Thanks You,
> Alex
>
|||Thanks for the advice :o)
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uwY11RUrEHA.3288@.TK2MSFTNGP12.phx.gbl...
> Looks like you are well on your way. Make sure and set the correct
> preferred nodes order on the cluster administration tool so that each
> instance knows where it wants to live under 'normal' operating conditions.
> Also, make sure you don't overcommit memory. You will need to leave
> enough
> memory so you can 'stack' both instances on a single server in a failure
> condition.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Alex" <Yukon@.nospam.nospam> wrote in message
> news:%231IbTEUrEHA.3848@.TK2MSFTNGP14.phx.gbl...
>
|||Hi,
FIrst of all, I would show my gratidute for MVP Geoff N. Hiten's
suggestions!
Additionally, I would love to show some useful documents for your reference
and hope this helps
SQL Server 2000 Failover Clustering White Paper
http://www.microsoft.com/technet/pro.../failclus.mspx
Support WebCast: Introduction to Microsoft SQL Server 2000 Clustering
http://support.microsoft.com/default...b;en-us;325106
INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
http://support.microsoft.com/?id=260758
Installation order for SQL Server 2000 Enterprise Edition on Microsoft
Cluster Server
http://support.microsoft.com/?id=243218
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Thanks Mingqing.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:jBO9LobrEHA.2500@.cpmsftngxa06.phx.gbl...
> Hi,
> FIrst of all, I would show my gratidute for MVP Geoff N. Hiten's
> suggestions!
> Additionally, I would love to show some useful documents for your
> reference
> and hope this helps
> SQL Server 2000 Failover Clustering White Paper
> http://www.microsoft.com/technet/pro.../failclus.mspx
> Support WebCast: Introduction to Microsoft SQL Server 2000 Clustering
> http://support.microsoft.com/default...b;en-us;325106
> INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
> http://support.microsoft.com/?id=260758
> Installation order for SQL Server 2000 Enterprise Edition on Microsoft
> Cluster Server
> http://support.microsoft.com/?id=243218
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||Hi Alex,
Thanks for your prompt updates!
If you encountered any questions or concerns on setup or configuration
multiple instances clustering environment. Don't hesitate to let me know.
We are always here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
I am going to setup 2 instances of SQL Server 2000 in a 2-nodes clustered
environment with each instance running on each node in a normal operation.
Each node will act as a failover of the other node. I am not very certain
that I understand how to do it. Here's what I am going to do.
1) Setup the 2 nodes cluster.
2) Create 2 SQL Cluster group2 with each group having their own resources
(e.g. disk, IP, DTC, etc)
3) Install the 1st instance and assign it with a virtual name.
4) Install the 2nd instance and assgin another virtual name.
Do I miss out anything or anything that I need to take note?
Thanks You,
Alex
Looks like you are well on your way. Make sure and set the correct
preferred nodes order on the cluster administration tool so that each
instance knows where it wants to live under 'normal' operating conditions.
Also, make sure you don't overcommit memory. You will need to leave enough
memory so you can 'stack' both instances on a single server in a failure
condition.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Alex" <Yukon@.nospam.nospam> wrote in message
news:%231IbTEUrEHA.3848@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I am going to setup 2 instances of SQL Server 2000 in a 2-nodes clustered
> environment with each instance running on each node in a normal operation.
> Each node will act as a failover of the other node. I am not very certain
> that I understand how to do it. Here's what I am going to do.
> 1) Setup the 2 nodes cluster.
> 2) Create 2 SQL Cluster group2 with each group having their own resources
> (e.g. disk, IP, DTC, etc)
> 3) Install the 1st instance and assign it with a virtual name.
> 4) Install the 2nd instance and assgin another virtual name.
> Do I miss out anything or anything that I need to take note?
>
> Thanks You,
> Alex
>
|||Thanks for the advice :o)
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uwY11RUrEHA.3288@.TK2MSFTNGP12.phx.gbl...
> Looks like you are well on your way. Make sure and set the correct
> preferred nodes order on the cluster administration tool so that each
> instance knows where it wants to live under 'normal' operating conditions.
> Also, make sure you don't overcommit memory. You will need to leave
> enough
> memory so you can 'stack' both instances on a single server in a failure
> condition.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Alex" <Yukon@.nospam.nospam> wrote in message
> news:%231IbTEUrEHA.3848@.TK2MSFTNGP14.phx.gbl...
>
|||Hi,
FIrst of all, I would show my gratidute for MVP Geoff N. Hiten's
suggestions!
Additionally, I would love to show some useful documents for your reference
and hope this helps
SQL Server 2000 Failover Clustering White Paper
http://www.microsoft.com/technet/pro.../failclus.mspx
Support WebCast: Introduction to Microsoft SQL Server 2000 Clustering
http://support.microsoft.com/default...b;en-us;325106
INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
http://support.microsoft.com/?id=260758
Installation order for SQL Server 2000 Enterprise Edition on Microsoft
Cluster Server
http://support.microsoft.com/?id=243218
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Thanks Mingqing.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:jBO9LobrEHA.2500@.cpmsftngxa06.phx.gbl...
> Hi,
> FIrst of all, I would show my gratidute for MVP Geoff N. Hiten's
> suggestions!
> Additionally, I would love to show some useful documents for your
> reference
> and hope this helps
> SQL Server 2000 Failover Clustering White Paper
> http://www.microsoft.com/technet/pro.../failclus.mspx
> Support WebCast: Introduction to Microsoft SQL Server 2000 Clustering
> http://support.microsoft.com/default...b;en-us;325106
> INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
> http://support.microsoft.com/?id=260758
> Installation order for SQL Server 2000 Enterprise Edition on Microsoft
> Cluster Server
> http://support.microsoft.com/?id=243218
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||Hi Alex,
Thanks for your prompt updates!
If you encountered any questions or concerns on setup or configuration
multiple instances clustering environment. Don't hesitate to let me know.
We are always here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
Multiple Instance cluster
Hi,
I am going to setup 2 instances of SQL Server 2000 in a 2-nodes clustered
environment with each instance running on each node in a normal operation.
Each node will act as a failover of the other node. I am not very certain
that I understand how to do it. Here's what I am going to do.
1) Setup the 2 nodes cluster.
2) Create 2 SQL Cluster group2 with each group having their own resources
(e.g. disk, IP, DTC, etc)
3) Install the 1st instance and assign it with a virtual name.
4) Install the 2nd instance and assgin another virtual name.
Do I miss out anything or anything that I need to take note?
Thanks You,
AlexLooks like you are well on your way. Make sure and set the correct
preferred nodes order on the cluster administration tool so that each
instance knows where it wants to live under 'normal' operating conditions.
Also, make sure you don't overcommit memory. You will need to leave enough
memory so you can 'stack' both instances on a single server in a failure
condition.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Alex" <Yukon@.nospam.nospam> wrote in message
news:%231IbTEUrEHA.3848@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I am going to setup 2 instances of SQL Server 2000 in a 2-nodes clustered
> environment with each instance running on each node in a normal operation.
> Each node will act as a failover of the other node. I am not very certain
> that I understand how to do it. Here's what I am going to do.
> 1) Setup the 2 nodes cluster.
> 2) Create 2 SQL Cluster group2 with each group having their own resources
> (e.g. disk, IP, DTC, etc)
> 3) Install the 1st instance and assign it with a virtual name.
> 4) Install the 2nd instance and assgin another virtual name.
> Do I miss out anything or anything that I need to take note?
>
> Thanks You,
> Alex
>|||Thanks for the advice :o)
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uwY11RUrEHA.3288@.TK2MSFTNGP12.phx.gbl...
> Looks like you are well on your way. Make sure and set the correct
> preferred nodes order on the cluster administration tool so that each
> instance knows where it wants to live under 'normal' operating conditions.
> Also, make sure you don't overcommit memory. You will need to leave
> enough
> memory so you can 'stack' both instances on a single server in a failure
> condition.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Alex" <Yukon@.nospam.nospam> wrote in message
> news:%231IbTEUrEHA.3848@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> I am going to setup 2 instances of SQL Server 2000 in a 2-nodes clustered
>> environment with each instance running on each node in a normal
>> operation.
>> Each node will act as a failover of the other node. I am not very
>> certain
>> that I understand how to do it. Here's what I am going to do.
>> 1) Setup the 2 nodes cluster.
>> 2) Create 2 SQL Cluster group2 with each group having their own resources
>> (e.g. disk, IP, DTC, etc)
>> 3) Install the 1st instance and assign it with a virtual name.
>> 4) Install the 2nd instance and assgin another virtual name.
>> Do I miss out anything or anything that I need to take note?
>>
>> Thanks You,
>> Alex
>>
>|||Hi,
FIrst of all, I would show my gratidute for MVP Geoff N. Hiten's
suggestions!
Additionally, I would love to show some useful documents for your reference
and hope this helps
SQL Server 2000 Failover Clustering White Paper
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
Support WebCast: Introduction to Microsoft SQL Server 2000 Clustering
http://support.microsoft.com/default.aspx?scid=kb;en-us;325106
INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
http://support.microsoft.com/?id=260758
Installation order for SQL Server 2000 Enterprise Edition on Microsoft
Cluster Server
http://support.microsoft.com/?id=243218
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Thanks Mingqing.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:jBO9LobrEHA.2500@.cpmsftngxa06.phx.gbl...
> Hi,
> FIrst of all, I would show my gratidute for MVP Geoff N. Hiten's
> suggestions!
> Additionally, I would love to show some useful documents for your
> reference
> and hope this helps
> SQL Server 2000 Failover Clustering White Paper
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
> Support WebCast: Introduction to Microsoft SQL Server 2000 Clustering
> http://support.microsoft.com/default.aspx?scid=kb;en-us;325106
> INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
> http://support.microsoft.com/?id=260758
> Installation order for SQL Server 2000 Enterprise Edition on Microsoft
> Cluster Server
> http://support.microsoft.com/?id=243218
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Alex,
Thanks for your prompt updates!
If you encountered any questions or concerns on setup or configuration
multiple instances clustering environment. Don't hesitate to let me know.
We are always here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
I am going to setup 2 instances of SQL Server 2000 in a 2-nodes clustered
environment with each instance running on each node in a normal operation.
Each node will act as a failover of the other node. I am not very certain
that I understand how to do it. Here's what I am going to do.
1) Setup the 2 nodes cluster.
2) Create 2 SQL Cluster group2 with each group having their own resources
(e.g. disk, IP, DTC, etc)
3) Install the 1st instance and assign it with a virtual name.
4) Install the 2nd instance and assgin another virtual name.
Do I miss out anything or anything that I need to take note?
Thanks You,
AlexLooks like you are well on your way. Make sure and set the correct
preferred nodes order on the cluster administration tool so that each
instance knows where it wants to live under 'normal' operating conditions.
Also, make sure you don't overcommit memory. You will need to leave enough
memory so you can 'stack' both instances on a single server in a failure
condition.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Alex" <Yukon@.nospam.nospam> wrote in message
news:%231IbTEUrEHA.3848@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I am going to setup 2 instances of SQL Server 2000 in a 2-nodes clustered
> environment with each instance running on each node in a normal operation.
> Each node will act as a failover of the other node. I am not very certain
> that I understand how to do it. Here's what I am going to do.
> 1) Setup the 2 nodes cluster.
> 2) Create 2 SQL Cluster group2 with each group having their own resources
> (e.g. disk, IP, DTC, etc)
> 3) Install the 1st instance and assign it with a virtual name.
> 4) Install the 2nd instance and assgin another virtual name.
> Do I miss out anything or anything that I need to take note?
>
> Thanks You,
> Alex
>|||Thanks for the advice :o)
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uwY11RUrEHA.3288@.TK2MSFTNGP12.phx.gbl...
> Looks like you are well on your way. Make sure and set the correct
> preferred nodes order on the cluster administration tool so that each
> instance knows where it wants to live under 'normal' operating conditions.
> Also, make sure you don't overcommit memory. You will need to leave
> enough
> memory so you can 'stack' both instances on a single server in a failure
> condition.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Alex" <Yukon@.nospam.nospam> wrote in message
> news:%231IbTEUrEHA.3848@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> I am going to setup 2 instances of SQL Server 2000 in a 2-nodes clustered
>> environment with each instance running on each node in a normal
>> operation.
>> Each node will act as a failover of the other node. I am not very
>> certain
>> that I understand how to do it. Here's what I am going to do.
>> 1) Setup the 2 nodes cluster.
>> 2) Create 2 SQL Cluster group2 with each group having their own resources
>> (e.g. disk, IP, DTC, etc)
>> 3) Install the 1st instance and assign it with a virtual name.
>> 4) Install the 2nd instance and assgin another virtual name.
>> Do I miss out anything or anything that I need to take note?
>>
>> Thanks You,
>> Alex
>>
>|||Hi,
FIrst of all, I would show my gratidute for MVP Geoff N. Hiten's
suggestions!
Additionally, I would love to show some useful documents for your reference
and hope this helps
SQL Server 2000 Failover Clustering White Paper
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
Support WebCast: Introduction to Microsoft SQL Server 2000 Clustering
http://support.microsoft.com/default.aspx?scid=kb;en-us;325106
INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
http://support.microsoft.com/?id=260758
Installation order for SQL Server 2000 Enterprise Edition on Microsoft
Cluster Server
http://support.microsoft.com/?id=243218
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Thanks Mingqing.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:jBO9LobrEHA.2500@.cpmsftngxa06.phx.gbl...
> Hi,
> FIrst of all, I would show my gratidute for MVP Geoff N. Hiten's
> suggestions!
> Additionally, I would love to show some useful documents for your
> reference
> and hope this helps
> SQL Server 2000 Failover Clustering White Paper
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
> Support WebCast: Introduction to Microsoft SQL Server 2000 Clustering
> http://support.microsoft.com/default.aspx?scid=kb;en-us;325106
> INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
> http://support.microsoft.com/?id=260758
> Installation order for SQL Server 2000 Enterprise Edition on Microsoft
> Cluster Server
> http://support.microsoft.com/?id=243218
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Alex,
Thanks for your prompt updates!
If you encountered any questions or concerns on setup or configuration
multiple instances clustering environment. Don't hesitate to let me know.
We are always here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
Monday, March 12, 2012
Multiple Databases one report
I have two DBs that are identical (MOM2K5 SCDW) and I want to have both as
data sources for reports. I have setup a second data source and I don't see
the info I excpect. If I take the same connection string and enter it into
the original data source it gets info from my second DB so I know the
connection string on the second data source is ok. Do I have to do something
other than simply create the second data source? I was really excited
because after working on this for close to forever it was all working.
Unfortunately, I came in the next morning and it wasn't. I'm at an impass
and would appreciate any help I can get.There is some information on modifying your datasource (or connection string)
on the fly in this section:
Search for: datasource "on-the-fly"
THis will allow you to specify your datasource as a parameter.
"Scottshark" wrote:
> I have two DBs that are identical (MOM2K5 SCDW) and I want to have both as
> data sources for reports. I have setup a second data source and I don't see
> the info I excpect. If I take the same connection string and enter it into
> the original data source it gets info from my second DB so I know the
> connection string on the second data source is ok. Do I have to do something
> other than simply create the second data source? I was really excited
> because after working on this for close to forever it was all working.
> Unfortunately, I came in the next morning and it wasn't. I'm at an impass
> and would appreciate any help I can get.
data sources for reports. I have setup a second data source and I don't see
the info I excpect. If I take the same connection string and enter it into
the original data source it gets info from my second DB so I know the
connection string on the second data source is ok. Do I have to do something
other than simply create the second data source? I was really excited
because after working on this for close to forever it was all working.
Unfortunately, I came in the next morning and it wasn't. I'm at an impass
and would appreciate any help I can get.There is some information on modifying your datasource (or connection string)
on the fly in this section:
Search for: datasource "on-the-fly"
THis will allow you to specify your datasource as a parameter.
"Scottshark" wrote:
> I have two DBs that are identical (MOM2K5 SCDW) and I want to have both as
> data sources for reports. I have setup a second data source and I don't see
> the info I excpect. If I take the same connection string and enter it into
> the original data source it gets info from my second DB so I know the
> connection string on the second data source is ok. Do I have to do something
> other than simply create the second data source? I was really excited
> because after working on this for close to forever it was all working.
> Unfortunately, I came in the next morning and it wasn't. I'm at an impass
> and would appreciate any help I can get.
Saturday, February 25, 2012
Multiple Body Columns
How do I setup multiple columns in a report? For example: How would I take a
report that has 1 table with 1 column. Currently this one column is written
vertically down from top to bottom over 10 pages. If I repeat the column
multiple times on the same page I can cut the report down to 2 pages. In
Crystal Reports they call it "Formatting Groups with multiple columns". Can
anyone point me in the right direction?
Thanks!I have seen the columns property on the body, but when I set it to something
other than 1 shows multiple columns in design, but does not output them in
preview.
"Mike" <m@.m.com> wrote in message
news:eKOmV1mEIHA.5856@.TK2MSFTNGP04.phx.gbl...
> How do I setup multiple columns in a report? For example: How would I take
> a report that has 1 table with 1 column. Currently this one column is
> written vertically down from top to bottom over 10 pages. If I repeat the
> column multiple times on the same page I can cut the report down to 2
> pages. In Crystal Reports they call it "Formatting Groups with multiple
> columns". Can anyone point me in the right direction?
> Thanks!
>|||I read somewhere that this in only possible in certain rendering formats
(i.e. TIFF or printer, I can't remember which). I couldn't make it work in
any format, so I used a workaround with a stored proc that returns a dataset
with extra columns (in your case 4 or 6 columns) containing the extra
records. Then I put the data in a grid that has a blank, non-framed column
between each set of extra columns. I can send you a pdf of the output if you
like. If you don't know the exact number of pages, that solution might
become complicated. In my case, that part of the report never goes over one
page.
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Mike" <m@.m.com> wrote in message
news:eKOmV1mEIHA.5856@.TK2MSFTNGP04.phx.gbl...
> How do I setup multiple columns in a report? For example: How would I take
> a report that has 1 table with 1 column. Currently this one column is
> written vertically down from top to bottom over 10 pages. If I repeat the
> column multiple times on the same page I can cut the report down to 2
> pages. In Crystal Reports they call it "Formatting Groups with multiple
> columns". Can anyone point me in the right direction?
> Thanks!
>|||You're right! I tried to view the report as a tiff and as a PDF and they
displayed properly. I should be able to use that. Too bad the HTML format
doesn't work. Thanks for the lead on this.
Mike
"Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
news:uW9mxInEIHA.1208@.TK2MSFTNGP03.phx.gbl...
>I read somewhere that this in only possible in certain rendering formats
>(i.e. TIFF or printer, I can't remember which). I couldn't make it work in
>any format, so I used a workaround with a stored proc that returns a
>dataset with extra columns (in your case 4 or 6 columns) containing the
>extra records. Then I put the data in a grid that has a blank, non-framed
>column between each set of extra columns. I can send you a pdf of the
>output if you like. If you don't know the exact number of pages, that
>solution might become complicated. In my case, that part of the report
>never goes over one page.
> --
>
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>
> "Mike" <m@.m.com> wrote in message
> news:eKOmV1mEIHA.5856@.TK2MSFTNGP04.phx.gbl...
>> How do I setup multiple columns in a report? For example: How would I
>> take a report that has 1 table with 1 column. Currently this one column
>> is written vertically down from top to bottom over 10 pages. If I repeat
>> the column multiple times on the same page I can cut the report down to 2
>> pages. In Crystal Reports they call it "Formatting Groups with multiple
>> columns". Can anyone point me in the right direction?
>> Thanks!
>|||I just checked. The printer output also works (i. .e. paper).
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Mike" <m@.m.com> wrote in message
news:OqwTOJpEIHA.5208@.TK2MSFTNGP04.phx.gbl...
> You're right! I tried to view the report as a tiff and as a PDF and they
> displayed properly. I should be able to use that. Too bad the HTML format
> doesn't work. Thanks for the lead on this.
> Mike
> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
> news:uW9mxInEIHA.1208@.TK2MSFTNGP03.phx.gbl...
>>I read somewhere that this in only possible in certain rendering formats
>>(i.e. TIFF or printer, I can't remember which). I couldn't make it work in
>>any format, so I used a workaround with a stored proc that returns a
>>dataset with extra columns (in your case 4 or 6 columns) containing the
>>extra records. Then I put the data in a grid that has a blank, non-framed
>>column between each set of extra columns. I can send you a pdf of the
>>output if you like. If you don't know the exact number of pages, that
>>solution might become complicated. In my case, that part of the report
>>never goes over one page.
>> --
>>
>> Alain Quesnel
>> alainsansspam@.logiquel.com
>> www.logiquel.com
>>
>> "Mike" <m@.m.com> wrote in message
>> news:eKOmV1mEIHA.5856@.TK2MSFTNGP04.phx.gbl...
>> How do I setup multiple columns in a report? For example: How would I
>> take a report that has 1 table with 1 column. Currently this one column
>> is written vertically down from top to bottom over 10 pages. If I repeat
>> the column multiple times on the same page I can cut the report down to
>> 2 pages. In Crystal Reports they call it "Formatting Groups with
>> multiple columns". Can anyone point me in the right direction?
>> Thanks!
>>
>|||You can find more information about Multi-Column reports and how to
make/design them at the link here:
http://msdn2.microsoft.com/en-us/library/ms155816.aspx
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: "Mike" <m@.m.com>
> Subject: Multiple Body Columns
> Date: Fri, 19 Oct 2007 09:30:20 -0700
> Lines: 10
> How do I setup multiple columns in a report? For example: How would I
take a
> report that has 1 table with 1 column. Currently this one column is
written
> vertically down from top to bottom over 10 pages. If I repeat the column
> multiple times on the same page I can cut the report down to 2 pages. In
> Crystal Reports they call it "Formatting Groups with multiple columns".
Can
> anyone point me in the right direction?
> Thanks!
>
>
report that has 1 table with 1 column. Currently this one column is written
vertically down from top to bottom over 10 pages. If I repeat the column
multiple times on the same page I can cut the report down to 2 pages. In
Crystal Reports they call it "Formatting Groups with multiple columns". Can
anyone point me in the right direction?
Thanks!I have seen the columns property on the body, but when I set it to something
other than 1 shows multiple columns in design, but does not output them in
preview.
"Mike" <m@.m.com> wrote in message
news:eKOmV1mEIHA.5856@.TK2MSFTNGP04.phx.gbl...
> How do I setup multiple columns in a report? For example: How would I take
> a report that has 1 table with 1 column. Currently this one column is
> written vertically down from top to bottom over 10 pages. If I repeat the
> column multiple times on the same page I can cut the report down to 2
> pages. In Crystal Reports they call it "Formatting Groups with multiple
> columns". Can anyone point me in the right direction?
> Thanks!
>|||I read somewhere that this in only possible in certain rendering formats
(i.e. TIFF or printer, I can't remember which). I couldn't make it work in
any format, so I used a workaround with a stored proc that returns a dataset
with extra columns (in your case 4 or 6 columns) containing the extra
records. Then I put the data in a grid that has a blank, non-framed column
between each set of extra columns. I can send you a pdf of the output if you
like. If you don't know the exact number of pages, that solution might
become complicated. In my case, that part of the report never goes over one
page.
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Mike" <m@.m.com> wrote in message
news:eKOmV1mEIHA.5856@.TK2MSFTNGP04.phx.gbl...
> How do I setup multiple columns in a report? For example: How would I take
> a report that has 1 table with 1 column. Currently this one column is
> written vertically down from top to bottom over 10 pages. If I repeat the
> column multiple times on the same page I can cut the report down to 2
> pages. In Crystal Reports they call it "Formatting Groups with multiple
> columns". Can anyone point me in the right direction?
> Thanks!
>|||You're right! I tried to view the report as a tiff and as a PDF and they
displayed properly. I should be able to use that. Too bad the HTML format
doesn't work. Thanks for the lead on this.
Mike
"Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
news:uW9mxInEIHA.1208@.TK2MSFTNGP03.phx.gbl...
>I read somewhere that this in only possible in certain rendering formats
>(i.e. TIFF or printer, I can't remember which). I couldn't make it work in
>any format, so I used a workaround with a stored proc that returns a
>dataset with extra columns (in your case 4 or 6 columns) containing the
>extra records. Then I put the data in a grid that has a blank, non-framed
>column between each set of extra columns. I can send you a pdf of the
>output if you like. If you don't know the exact number of pages, that
>solution might become complicated. In my case, that part of the report
>never goes over one page.
> --
>
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>
> "Mike" <m@.m.com> wrote in message
> news:eKOmV1mEIHA.5856@.TK2MSFTNGP04.phx.gbl...
>> How do I setup multiple columns in a report? For example: How would I
>> take a report that has 1 table with 1 column. Currently this one column
>> is written vertically down from top to bottom over 10 pages. If I repeat
>> the column multiple times on the same page I can cut the report down to 2
>> pages. In Crystal Reports they call it "Formatting Groups with multiple
>> columns". Can anyone point me in the right direction?
>> Thanks!
>|||I just checked. The printer output also works (i. .e. paper).
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Mike" <m@.m.com> wrote in message
news:OqwTOJpEIHA.5208@.TK2MSFTNGP04.phx.gbl...
> You're right! I tried to view the report as a tiff and as a PDF and they
> displayed properly. I should be able to use that. Too bad the HTML format
> doesn't work. Thanks for the lead on this.
> Mike
> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
> news:uW9mxInEIHA.1208@.TK2MSFTNGP03.phx.gbl...
>>I read somewhere that this in only possible in certain rendering formats
>>(i.e. TIFF or printer, I can't remember which). I couldn't make it work in
>>any format, so I used a workaround with a stored proc that returns a
>>dataset with extra columns (in your case 4 or 6 columns) containing the
>>extra records. Then I put the data in a grid that has a blank, non-framed
>>column between each set of extra columns. I can send you a pdf of the
>>output if you like. If you don't know the exact number of pages, that
>>solution might become complicated. In my case, that part of the report
>>never goes over one page.
>> --
>>
>> Alain Quesnel
>> alainsansspam@.logiquel.com
>> www.logiquel.com
>>
>> "Mike" <m@.m.com> wrote in message
>> news:eKOmV1mEIHA.5856@.TK2MSFTNGP04.phx.gbl...
>> How do I setup multiple columns in a report? For example: How would I
>> take a report that has 1 table with 1 column. Currently this one column
>> is written vertically down from top to bottom over 10 pages. If I repeat
>> the column multiple times on the same page I can cut the report down to
>> 2 pages. In Crystal Reports they call it "Formatting Groups with
>> multiple columns". Can anyone point me in the right direction?
>> Thanks!
>>
>|||You can find more information about Multi-Column reports and how to
make/design them at the link here:
http://msdn2.microsoft.com/en-us/library/ms155816.aspx
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: "Mike" <m@.m.com>
> Subject: Multiple Body Columns
> Date: Fri, 19 Oct 2007 09:30:20 -0700
> Lines: 10
> How do I setup multiple columns in a report? For example: How would I
take a
> report that has 1 table with 1 column. Currently this one column is
written
> vertically down from top to bottom over 10 pages. If I repeat the column
> multiple times on the same page I can cut the report down to 2 pages. In
> Crystal Reports they call it "Formatting Groups with multiple columns".
Can
> anyone point me in the right direction?
> Thanks!
>
>
multiple backups and log shipping question
Hi,
I want to setup log shipping to a remote site for disaster
recovery purpouses for a SQL 7 database.
The question is how log shipping will intefere with my
current backups on local site which I need to keep?
I am doing a full db backup each night daily and one
transaction log backup done at noon.
For log shipping I would like to have a full restore done
at the end of the month and transaction logs every 15
minutes.
Is there any way of implementing this log shipping and
keeping also the daily local full backup plan?
Thank you,
Zorba
Zorba,
After you have the log-shipping process running, you can continue to perform
full and differential database backups of your production database, in
accordance with your usual backup schedule, without interfering with log
shipping. See
(http://www.winnetmag.com/SQLServer/A...804/15804.html).
hth,
Paul Ibison
I want to setup log shipping to a remote site for disaster
recovery purpouses for a SQL 7 database.
The question is how log shipping will intefere with my
current backups on local site which I need to keep?
I am doing a full db backup each night daily and one
transaction log backup done at noon.
For log shipping I would like to have a full restore done
at the end of the month and transaction logs every 15
minutes.
Is there any way of implementing this log shipping and
keeping also the daily local full backup plan?
Thank you,
Zorba
Zorba,
After you have the log-shipping process running, you can continue to perform
full and differential database backups of your production database, in
accordance with your usual backup schedule, without interfering with log
shipping. See
(http://www.winnetmag.com/SQLServer/A...804/15804.html).
hth,
Paul Ibison
Subscribe to:
Posts (Atom)