Our Application dosn't work with Sql Service pack 3

Hi , My name is Tomas
I work for a Software Developing Company ,
Our applications has been written and developed by
Power Builder 5.0 , and they can work with Sql Server 2000
normally , but when I install service pack 3.0 on our sql
server after that our application can't work with sql
server correctly , for example some queries doesn't run
and there is no result for them after installing service
pack 3,,
Please Help MeHi
First thing you need to do is run profiler on the server to see what queries
are being submitted. then pick some of those queries and run them in Query
Analyzer. In that situation, you will be able to tell if your code is
running with errors.
If your application is using more than 1 database at the same time, look at
the "Cross-Database Ownership Chaining" in books online. This was a change
introduced by SP3.
--
--
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.NOSPAMepprecht.net
Specialist SQL Server Solutions and Consulting
"Tomas" <anonymous@.discussions.microsoft.com> wrote in message
news:01a101c3d429$41ba6c70$a001280a@.phx.gbl...
> Hi , My name is Tomas
> I work for a Software Developing Company ,
> Our applications has been written and developed by
> Power Builder 5.0 , and they can work with Sql Server 2000
> normally , but when I install service pack 3.0 on our sql
> server after that our application can't work with sql
> server correctly , for example some queries doesn't run
> and there is no result for them after installing service
> pack 3,,
> Please Help Me
>|||you should really consider upgrading powerbuilder. when did 5.0 come
out, the mid 90's?
Tomas wrote:
> Hi , My name is Tomas
> I work for a Software Developing Company ,
> Our applications has been written and developed by
> Power Builder 5.0 , and they can work with Sql Server 2000
> normally , but when I install service pack 3.0 on our sql
> server after that our application can't work with sql
> server correctly , for example some queries doesn't run
> and there is no result for them after installing service
> pack 3,,
> Please Help Me|||Especially since PB5 is no longer supported much less supported for use with
SQL2000. We're using PB9 and it works great with SQL2K.
Mike Kruchten
"ch" <ch@.dontemailme.com> wrote in message
news:3FFB0C2E.A65CF347@.dontemailme.com...
> you should really consider upgrading powerbuilder. when did 5.0 come
> out, the mid 90's?
>
> Tomas wrote:
> > Hi , My name is Tomas
> > I work for a Software Developing Company ,
> > Our applications has been written and developed by
> > Power Builder 5.0 , and they can work with Sql Server 2000
> > normally , but when I install service pack 3.0 on our sql
> > server after that our application can't work with sql
> > server correctly , for example some queries doesn't run
> > and there is no result for them after installing service
> > pack 3,,
> > Please Help Me
>

Other applications using MSDE

What other applications outside Microsoft products, use MSDE?
Hi,
You're asking a question here that isn't possible to answer. There are a
huge number of software vendors that now use the MSDE as one of their forms
of deployment. A large percentage of SQL Server based applications could be
deployed against the MSDE at the lower end of the market. It's a similar
question to asking "What other applications outside Microsoft products, use
SQL Server?".
Sorry there isn't a simple answer.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Moj_Sharp Labs" <anonymous@.discussions.microsoft.com> wrote in message
news:D1298C09-2F40-4CBA-86F7-96BA7DC09CC5@.microsoft.com...
> What other applications outside Microsoft products, use MSDE?
|||sourcegear's version control system, vault, integrates with msde for
smaller based development shops which do not want to purchase a full sql
server license.
http://www.sourcegear.com/vault/
jeff clausius
sourcegear
"=?Utf-8?B?TW9qX1NoYXJwIExhYnM=?=" <anonymous@.discussions.microsoft.com>
wrote in news:D1298C09-2F40-4CBA-86F7-96BA7DC09CC5@.microsoft.com:

> What other applications outside Microsoft products, use MSDE?

OT: Help with a database/application

Hello all,
I am looking for more ideas on bullet proof style Data Bases and or
applications for my site. I possibly could do some barter trading with some
advertizing.
I need to following for the application and it should be ablet o cross
reference with other applications too.
User Name
Auto generated PW- then can be changed later if wnated to be
What is being posted
Where the sale is-URL or active link
What the price is
Who posted it
When it is posted
The data base should contain this info
Name, address, age, gender, email, and user name..
If you could email it would be great. I did have a guy helping me, but he
got too busy with his work and I am very niave in this area. Any help would
be greatly appreciated..Hi
Have a look at the data models on:
http://www.databaseanswers.org/data_models/index.htm
Regards
Mike
"CPS" wrote:
> Hello all,
> I am looking for more ideas on bullet proof style Data Bases and or
> applications for my site. I possibly could do some barter trading with some
> advertizing.
> I need to following for the application and it should be ablet o cross
> reference with other applications too.
> User Name
> Auto generated PW- then can be changed later if wnated to be
> What is being posted
> Where the sale is-URL or active link
> What the price is
> Who posted it
> When it is posted
>
> The data base should contain this info
> Name, address, age, gender, email, and user name..
> If you could email it would be great. I did have a guy helping me, but he
> got too busy with his work and I am very niave in this area. Any help would
> be greatly appreciated..
>
>

OSQL Performance Problem

System info:
Win 2003 Server, SQL Server 2000, test server - no outside access from other users (no other applications running)

Table info:
DocId(int), a(nvarchar(10)), b(nvarchar(20)), c(nvarchar(10)), d(nvarchar(20)), e(nvarchar(10))
DocId has a number, all other columns are null. No index

I am using a stored procedure that updates the values based on the DocId. I have an program that creates a sql script file that should be executed. Approx. 440000 lines.

Example:
Using TableName
Go
SET NOCOUNT ON
GO
exec sp_SPNAME @.docId=1, @.a = 'blah', @.b = 'blah', @.c = 'blah', @.d = 'blah', @.e = 'blah'
GO
exec sp_SPNAME @.docId=2, @.a = 'blah', @.b = 'blah', @.c = 'blah', @.d = 'blah', @.e = 'blah'
GO
repeats 440K.

Question: When I execute this script per osql.exe, the update takes more the 24 hours... Any suggestions?

Thanks in advance.System info:
Win 2003 Server, SQL Server 2000, test server - no outside access from other users (no other applications running)

Table info:
DocId(int), a(nvarchar(10)), b(nvarchar(20)), c(nvarchar(10)), d(nvarchar(20)), e(nvarchar(10))
DocId has a number, all other columns are null. No index

INDEX !!!

Put a clustered index on DocID.

CREATE CLUSTERED INDEX IXc_TableName_DocID ON TableName (DocID)
GO

Regards,

hmscott|||another route is to bulkcopy/insert all the new data into a table then do a single update against the base table. Index on docid would be desired when you start dml.|||Hi hmscott,

thanks for the reply and the sql. I added the index and, while it is much faster, it still takes more than 8 hours. Maybe this is normal for executing 440,000 statements?

Thanks,
Lens|||Hi oj,

thanks to you as well for the reply. I will change my program to make a csv file and see if a bulk update increases the speed.

Thanks,
Lens|||Hi,

just a quick status update. I changed my program to create a csv-file. Approx. 440,000 lines imported into temp table; less than 2 minutes. Update into final table, less than two minutes...zoinks.

Thanks again.