I just purchased Micosoft SQL Server 2005 because I have a database/coldfusion/flash project and the company is sending me .sql files. When I click on the file to run it, it opens the anaylizer and connects. Next I execute the code and it seems to work fine. If I look in the output window I can see that it created the proper tables, but I don't know where they are. How do I get to them and export them in .mdb format so I can alter them?Open up Enterprise Manager and look in the databases there for the objects created.
To export them to Access (mdb file), try linking to them through Access using ODBC connection.
Showing posts with label company. Show all posts
Showing posts with label company. Show all posts
Monday, March 26, 2012
Newbie Question
I am replacing the computer expert in my company who just died until we get a replacement. I made some reports using the old database using the wizard. I am trying to get it to kick out reports in HTML and when I try building the program I get this error "The project cannot be deployed because no target server is specified. Provide a value for the TargetServerURL property in the property pages for this project.". What do you think the problem is?
Please read this section in MSDN: http://msdn2.microsoft.com/ms159270.aspx
The TargetServerUrl describes the URL of the report server you want to deploy your reports to. Right-click on the report project and open the properties dialog to find the TargetServerUrl.
-- Robert
|||I need it to deploy on the local host and not the internet as that is against company policy. I tried using c:\localhost\path and http:/localhost\path and that didn't work either.|||Assuming you have a report server installation on the local machine, using http://localhost/reportserver should work.
-- Robert
sqlNewbie question
hi,
I am interested in building a DW for my company. As usual, we have 4
different systems which holds different applications. I would like to know
what is the first step of buidling the DW? Retrieve the columns / data that
we need? Any good link to view?
Thanks so much
Ed
On Nov 5, 10:26 pm, Ed <E...@.discussions.microsoft.com> wrote:
> hi,
> I am interested in building a DW for my company. As usual, we have 4
> different systems which holds different applications. I would like to know
> what is the first step of buidling the DW? Retrieve the columns / data that
> we need? Any good link to view?
> Thanks so much
> Ed
The first step is to close your eyes, take a deep breath, and prepare
for a long and exciting journey.
I am _very_ new to the DW/BI scene so bear that in mind when reading
this post.
I have found these websites helpful:
http://www.dwinfocenter.org/
http://www.kimballgroup.com/
However, what works best for me is the old-fashioned approach: book
learning combined with trail-and-error. You might want to stop by a
bookstore (or use Amazon's "Search Inside" feature) and flip through
some of these titles: http://www.kimballgroup.com/html/books.html
I all but stopped buying technical books several years ago because the
information is often outdated by the time the book goes to press.
Having said that, for a subject that is deep, wide, and unfamiliar,
trying to get up to speed using only internet searches can be
frustrating and counterproductive.
Best wishes on your project!
|||You can hire my team!
"happy camper" <keenan@.p2sol.com> wrote in message
news:1194471643.414378.82940@.57g2000hsv.googlegrou ps.com...
> On Nov 5, 10:26 pm, Ed <E...@.discussions.microsoft.com> wrote:
> The first step is to close your eyes, take a deep breath, and prepare
> for a long and exciting journey.
> I am _very_ new to the DW/BI scene so bear that in mind when reading
> this post.
> I have found these websites helpful:
> http://www.dwinfocenter.org/
> http://www.kimballgroup.com/
> However, what works best for me is the old-fashioned approach: book
> learning combined with trail-and-error. You might want to stop by a
> bookstore (or use Amazon's "Search Inside" feature) and flip through
> some of these titles: http://www.kimballgroup.com/html/books.html
> I all but stopped buying technical books several years ago because the
> information is often outdated by the time the book goes to press.
> Having said that, for a subject that is deep, wide, and unfamiliar,
> trying to get up to speed using only internet searches can be
> frustrating and counterproductive.
> Best wishes on your project!
>
|||Gartner claimed a short time ago that DW efforts were the near 50% failure
rate.
Maybe start with just a data mart on a specific subject area on just one of
your 4 applications. Get the ETL working with SSIS, develop a cube in SSAS
and use Excel 2007 to browse cubes or just use SSMS.
Once you are succesful on a specific subject area then you can start pulling
in your other hetrogenous sources.
Without help you will flail about some - so if at all possible; hire some
assistance.
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:eS3A$SdIIHA.4196@.TK2MSFTNGP04.phx.gbl...
> "Ed" <Ed@.discussions.microsoft.com> wrote in message
> news:CD21EB5F-6FA2-422B-A115-CDCC5D5910AD@.microsoft.com...
> If you don't have BI experience then get some experienced assistance on
> site. A DW is only one part of a BI solution. To be successful and deliver
> value to your business customers you should first consider the whole
> end-to-end picture.
> --
> David Portas
>
|||To name just a few items: Create small wins for yourself by Implementing
incrementally, always working on those sections that will have the biggest
positive businss impact and can released in the shortest amount of time. If
you don't already know how to data model, learn. Read Ralph Kimball's books
on OLAP design and implementation
Sincerely,
John K
President
Knowledgy Consulting, LLC
1024 Spalding Forest Ct.
Atlanta, GA 30328
Knowledgy.org
Contact: Knowledgy$knowledgy.org
Replace $ with @. for emails
I am interested in building a DW for my company. As usual, we have 4
different systems which holds different applications. I would like to know
what is the first step of buidling the DW? Retrieve the columns / data that
we need? Any good link to view?
Thanks so much
Ed
On Nov 5, 10:26 pm, Ed <E...@.discussions.microsoft.com> wrote:
> hi,
> I am interested in building a DW for my company. As usual, we have 4
> different systems which holds different applications. I would like to know
> what is the first step of buidling the DW? Retrieve the columns / data that
> we need? Any good link to view?
> Thanks so much
> Ed
The first step is to close your eyes, take a deep breath, and prepare
for a long and exciting journey.
I am _very_ new to the DW/BI scene so bear that in mind when reading
this post.
I have found these websites helpful:
http://www.dwinfocenter.org/
http://www.kimballgroup.com/
However, what works best for me is the old-fashioned approach: book
learning combined with trail-and-error. You might want to stop by a
bookstore (or use Amazon's "Search Inside" feature) and flip through
some of these titles: http://www.kimballgroup.com/html/books.html
I all but stopped buying technical books several years ago because the
information is often outdated by the time the book goes to press.
Having said that, for a subject that is deep, wide, and unfamiliar,
trying to get up to speed using only internet searches can be
frustrating and counterproductive.
Best wishes on your project!
|||You can hire my team!
"happy camper" <keenan@.p2sol.com> wrote in message
news:1194471643.414378.82940@.57g2000hsv.googlegrou ps.com...
> On Nov 5, 10:26 pm, Ed <E...@.discussions.microsoft.com> wrote:
> The first step is to close your eyes, take a deep breath, and prepare
> for a long and exciting journey.
> I am _very_ new to the DW/BI scene so bear that in mind when reading
> this post.
> I have found these websites helpful:
> http://www.dwinfocenter.org/
> http://www.kimballgroup.com/
> However, what works best for me is the old-fashioned approach: book
> learning combined with trail-and-error. You might want to stop by a
> bookstore (or use Amazon's "Search Inside" feature) and flip through
> some of these titles: http://www.kimballgroup.com/html/books.html
> I all but stopped buying technical books several years ago because the
> information is often outdated by the time the book goes to press.
> Having said that, for a subject that is deep, wide, and unfamiliar,
> trying to get up to speed using only internet searches can be
> frustrating and counterproductive.
> Best wishes on your project!
>
|||Gartner claimed a short time ago that DW efforts were the near 50% failure
rate.
Maybe start with just a data mart on a specific subject area on just one of
your 4 applications. Get the ETL working with SSIS, develop a cube in SSAS
and use Excel 2007 to browse cubes or just use SSMS.
Once you are succesful on a specific subject area then you can start pulling
in your other hetrogenous sources.
Without help you will flail about some - so if at all possible; hire some
assistance.
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:eS3A$SdIIHA.4196@.TK2MSFTNGP04.phx.gbl...
> "Ed" <Ed@.discussions.microsoft.com> wrote in message
> news:CD21EB5F-6FA2-422B-A115-CDCC5D5910AD@.microsoft.com...
> If you don't have BI experience then get some experienced assistance on
> site. A DW is only one part of a BI solution. To be successful and deliver
> value to your business customers you should first consider the whole
> end-to-end picture.
> --
> David Portas
>
|||To name just a few items: Create small wins for yourself by Implementing
incrementally, always working on those sections that will have the biggest
positive businss impact and can released in the shortest amount of time. If
you don't already know how to data model, learn. Read Ralph Kimball's books
on OLAP design and implementation
Sincerely,
John K
President
Knowledgy Consulting, LLC
1024 Spalding Forest Ct.
Atlanta, GA 30328
Knowledgy.org
Contact: Knowledgy$knowledgy.org
Replace $ with @. for emails
newbie question
Hello,
I'm new to SQL server and I've just inherited a SQL server with a single
user database. The company would like to replicate it to sql server used for
reporting services. I'm thinking that transaction replication is the way to
go as the database is over 40 Gb in size. The only requirements are that the
database be available for reporting.
I've been looking into the database schema and Ive found that there are
seven tables with identity columns and other tables that dont have a primary
key. Can I still use transaction replication? do I need to make any changes
to teh schema?
Thanks
p.s. can somebody point me to a doc that highlights how to implement
transaction replication and what the various components are?
Troy,
for a reporting setup, transactional replication is often used. Log shipping
is sometimes used, but the users have to be disconnected when the logs are
restored which means a big latency if this is done out of office hours. As
for transactional replication, books on line (BOL) is a good resource, as
well as Hilary's book and some web articles
(http://www.mssqlcity.com/Articles/Re...TR/SetupTR.htm).
The main components are the 2 agents: snapshot and distribution whiche are
essentially jobs that run the associated replication executable. The
snapshot agent will create several text files and place them in the
distribution working folder - a share that the subscriber can see. The
distribution agent reads the distribution database to see what commands are
waiting to be executed. It loads the text files and applies them to the
subscriber and then it'll read any subsequent commands involving changes to
the data, and apply these also. Plenty of details in BOL, but what I'd
recommend is to complinment the reading and set it up on one machine by
replicating a table from Northwind to Pubs and so begin to get used to the
whole setup.
Finally, don't worry about the identity columns - they're not relevant for
your purposes and the identity property will not be retained on the
subscriber.
Good luck
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
I'm new to SQL server and I've just inherited a SQL server with a single
user database. The company would like to replicate it to sql server used for
reporting services. I'm thinking that transaction replication is the way to
go as the database is over 40 Gb in size. The only requirements are that the
database be available for reporting.
I've been looking into the database schema and Ive found that there are
seven tables with identity columns and other tables that dont have a primary
key. Can I still use transaction replication? do I need to make any changes
to teh schema?
Thanks
p.s. can somebody point me to a doc that highlights how to implement
transaction replication and what the various components are?
Troy,
for a reporting setup, transactional replication is often used. Log shipping
is sometimes used, but the users have to be disconnected when the logs are
restored which means a big latency if this is done out of office hours. As
for transactional replication, books on line (BOL) is a good resource, as
well as Hilary's book and some web articles
(http://www.mssqlcity.com/Articles/Re...TR/SetupTR.htm).
The main components are the 2 agents: snapshot and distribution whiche are
essentially jobs that run the associated replication executable. The
snapshot agent will create several text files and place them in the
distribution working folder - a share that the subscriber can see. The
distribution agent reads the distribution database to see what commands are
waiting to be executed. It loads the text files and applies them to the
subscriber and then it'll read any subsequent commands involving changes to
the data, and apply these also. Plenty of details in BOL, but what I'd
recommend is to complinment the reading and set it up on one machine by
replicating a table from Northwind to Pubs and so begin to get used to the
whole setup.
Finally, don't worry about the identity columns - they're not relevant for
your purposes and the identity property will not be retained on the
subscriber.
Good luck
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Friday, March 23, 2012
Newbie question
hi,
I am interested in building a DW for my company. As usual, we have 4
different systems which holds different applications. I would like to know
what is the first step of buidling the DW? Retrieve the columns / data that
we need? Any good link to view?
Thanks so much
EdOn Nov 5, 10:26 pm, Ed <E...@.discussions.microsoft.com> wrote:
> hi,
> I am interested in building a DW for my company. As usual, we have 4
> different systems which holds different applications. I would like to kno
w
> what is the first step of buidling the DW? Retrieve the columns / data th
at
> we need? Any good link to view?
> Thanks so much
> Ed
The first step is to close your eyes, take a deep breath, and prepare
for a long and exciting journey.
I am _very_ new to the DW/BI scene so bear that in mind when reading
this post.
I have found these websites helpful:
http://www.dwinfocenter.org/
http://www.kimballgroup.com/
However, what works best for me is the old-fashioned approach: book
learning combined with trail-and-error. You might want to stop by a
bookstore (or use Amazon's "Search Inside" feature) and flip through
some of these titles: http://www.kimballgroup.com/html/books.html
I all but stopped buying technical books several years ago because the
information is often outdated by the time the book goes to press.
Having said that, for a subject that is deep, wide, and unfamiliar,
trying to get up to speed using only internet searches can be
frustrating and counterproductive.
Best wishes on your project!|||You can hire my team!
"happy camper" <keenan@.p2sol.com> wrote in message
news:1194471643.414378.82940@.57g2000hsv.googlegroups.com...
> On Nov 5, 10:26 pm, Ed <E...@.discussions.microsoft.com> wrote:
> The first step is to close your eyes, take a deep breath, and prepare
> for a long and exciting journey.
> I am _very_ new to the DW/BI scene so bear that in mind when reading
> this post.
> I have found these websites helpful:
> http://www.dwinfocenter.org/
> http://www.kimballgroup.com/
> However, what works best for me is the old-fashioned approach: book
> learning combined with trail-and-error. You might want to stop by a
> bookstore (or use Amazon's "Search Inside" feature) and flip through
> some of these titles: http://www.kimballgroup.com/html/books.html
> I all but stopped buying technical books several years ago because the
> information is often outdated by the time the book goes to press.
> Having said that, for a subject that is deep, wide, and unfamiliar,
> trying to get up to speed using only internet searches can be
> frustrating and counterproductive.
> Best wishes on your project!
>|||"Ed" <Ed@.discussions.microsoft.com> wrote in message
news:CD21EB5F-6FA2-422B-A115-CDCC5D5910AD@.microsoft.com...
> hi,
> I am interested in building a DW for my company. As usual, we have 4
> different systems which holds different applications. I would like to
> know
> what is the first step of buidling the DW? Retrieve the columns / data
> that
> we need? Any good link to view?
> Thanks so much
> Ed
If you don't have BI experience then get some experienced assistance on
site. A DW is only one part of a BI solution. To be successful and deliver
value to your business customers you should first consider the whole
end-to-end picture.
David Portas|||Gartner claimed a short time ago that DW efforts were the near 50% failure
rate.
Maybe start with just a data mart on a specific subject area on just one of
your 4 applications. Get the ETL working with SSIS, develop a cube in SSAS
and use Excel 2007 to browse cubes or just use SSMS.
Once you are succesful on a specific subject area then you can start pulling
in your other hetrogenous sources.
Without help you will flail about some - so if at all possible; hire some
assistance.
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:eS3A$SdIIHA.4196@.TK2MSFTNGP04.phx.gbl...
> "Ed" <Ed@.discussions.microsoft.com> wrote in message
> news:CD21EB5F-6FA2-422B-A115-CDCC5D5910AD@.microsoft.com...
> If you don't have BI experience then get some experienced assistance on
> site. A DW is only one part of a BI solution. To be successful and deliver
> value to your business customers you should first consider the whole
> end-to-end picture.
> --
> David Portas
>|||To name just a few items: Create small wins for yourself by Implementing
incrementally, always working on those sections that will have the biggest
positive businss impact and can released in the shortest amount of time. If
you don't already know how to data model, learn. Read Ralph Kimball's books
on OLAP design and implementation
Sincerely,
John K
President
Knowledgy Consulting, LLC
1024 Spalding Forest Ct.
Atlanta, GA 30328
---
Knowledgy.org
---
Contact: Knowledgy$knowledgy.org
Replace $ with @. for emails
---
I am interested in building a DW for my company. As usual, we have 4
different systems which holds different applications. I would like to know
what is the first step of buidling the DW? Retrieve the columns / data that
we need? Any good link to view?
Thanks so much
EdOn Nov 5, 10:26 pm, Ed <E...@.discussions.microsoft.com> wrote:
> hi,
> I am interested in building a DW for my company. As usual, we have 4
> different systems which holds different applications. I would like to kno
w
> what is the first step of buidling the DW? Retrieve the columns / data th
at
> we need? Any good link to view?
> Thanks so much
> Ed
The first step is to close your eyes, take a deep breath, and prepare
for a long and exciting journey.
I am _very_ new to the DW/BI scene so bear that in mind when reading
this post.
I have found these websites helpful:
http://www.dwinfocenter.org/
http://www.kimballgroup.com/
However, what works best for me is the old-fashioned approach: book
learning combined with trail-and-error. You might want to stop by a
bookstore (or use Amazon's "Search Inside" feature) and flip through
some of these titles: http://www.kimballgroup.com/html/books.html
I all but stopped buying technical books several years ago because the
information is often outdated by the time the book goes to press.
Having said that, for a subject that is deep, wide, and unfamiliar,
trying to get up to speed using only internet searches can be
frustrating and counterproductive.
Best wishes on your project!|||You can hire my team!
"happy camper" <keenan@.p2sol.com> wrote in message
news:1194471643.414378.82940@.57g2000hsv.googlegroups.com...
> On Nov 5, 10:26 pm, Ed <E...@.discussions.microsoft.com> wrote:
> The first step is to close your eyes, take a deep breath, and prepare
> for a long and exciting journey.
> I am _very_ new to the DW/BI scene so bear that in mind when reading
> this post.
> I have found these websites helpful:
> http://www.dwinfocenter.org/
> http://www.kimballgroup.com/
> However, what works best for me is the old-fashioned approach: book
> learning combined with trail-and-error. You might want to stop by a
> bookstore (or use Amazon's "Search Inside" feature) and flip through
> some of these titles: http://www.kimballgroup.com/html/books.html
> I all but stopped buying technical books several years ago because the
> information is often outdated by the time the book goes to press.
> Having said that, for a subject that is deep, wide, and unfamiliar,
> trying to get up to speed using only internet searches can be
> frustrating and counterproductive.
> Best wishes on your project!
>|||"Ed" <Ed@.discussions.microsoft.com> wrote in message
news:CD21EB5F-6FA2-422B-A115-CDCC5D5910AD@.microsoft.com...
> hi,
> I am interested in building a DW for my company. As usual, we have 4
> different systems which holds different applications. I would like to
> know
> what is the first step of buidling the DW? Retrieve the columns / data
> that
> we need? Any good link to view?
> Thanks so much
> Ed
If you don't have BI experience then get some experienced assistance on
site. A DW is only one part of a BI solution. To be successful and deliver
value to your business customers you should first consider the whole
end-to-end picture.
David Portas|||Gartner claimed a short time ago that DW efforts were the near 50% failure
rate.
Maybe start with just a data mart on a specific subject area on just one of
your 4 applications. Get the ETL working with SSIS, develop a cube in SSAS
and use Excel 2007 to browse cubes or just use SSMS.
Once you are succesful on a specific subject area then you can start pulling
in your other hetrogenous sources.
Without help you will flail about some - so if at all possible; hire some
assistance.
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:eS3A$SdIIHA.4196@.TK2MSFTNGP04.phx.gbl...
> "Ed" <Ed@.discussions.microsoft.com> wrote in message
> news:CD21EB5F-6FA2-422B-A115-CDCC5D5910AD@.microsoft.com...
> If you don't have BI experience then get some experienced assistance on
> site. A DW is only one part of a BI solution. To be successful and deliver
> value to your business customers you should first consider the whole
> end-to-end picture.
> --
> David Portas
>|||To name just a few items: Create small wins for yourself by Implementing
incrementally, always working on those sections that will have the biggest
positive businss impact and can released in the shortest amount of time. If
you don't already know how to data model, learn. Read Ralph Kimball's books
on OLAP design and implementation
Sincerely,
John K
President
Knowledgy Consulting, LLC
1024 Spalding Forest Ct.
Atlanta, GA 30328
---
Knowledgy.org
---
Contact: Knowledgy$knowledgy.org
Replace $ with @. for emails
---
Newbie question
Hi All,
My company has a legacy web application (VBScript/ASP) that includes a
series of forms used to create various reports on SQL Server (or Oracle)
data. Creation of these reports is extremely tedious due to fairly
complicated calculations etc. My question for the group is: Is MS
Reporting Services a valid alternative to the way i'm doing things now? I
need to be able to create new interactive custom reports fairly easily and
link to them via the old web application.
Thanks In Advance,
TeddRS integrates pretty easily with custom web apps particularly for intranet
apps. You can use either URL integration or web services integration. URL
integration is the easiest and fullest featured (you have roll you own a lot
more when using web services). SQL Server reporting is very easy. The main
thing with Oracle is getting all the client apps installed and properly
configured (but that is not too untypical of anything concerning Oracle). I
go against Sybase and SQL Server. Others once up and running have been
successfull with Oracle. With RS 2005 (released in November) my expectation
is Oracle will be easier to go against. It also has a good many improvements
(my two favorites are dynamic sorting and multi-select parameters). I would
suggest getting the 90 day trial and give it a try.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Tedd Simms" <tedd.simms.SPAMTRAP@.cognostech.com> wrote in message
news:yf-dnbYtb-kzmF7fRVn-gQ@.novus-tele.net...
> Hi All,
> My company has a legacy web application (VBScript/ASP) that includes a
> series of forms used to create various reports on SQL Server (or Oracle)
> data. Creation of these reports is extremely tedious due to fairly
> complicated calculations etc. My question for the group is: Is MS
> Reporting Services a valid alternative to the way i'm doing things now? I
> need to be able to create new interactive custom reports fairly easily and
> link to them via the old web application.
> Thanks In Advance,
> Tedd
>|||"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:etoRWSPfFHA.1948@.TK2MSFTNGP12.phx.gbl...
> RS integrates pretty easily with custom web apps particularly for intranet
> apps. You can use either URL integration or web services integration. URL
> integration is the easiest and fullest featured (you have roll you own a
> lot more when using web services). SQL Server reporting is very easy. The
> main thing with Oracle is getting all the client apps installed and
> properly configured (but that is not too untypical of anything concerning
> Oracle). I go against Sybase and SQL Server. Others once up and running
> have been successfull with Oracle. With RS 2005 (released in November) my
> expectation is Oracle will be easier to go against. It also has a good
> many improvements (my two favorites are dynamic sorting and multi-select
> parameters). I would suggest getting the 90 day trial and give it a try.
Thanks for the response Bruce.
Actually, i'm not too worried about using it with Oracle. I'm trying to
convince my boss to discontinue development and support for it.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Tedd Simms" <tedd.simms.SPAMTRAP@.cognostech.com> wrote in message
> news:yf-dnbYtb-kzmF7fRVn-gQ@.novus-tele.net...
>> Hi All,
>> My company has a legacy web application (VBScript/ASP) that includes a
>> series of forms used to create various reports on SQL Server (or Oracle)
>> data. Creation of these reports is extremely tedious due to fairly
>> complicated calculations etc. My question for the group is: Is MS
>> Reporting Services a valid alternative to the way i'm doing things now?
>> I need to be able to create new interactive custom reports fairly easily
>> and link to them via the old web application.
>> Thanks In Advance,
>> Tedd
>
My company has a legacy web application (VBScript/ASP) that includes a
series of forms used to create various reports on SQL Server (or Oracle)
data. Creation of these reports is extremely tedious due to fairly
complicated calculations etc. My question for the group is: Is MS
Reporting Services a valid alternative to the way i'm doing things now? I
need to be able to create new interactive custom reports fairly easily and
link to them via the old web application.
Thanks In Advance,
TeddRS integrates pretty easily with custom web apps particularly for intranet
apps. You can use either URL integration or web services integration. URL
integration is the easiest and fullest featured (you have roll you own a lot
more when using web services). SQL Server reporting is very easy. The main
thing with Oracle is getting all the client apps installed and properly
configured (but that is not too untypical of anything concerning Oracle). I
go against Sybase and SQL Server. Others once up and running have been
successfull with Oracle. With RS 2005 (released in November) my expectation
is Oracle will be easier to go against. It also has a good many improvements
(my two favorites are dynamic sorting and multi-select parameters). I would
suggest getting the 90 day trial and give it a try.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Tedd Simms" <tedd.simms.SPAMTRAP@.cognostech.com> wrote in message
news:yf-dnbYtb-kzmF7fRVn-gQ@.novus-tele.net...
> Hi All,
> My company has a legacy web application (VBScript/ASP) that includes a
> series of forms used to create various reports on SQL Server (or Oracle)
> data. Creation of these reports is extremely tedious due to fairly
> complicated calculations etc. My question for the group is: Is MS
> Reporting Services a valid alternative to the way i'm doing things now? I
> need to be able to create new interactive custom reports fairly easily and
> link to them via the old web application.
> Thanks In Advance,
> Tedd
>|||"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:etoRWSPfFHA.1948@.TK2MSFTNGP12.phx.gbl...
> RS integrates pretty easily with custom web apps particularly for intranet
> apps. You can use either URL integration or web services integration. URL
> integration is the easiest and fullest featured (you have roll you own a
> lot more when using web services). SQL Server reporting is very easy. The
> main thing with Oracle is getting all the client apps installed and
> properly configured (but that is not too untypical of anything concerning
> Oracle). I go against Sybase and SQL Server. Others once up and running
> have been successfull with Oracle. With RS 2005 (released in November) my
> expectation is Oracle will be easier to go against. It also has a good
> many improvements (my two favorites are dynamic sorting and multi-select
> parameters). I would suggest getting the 90 day trial and give it a try.
Thanks for the response Bruce.
Actually, i'm not too worried about using it with Oracle. I'm trying to
convince my boss to discontinue development and support for it.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Tedd Simms" <tedd.simms.SPAMTRAP@.cognostech.com> wrote in message
> news:yf-dnbYtb-kzmF7fRVn-gQ@.novus-tele.net...
>> Hi All,
>> My company has a legacy web application (VBScript/ASP) that includes a
>> series of forms used to create various reports on SQL Server (or Oracle)
>> data. Creation of these reports is extremely tedious due to fairly
>> complicated calculations etc. My question for the group is: Is MS
>> Reporting Services a valid alternative to the way i'm doing things now?
>> I need to be able to create new interactive custom reports fairly easily
>> and link to them via the old web application.
>> Thanks In Advance,
>> Tedd
>
Monday, March 12, 2012
Newbie Help!
Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.server:372757
I work for a company who have just lost the IT Manager, and we are in the
process of appointing another, I am a amature person (normally in sales,
don't hate me). However, we are using Sharepoint POrtal server with a SQL
2000 server for the databases.
There is the companyC1_SITE database which is now showing as suspect after a
server restart, and I notice the LDF is showing 0kb size.
The msdb.mdf is also showing as suspect.
The error log says that the SITE database was not detached cleanly.
I have a backup from the beginning of October, but nothing after that seems
to be valid. So I now must rely on whether or not it will be possible to
recover the corrupt site MDF?
The MDF's are on a RAID array with 270GB free space so the databases did not
become suspect due to space running out.
Any pointers would be very much appreciated.
P.
Your best bet if you want it fixed ASAP and with the least risk of data loss
is to contact MS PSS so they can work directly with you to see what can be
done. Is your data worth about $225.00? I suspect it is and that will be a
small price to pay to get it fixed properly.
http://support.microsoft.com/default...d=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS
Andrew J. Kelly SQL MVP
"Paul Davies" <bob@.notachance.com> wrote in message
news:_9Kud.6383$Cp4.2422@.fe1.news.blueyonder.co.uk ...
>I work for a company who have just lost the IT Manager, and we are in the
>process of appointing another, I am a amature person (normally in sales,
>don't hate me). However, we are using Sharepoint POrtal server with a SQL
>2000 server for the databases.
> There is the companyC1_SITE database which is now showing as suspect after
> a server restart, and I notice the LDF is showing 0kb size.
> The msdb.mdf is also showing as suspect.
> The error log says that the SITE database was not detached cleanly.
> I have a backup from the beginning of October, but nothing after that
> seems to be valid. So I now must rely on whether or not it will be
> possible to recover the corrupt site MDF?
> The MDF's are on a RAID array with 270GB free space so the databases did
> not become suspect due to space running out.
> Any pointers would be very much appreciated.
> P.
>
|||I agree with Andrew. Call the experts. They can walk you throught the
steps most likely to get your data back. Right after that phone call, find
yourself a temporary IT guy from a reputable consulting company. You will
probably have to pay extra for the emergency coverage, but if your business
depends on your systems, you really don't have a choice.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eTcXXn%233EHA.2592@.TK2MSFTNGP09.phx.gbl...
> Your best bet if you want it fixed ASAP and with the least risk of data
loss
> is to contact MS PSS so they can work directly with you to see what can be
> done. Is your data worth about $225.00? I suspect it is and that will be
a[vbcol=seagreen]
> small price to pay to get it fixed properly.
>
> http://support.microsoft.com/default...d=fh;EN-US;sql SQL Support
> http://www.mssqlserver.com/faq/general-pss.asp MS PSS
> --
> Andrew J. Kelly SQL MVP
>
> "Paul Davies" <bob@.notachance.com> wrote in message
> news:_9Kud.6383$Cp4.2422@.fe1.news.blueyonder.co.uk ...
after
>
I work for a company who have just lost the IT Manager, and we are in the
process of appointing another, I am a amature person (normally in sales,
don't hate me). However, we are using Sharepoint POrtal server with a SQL
2000 server for the databases.
There is the companyC1_SITE database which is now showing as suspect after a
server restart, and I notice the LDF is showing 0kb size.
The msdb.mdf is also showing as suspect.
The error log says that the SITE database was not detached cleanly.
I have a backup from the beginning of October, but nothing after that seems
to be valid. So I now must rely on whether or not it will be possible to
recover the corrupt site MDF?
The MDF's are on a RAID array with 270GB free space so the databases did not
become suspect due to space running out.
Any pointers would be very much appreciated.
P.
Your best bet if you want it fixed ASAP and with the least risk of data loss
is to contact MS PSS so they can work directly with you to see what can be
done. Is your data worth about $225.00? I suspect it is and that will be a
small price to pay to get it fixed properly.
http://support.microsoft.com/default...d=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS
Andrew J. Kelly SQL MVP
"Paul Davies" <bob@.notachance.com> wrote in message
news:_9Kud.6383$Cp4.2422@.fe1.news.blueyonder.co.uk ...
>I work for a company who have just lost the IT Manager, and we are in the
>process of appointing another, I am a amature person (normally in sales,
>don't hate me). However, we are using Sharepoint POrtal server with a SQL
>2000 server for the databases.
> There is the companyC1_SITE database which is now showing as suspect after
> a server restart, and I notice the LDF is showing 0kb size.
> The msdb.mdf is also showing as suspect.
> The error log says that the SITE database was not detached cleanly.
> I have a backup from the beginning of October, but nothing after that
> seems to be valid. So I now must rely on whether or not it will be
> possible to recover the corrupt site MDF?
> The MDF's are on a RAID array with 270GB free space so the databases did
> not become suspect due to space running out.
> Any pointers would be very much appreciated.
> P.
>
|||I agree with Andrew. Call the experts. They can walk you throught the
steps most likely to get your data back. Right after that phone call, find
yourself a temporary IT guy from a reputable consulting company. You will
probably have to pay extra for the emergency coverage, but if your business
depends on your systems, you really don't have a choice.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eTcXXn%233EHA.2592@.TK2MSFTNGP09.phx.gbl...
> Your best bet if you want it fixed ASAP and with the least risk of data
loss
> is to contact MS PSS so they can work directly with you to see what can be
> done. Is your data worth about $225.00? I suspect it is and that will be
a[vbcol=seagreen]
> small price to pay to get it fixed properly.
>
> http://support.microsoft.com/default...d=fh;EN-US;sql SQL Support
> http://www.mssqlserver.com/faq/general-pss.asp MS PSS
> --
> Andrew J. Kelly SQL MVP
>
> "Paul Davies" <bob@.notachance.com> wrote in message
> news:_9Kud.6383$Cp4.2422@.fe1.news.blueyonder.co.uk ...
after
>
Newbie Help!
I work for a company who have just lost the IT Manager, and we are in the
process of appointing another, I am a amature person (normally in sales,
don't hate me). However, we are using Sharepoint POrtal server with a SQL
2000 server for the databases.
There is the companyC1_SITE database which is now showing as suspect after a
server restart, and I notice the LDF is showing 0kb size.
The msdb.mdf is also showing as suspect.
The error log says that the SITE database was not detached cleanly.
I have a backup from the beginning of October, but nothing after that seems
to be valid. So I now must rely on whether or not it will be possible to
recover the corrupt site MDF?
The MDF's are on a RAID array with 270GB free space so the databases did not
become suspect due to space running out.
Any pointers would be very much appreciated.
P.Your best bet if you want it fixed ASAP and with the least risk of data loss
is to contact MS PSS so they can work directly with you to see what can be
done. Is your data worth about $225.00? I suspect it is and that will be a
small price to pay to get it fixed properly.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS
--
Andrew J. Kelly SQL MVP
"Paul Davies" <bob@.notachance.com> wrote in message
news:_9Kud.6383$Cp4.2422@.fe1.news.blueyonder.co.uk...
>I work for a company who have just lost the IT Manager, and we are in the
>process of appointing another, I am a amature person (normally in sales,
>don't hate me). However, we are using Sharepoint POrtal server with a SQL
>2000 server for the databases.
> There is the companyC1_SITE database which is now showing as suspect after
> a server restart, and I notice the LDF is showing 0kb size.
> The msdb.mdf is also showing as suspect.
> The error log says that the SITE database was not detached cleanly.
> I have a backup from the beginning of October, but nothing after that
> seems to be valid. So I now must rely on whether or not it will be
> possible to recover the corrupt site MDF?
> The MDF's are on a RAID array with 270GB free space so the databases did
> not become suspect due to space running out.
> Any pointers would be very much appreciated.
> P.
>|||I agree with Andrew. Call the experts. They can walk you throught the
steps most likely to get your data back. Right after that phone call, find
yourself a temporary IT guy from a reputable consulting company. You will
probably have to pay extra for the emergency coverage, but if your business
depends on your systems, you really don't have a choice.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eTcXXn%233EHA.2592@.TK2MSFTNGP09.phx.gbl...
> Your best bet if you want it fixed ASAP and with the least risk of data
loss
> is to contact MS PSS so they can work directly with you to see what can be
> done. Is your data worth about $225.00? I suspect it is and that will be
a
> small price to pay to get it fixed properly.
>
> http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support
> http://www.mssqlserver.com/faq/general-pss.asp MS PSS
> --
> Andrew J. Kelly SQL MVP
>
> "Paul Davies" <bob@.notachance.com> wrote in message
> news:_9Kud.6383$Cp4.2422@.fe1.news.blueyonder.co.uk...
> >I work for a company who have just lost the IT Manager, and we are in the
> >process of appointing another, I am a amature person (normally in sales,
> >don't hate me). However, we are using Sharepoint POrtal server with a SQL
> >2000 server for the databases.
> >
> > There is the companyC1_SITE database which is now showing as suspect
after
> > a server restart, and I notice the LDF is showing 0kb size.
> >
> > The msdb.mdf is also showing as suspect.
> >
> > The error log says that the SITE database was not detached cleanly.
> >
> > I have a backup from the beginning of October, but nothing after that
> > seems to be valid. So I now must rely on whether or not it will be
> > possible to recover the corrupt site MDF?
> >
> > The MDF's are on a RAID array with 270GB free space so the databases did
> > not become suspect due to space running out.
> >
> > Any pointers would be very much appreciated.
> >
> > P.
> >
>
process of appointing another, I am a amature person (normally in sales,
don't hate me). However, we are using Sharepoint POrtal server with a SQL
2000 server for the databases.
There is the companyC1_SITE database which is now showing as suspect after a
server restart, and I notice the LDF is showing 0kb size.
The msdb.mdf is also showing as suspect.
The error log says that the SITE database was not detached cleanly.
I have a backup from the beginning of October, but nothing after that seems
to be valid. So I now must rely on whether or not it will be possible to
recover the corrupt site MDF?
The MDF's are on a RAID array with 270GB free space so the databases did not
become suspect due to space running out.
Any pointers would be very much appreciated.
P.Your best bet if you want it fixed ASAP and with the least risk of data loss
is to contact MS PSS so they can work directly with you to see what can be
done. Is your data worth about $225.00? I suspect it is and that will be a
small price to pay to get it fixed properly.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS
--
Andrew J. Kelly SQL MVP
"Paul Davies" <bob@.notachance.com> wrote in message
news:_9Kud.6383$Cp4.2422@.fe1.news.blueyonder.co.uk...
>I work for a company who have just lost the IT Manager, and we are in the
>process of appointing another, I am a amature person (normally in sales,
>don't hate me). However, we are using Sharepoint POrtal server with a SQL
>2000 server for the databases.
> There is the companyC1_SITE database which is now showing as suspect after
> a server restart, and I notice the LDF is showing 0kb size.
> The msdb.mdf is also showing as suspect.
> The error log says that the SITE database was not detached cleanly.
> I have a backup from the beginning of October, but nothing after that
> seems to be valid. So I now must rely on whether or not it will be
> possible to recover the corrupt site MDF?
> The MDF's are on a RAID array with 270GB free space so the databases did
> not become suspect due to space running out.
> Any pointers would be very much appreciated.
> P.
>|||I agree with Andrew. Call the experts. They can walk you throught the
steps most likely to get your data back. Right after that phone call, find
yourself a temporary IT guy from a reputable consulting company. You will
probably have to pay extra for the emergency coverage, but if your business
depends on your systems, you really don't have a choice.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eTcXXn%233EHA.2592@.TK2MSFTNGP09.phx.gbl...
> Your best bet if you want it fixed ASAP and with the least risk of data
loss
> is to contact MS PSS so they can work directly with you to see what can be
> done. Is your data worth about $225.00? I suspect it is and that will be
a
> small price to pay to get it fixed properly.
>
> http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support
> http://www.mssqlserver.com/faq/general-pss.asp MS PSS
> --
> Andrew J. Kelly SQL MVP
>
> "Paul Davies" <bob@.notachance.com> wrote in message
> news:_9Kud.6383$Cp4.2422@.fe1.news.blueyonder.co.uk...
> >I work for a company who have just lost the IT Manager, and we are in the
> >process of appointing another, I am a amature person (normally in sales,
> >don't hate me). However, we are using Sharepoint POrtal server with a SQL
> >2000 server for the databases.
> >
> > There is the companyC1_SITE database which is now showing as suspect
after
> > a server restart, and I notice the LDF is showing 0kb size.
> >
> > The msdb.mdf is also showing as suspect.
> >
> > The error log says that the SITE database was not detached cleanly.
> >
> > I have a backup from the beginning of October, but nothing after that
> > seems to be valid. So I now must rely on whether or not it will be
> > possible to recover the corrupt site MDF?
> >
> > The MDF's are on a RAID array with 270GB free space so the databases did
> > not become suspect due to space running out.
> >
> > Any pointers would be very much appreciated.
> >
> > P.
> >
>
Subscribe to:
Posts (Atom)