Bugs & Issues

Is there a web page where I can monitor the new/old bugs
and issues related to SQL Server & Analysis Services, SP's
e.t.c ?
Thanks.
You can see a list of hotfixes and the bugs that they fix at
http://www.aspfaq.com/2160 (anything past 8.00.760 is most likely a bug fix
that deals with at least one symptom).
As for a general list of all bugs, no, Microsoft does not publish this
information.
http://www.aspfaq.com/
(Reverse address to reply.)
"Nick" <anonymous@.discussions.microsoft.com> wrote in message
news:b78c01c48938$7353c460$a501280a@.phx.gbl...
> Is there a web page where I can monitor the new/old bugs
> and issues related to SQL Server & Analysis Services, SP's
> e.t.c ?
> Thanks.
|||Thanks............

>--Original Message--
>You can see a list of hotfixes and the bugs that they fix
at
>http://www.aspfaq.com/2160 (anything past 8.00.760 is
most likely a bug fix
>that deals with at least one symptom).
>As for a general list of all bugs, no, Microsoft does not
publish this
>information.
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"Nick" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:b78c01c48938$7353c460$a501280a@.phx.gbl...
SP's
>
>.
>
sql

Bugs & Issues

Is there a web page where I can monitor the new/old bugs
and issues related to SQL Server & Analysis Services, SP's
e.t.c '
Thanks.You can see a list of hotfixes and the bugs that they fix at
http://www.aspfaq.com/2160 (anything past 8.00.760 is most likely a bug fix
that deals with at least one symptom).
As for a general list of all bugs, no, Microsoft does not publish this
information.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Nick" <anonymous@.discussions.microsoft.com> wrote in message
news:b78c01c48938$7353c460$a501280a@.phx.gbl...
> Is there a web page where I can monitor the new/old bugs
> and issues related to SQL Server & Analysis Services, SP's
> e.t.c '
> Thanks.|||Thanks............
>--Original Message--
>You can see a list of hotfixes and the bugs that they fix
at
>http://www.aspfaq.com/2160 (anything past 8.00.760 is
most likely a bug fix
>that deals with at least one symptom).
>As for a general list of all bugs, no, Microsoft does not
publish this
>information.
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"Nick" <anonymous@.discussions.microsoft.com> wrote in
message
>news:b78c01c48938$7353c460$a501280a@.phx.gbl...
>> Is there a web page where I can monitor the new/old bugs
>> and issues related to SQL Server & Analysis Services,
SP's
>> e.t.c '
>> Thanks.
>
>.
>

Bugs & Issues

Is there a web page where I can monitor the new/old bugs
and issues related to SQL Server & Analysis Services, SP's
e.t.c '
Thanks.You can see a list of hotfixes and the bugs that they fix at
http://www.aspfaq.com/2160 (anything past 8.00.760 is most likely a bug fix
that deals with at least one symptom).
As for a general list of all bugs, no, Microsoft does not publish this
information.
http://www.aspfaq.com/
(Reverse address to reply.)
"Nick" <anonymous@.discussions.microsoft.com> wrote in message
news:b78c01c48938$7353c460$a501280a@.phx.gbl...
> Is there a web page where I can monitor the new/old bugs
> and issues related to SQL Server & Analysis Services, SP's
> e.t.c '
> Thanks.|||Thanks............

>--Original Message--
>You can see a list of hotfixes and the bugs that they fix
at
>http://www.aspfaq.com/2160 (anything past 8.00.760 is
most likely a bug fix
>that deals with at least one symptom).
>As for a general list of all bugs, no, Microsoft does not
publish this
>information.
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"Nick" <anonymous@.discussions.microsoft.com> wrote in
message
>news:b78c01c48938$7353c460$a501280a@.phx.gbl...
SP's[vbcol=seagreen]
>
>.
>

Browser as Front-End

Hi!

I'm trying to build an app. for my parents' office. They have a small
office (5 PCs), and they currently work with a very old program that's
based on DOS. The program doesn't work well under XP, so they still use
Win 98. They had their network upgraded about a year ago. They had
Microsoft SBS 2000 installed, it includes SQL Server. I've written a
few DB's in Access before, and now I'm just learning how to use SQL.
Before I start work on their app., I have a question:

I know it's possible to create an interface that can be put on their
network and accessed via a browser. How is this done exactly?

It would be very beneficial for me, because it would mean that the new
app. would be platform independent, so that they can upgrade to XP
easily. It would also save us the cost of licensing front-end software
(e.g. Access) for each machine.

Any comments would be appreciated.

Noam Nelke, Israel.When you meant place the SQL Server on a network, you meant placing it
on a central server?

If that is the case, you can have one dedicated server for the SQL
Server and an application server where you can develop your web
application to create an Interface for this DB.
How to create the Interface?
- You can have a Web Server installed on the application server (IIS or
java based web servers) and then write your web code in any of the tons
of languages.

Hope that helps.|||Noam Nelke (NoamNelke@.gmail.com) writes:
> I'm trying to build an app. for my parents' office. They have a small
> office (5 PCs), and they currently work with a very old program that's
> based on DOS. The program doesn't work well under XP, so they still use
> Win 98. They had their network upgraded about a year ago. They had
> Microsoft SBS 2000 installed, it includes SQL Server. I've written a
> few DB's in Access before, and now I'm just learning how to use SQL.
> Before I start work on their app., I have a question:
> I know it's possible to create an interface that can be put on their
> network and accessed via a browser. How is this done exactly?

