I'm preparing to add a second cpu to our server that runs
SQL Server 7 database software. Are there any changes I
need to make to SQL 7 platform to get database to
recognize the second processor?
The OS is Windows NT Server 4.0 SP6a
Thanks,
GregThe hard bit is getting NT4 to pick it up :-)
As Keith says , once that's done then SQL will pick it up automatically
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Gregory Dover" <gdovernospam@.bolingbrook.com> wrote in message
news:056401c35b8f$5b65b930$a101280a@.phx.gbl...
I'm preparing to add a second cpu to our server that runs
SQL Server 7 database software. Are there any changes I
need to make to SQL 7 platform to get database to
recognize the second processor?
The OS is Windows NT Server 4.0 SP6a
Thanks,
Greg|||Would this also be true for an OS of Windows 2000
Professional?
>--Original Message--
>SQL Server should see it after you get NT to recognize
the second processor.
>--
>Keith, SQL Server MVP
>"Gregory Dover" <gdovernospam@.bolingbrook.com> wrote in
message news:056401c35b8f$5b65b930$a101280a@.phx.gbl...
>> I'm preparing to add a second cpu to our server that
runs
>> SQL Server 7 database software. Are there any changes
I
>> need to make to SQL 7 platform to get database to
>> recognize the second processor?
>> The OS is Windows NT Server 4.0 SP6a
>> Thanks,
>>
>> Greg
>.
>sql
Showing posts with label software. Show all posts
Showing posts with label software. Show all posts
Thursday, March 22, 2012
Sunday, February 12, 2012
Ad hoc reporting for sql server
Hi,
I am looking for a software or a reporting tool for end user to general ad
hoc reports. the backend is sql server.
Does anyone know what is the best reporting software for end users out there
in the market?
Thanks
Henry
I have limited experience of the competition but SQL Server Reporting
Services certainly fits the spec. You can define a report model which the
users use as a basis (sort of 'Universe') and the web Reports Manager allows
them to use Report Builder locally to create and then upload ad-hoc reports.
I looked at this myself but then ultimately decided that this would be too
much of a maintenance headache, so we decided to use change requests to be
sent to the database developers to create and manage the reports centrally
instead.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||Thanks,
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OwnlnBSUHHA.4844@.TK2MSFTNGP03.phx.gbl...
>I have limited experience of the competition but SQL Server Reporting
>Services certainly fits the spec. You can define a report model which the
>users use as a basis (sort of 'Universe') and the web Reports Manager
>allows them to use Report Builder locally to create and then upload ad-hoc
>reports. I looked at this myself but then ultimately decided that this
>would be too much of a maintenance headache, so we decided to use change
>requests to be sent to the database developers to create and manage the
>reports centrally instead.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
I am looking for a software or a reporting tool for end user to general ad
hoc reports. the backend is sql server.
Does anyone know what is the best reporting software for end users out there
in the market?
Thanks
Henry
I have limited experience of the competition but SQL Server Reporting
Services certainly fits the spec. You can define a report model which the
users use as a basis (sort of 'Universe') and the web Reports Manager allows
them to use Report Builder locally to create and then upload ad-hoc reports.
I looked at this myself but then ultimately decided that this would be too
much of a maintenance headache, so we decided to use change requests to be
sent to the database developers to create and manage the reports centrally
instead.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||Thanks,
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OwnlnBSUHHA.4844@.TK2MSFTNGP03.phx.gbl...
>I have limited experience of the competition but SQL Server Reporting
>Services certainly fits the spec. You can define a report model which the
>users use as a basis (sort of 'Universe') and the web Reports Manager
>allows them to use Report Builder locally to create and then upload ad-hoc
>reports. I looked at this myself but then ultimately decided that this
>would be too much of a maintenance headache, so we decided to use change
>requests to be sent to the database developers to create and manage the
>reports centrally instead.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
Ad hoc reporting for sql server
Hi,
I am looking for a software or a reporting tool for end user to general ad
hoc reports. the backend is sql server.
Does anyone know what is the best reporting software for end users out there
in the market?
Thanks
HenryI have limited experience of the competition but SQL Server Reporting
Services certainly fits the spec. You can define a report model which the
users use as a basis (sort of 'Universe') and the web Reports Manager allows
them to use Report Builder locally to create and then upload ad-hoc reports.
I looked at this myself but then ultimately decided that this would be too
much of a maintenance headache, so we decided to use change requests to be
sent to the database developers to create and manage the reports centrally
instead.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Thanks,
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OwnlnBSUHHA.4844@.TK2MSFTNGP03.phx.gbl...
>I have limited experience of the competition but SQL Server Reporting
>Services certainly fits the spec. You can define a report model which the
>users use as a basis (sort of 'Universe') and the web Reports Manager
>allows them to use Report Builder locally to create and then upload ad-hoc
>reports. I looked at this myself but then ultimately decided that this
>would be too much of a maintenance headache, so we decided to use change
>requests to be sent to the database developers to create and manage the
>reports centrally instead.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
I am looking for a software or a reporting tool for end user to general ad
hoc reports. the backend is sql server.
Does anyone know what is the best reporting software for end users out there
in the market?
Thanks
HenryI have limited experience of the competition but SQL Server Reporting
Services certainly fits the spec. You can define a report model which the
users use as a basis (sort of 'Universe') and the web Reports Manager allows
them to use Report Builder locally to create and then upload ad-hoc reports.
I looked at this myself but then ultimately decided that this would be too
much of a maintenance headache, so we decided to use change requests to be
sent to the database developers to create and manage the reports centrally
instead.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Thanks,
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OwnlnBSUHHA.4844@.TK2MSFTNGP03.phx.gbl...
>I have limited experience of the competition but SQL Server Reporting
>Services certainly fits the spec. You can define a report model which the
>users use as a basis (sort of 'Universe') and the web Reports Manager
>allows them to use Report Builder locally to create and then upload ad-hoc
>reports. I looked at this myself but then ultimately decided that this
>would be too much of a maintenance headache, so we decided to use change
>requests to be sent to the database developers to create and manage the
>reports centrally instead.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
Ad hoc reporting for sql server
Hi,
I am looking for a software or a reporting tool for end user to general ad
hoc reports. the backend is sql server.
Does anyone know what is the best reporting software for end users out there
in the market?
Thanks
HenryI have limited experience of the competition but SQL Server Reporting
Services certainly fits the spec. You can define a report model which the
users use as a basis (sort of 'Universe') and the web Reports Manager allows
them to use Report Builder locally to create and then upload ad-hoc reports.
I looked at this myself but then ultimately decided that this would be too
much of a maintenance headache, so we decided to use change requests to be
sent to the database developers to create and manage the reports centrally
instead.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Thanks,
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OwnlnBSUHHA.4844@.TK2MSFTNGP03.phx.gbl...
>I have limited experience of the competition but SQL Server Reporting
>Services certainly fits the spec. You can define a report model which the
>users use as a basis (sort of 'Universe') and the web Reports Manager
>allows them to use Report Builder locally to create and then upload ad-hoc
>reports. I looked at this myself but then ultimately decided that this
>would be too much of a maintenance headache, so we decided to use change
>requests to be sent to the database developers to create and manage the
>reports centrally instead.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
I am looking for a software or a reporting tool for end user to general ad
hoc reports. the backend is sql server.
Does anyone know what is the best reporting software for end users out there
in the market?
Thanks
HenryI have limited experience of the competition but SQL Server Reporting
Services certainly fits the spec. You can define a report model which the
users use as a basis (sort of 'Universe') and the web Reports Manager allows
them to use Report Builder locally to create and then upload ad-hoc reports.
I looked at this myself but then ultimately decided that this would be too
much of a maintenance headache, so we decided to use change requests to be
sent to the database developers to create and manage the reports centrally
instead.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Thanks,
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OwnlnBSUHHA.4844@.TK2MSFTNGP03.phx.gbl...
>I have limited experience of the competition but SQL Server Reporting
>Services certainly fits the spec. You can define a report model which the
>users use as a basis (sort of 'Universe') and the web Reports Manager
>allows them to use Report Builder locally to create and then upload ad-hoc
>reports. I looked at this myself but then ultimately decided that this
>would be too much of a maintenance headache, so we decided to use change
>requests to be sent to the database developers to create and manage the
>reports centrally instead.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
Thursday, February 9, 2012
actual syntax by tracing
Hello
I am running 6.5 sql and work with a traffic and billing software ( called NOvar) from another company(encoda system) which does a lot of scheduling, reporting etc
I dont know the contents of table (100 table ) and their column
or which table its querying to take out reports
Can i create a trace to know the syntax each time some thing is executed.
I also need to create customized reports, can this be done by sql reporting or does i need to go from crystal reports or someone else
For i dont know any language except sql and HTML
sejDO you have SQL Server Client side tools installed?|||Yes i do have that installed
I am running 6.5 sql and work with a traffic and billing software ( called NOvar) from another company(encoda system) which does a lot of scheduling, reporting etc
I dont know the contents of table (100 table ) and their column
or which table its querying to take out reports
Can i create a trace to know the syntax each time some thing is executed.
I also need to create customized reports, can this be done by sql reporting or does i need to go from crystal reports or someone else
For i dont know any language except sql and HTML
sejDO you have SQL Server Client side tools installed?|||Yes i do have that installed
Subscribe to:
Posts (Atom)