That's a question that does not have much to do with SQL Server. Most
people seem to use ASP or ASP .Net. There is also Cold Fusion out there,
and probably a few more possibilities.

> It would be very beneficial for me, because it would mean that the new
> app. would be platform independent, so that they can upgrade to XP
> easily. It would also save us the cost of licensing front-end software
> (e.g. Access) for each machine.

On the other hand, browser-based interfaces are often painful to use.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Bringing text into a database

I have a report that is generated out of another system, that is 180
characters wide. It resembles the layout of an old COBOL type of report.
What I need to do to is to bring it into a database. I've set the field
to be 180 characters (have tried char, varchar, nvarchar, text) but when
I go to import the data, I notice that it gets truncated around position
150 or so, no matter what data type I choose.
What I want to do is to bring this report in, as a single field, and be
able to move it out as a single line.
What's the limit on varchar, char, text and so on? Why is the wizard
truncating the firstline around position 150?
Thanks,
BCThe limit is 8000. Perhaps the wizard is the issue. Can you create the DTS
package manually? It may be that the input row contains a character that's
supposed to be used as a delimiter.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Blasting Cap" <goober@.christian.net> wrote in message
news:%237EjS3KPGHA.2668@.tk2msftngp13.phx.gbl...
I have a report that is generated out of another system, that is 180
characters wide. It resembles the layout of an old COBOL type of report.
What I need to do to is to bring it into a database. I've set the field
to be 180 characters (have tried char, varchar, nvarchar, text) but when
I go to import the data, I notice that it gets truncated around position
150 or so, no matter what data type I choose.
What I want to do is to bring this report in, as a single field, and be
able to move it out as a single line.
What's the limit on varchar, char, text and so on? Why is the wizard
truncating the firstline around position 150?
Thanks,
BC|||Tom Moreau wrote:
> The limit is 8000. Perhaps the wizard is the issue. Can you create the D
TS
> package manually? It may be that the input row contains a character that'
s
> supposed to be used as a delimiter.
>
The wizard in DTS is the same wizard. Best I can figure is that a CRLF
is at the end of each line, and it varies as to what position it's in.
It appears that the first line of the report dictates where the "hard"
column end appears thoughout the rest of the report.
BC|||CRLF is the standard row terminator. You may need a hex editor to track
down exactly where it is.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Blasting Cap" <goober@.christian.net> wrote in message
news:%23RijHHLPGHA.1760@.TK2MSFTNGP10.phx.gbl...
Tom Moreau wrote:
> The limit is 8000. Perhaps the wizard is the issue. Can you create the
> DTS
> package manually? It may be that the input row contains a character
> that's
> supposed to be used as a delimiter.
>
The wizard in DTS is the same wizard. Best I can figure is that a CRLF
is at the end of each line, and it varies as to what position it's in.
It appears that the first line of the report dictates where the "hard"
column end appears thoughout the rest of the report.
BC

BPA Install Problem

I'm installing the latest version of BPA and seem to have run into an issue.
I've uninstalled the app and deleted the old BPA database, and while
reinstalling, I'm seeing an error message come up. "One or more rules could
not be installed. There is an error in XML document (55, 15). Invalid SQL
Server edition."
I'm running everything locally, and running SQL 2k, SP3 on WinXP SP1
Where can I start to look to debug this problem?
Steve
Please uninstall and reinstall, but before reinstalling make sure that the
destination folder is empty. At the very least you should make sure that
bpadmin.exe.config file doesn not exist, and that no files or folders are
left under repository folder.
Let me know if that doesn't work.
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Steve Carroll" <steve_carroll72@.h_o_t_m_a_i_l.com> wrote in message
news:uELb%23aYTEHA.2908@.TK2MSFTNGP10.phx.gbl...
> I'm installing the latest version of BPA and seem to have run into an
issue.
> I've uninstalled the app and deleted the old BPA database, and while
> reinstalling, I'm seeing an error message come up. "One or more rules
could
> not be installed. There is an error in XML document (55, 15). Invalid
SQL
> Server edition."
> I'm running everything locally, and running SQL 2k, SP3 on WinXP SP1
> Where can I start to look to debug this problem?
>
|||Well,
Its apparent that I'm a database guy and not an application guy!
That worked like a charm. Thanks!
BTW... great app!
-Steve
"Christian Kleinerman [MS]" <ckleiner@.online.microsoft.com> wrote in message
news:e870CqYTEHA.2324@.TK2MSFTNGP10.phx.gbl...
> Steve
> Please uninstall and reinstall, but before reinstalling make sure that the
> destination folder is empty. At the very least you should make sure that
> bpadmin.exe.config file doesn not exist, and that no files or folders are
> left under repository folder.
> Let me know if that doesn't work.
> - Christian
> --
> ___________________________
> Christian Kleinerman
> Program Manager, SQL Engine
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Steve Carroll" <steve_carroll72@.h_o_t_m_a_i_l.com> wrote in message
> news:uELb%23aYTEHA.2908@.TK2MSFTNGP10.phx.gbl...
> issue.
> could
> SQL
>