Newbie question : sample of XML Application ?

Hi All,
I am new to XML.
Could anybody please tell me sample of aplication / cases study where we
can make use of XML
(in general or especially in SQL Server 2000)
Thank you for your help,
Krist
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!I am not quite sure what you are looking for? Do you need a motivation to
use XML in the database? If you need that, you probably are fine with using
the relational feature and don't need to use XML. Otherwise,
http://msdn.microsoft.com/xml has whitepapers and other information...
Best regards
Michael
"Krist" <Kristanto@.me.com> wrote in message
news:uy4M%23m5KFHA.2648@.TK2MSFTNGP14.phx.gbl...
> Hi All,
> I am new to XML.
> Could anybody please tell me sample of aplication / cases study where we
> can make use of XML
> (in general or especially in SQL Server 2000)
> Thank you for your help,
> Krist
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!

Newbie question : sample of XML Application ?

Hi All,
I am new to XML.
Could anybody please tell me sample of aplication / cases study where we
can make use of XML
(in general or especially in SQL Server 2000)
Thank you for your help,
Krist
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
I am not quite sure what you are looking for? Do you need a motivation to
use XML in the database? If you need that, you probably are fine with using
the relational feature and don't need to use XML. Otherwise,
http://msdn.microsoft.com/xml has whitepapers and other information...
Best regards
Michael
"Krist" <Kristanto@.me.com> wrote in message
news:uy4M%23m5KFHA.2648@.TK2MSFTNGP14.phx.gbl...
> Hi All,
> I am new to XML.
> Could anybody please tell me sample of aplication / cases study where we
> can make use of XML
> (in general or especially in SQL Server 2000)
> Thank you for your help,
> Krist
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!

Newbie Needs Help ;)

Thanks everyone (especially Hilary) for your help.
Apologies for not saying earlier but I left for home for
the weekend (I'm in the UK).
The Replication I set up was from the Microsoft Web page,
can anyone tell me of a guide on 'What to do when things
go wrong ?'
Peter

>--Original Message--
>Hello,
>I'm new to replication. I have got a subscriber,
publisher
>ans distributer working ok, so now does the snapshot
>replication, then the transactional ones.
>It was working fine for 5 minutes then I had the
following
>error
>Cannot update identity column 'ID'.
>{CALL sp_MSupd_tblPerson
>
(NULL,0,NULL,NULL,NULL,NULL,NULL,' ',1,0,7146,0x82
>03)}
>ID is a primary key with an Identity setting get to 'Yes
>but not for replication'.
>Any pointers please
>Peter
>.
>
Peter,
I think the best thing to do is to search this newsgroup. I maintain a short
list of things I have found useful at www.replicationanswers.com which is
not meant to be exhaustive.
There are one or two other articles around that may help:
http://www.microsoft.com/technet/pro.../mergproc.mspx
http://www.databasejournal.com/featu...le.php/1468971
HTH,
Paul Ibison
|||Thanks Paul

>--Original Message--
>Peter,
>I think the best thing to do is to search this newsgroup.
I maintain a short
>list of things I have found useful at
www.replicationanswers.com which is
>not meant to be exhaustive.
>There are one or two other articles around that may help:
>http://www.microsoft.com/technet/pro.../sql/2000/main
tain/mergproc.mspx
>http://www.databasejournal.com/featu...l/article.php/
1468971
>HTH,
>Paul Ibison
>
>.
>

Newbie - sa password error after ACT! install - Need pro's help!!!

Hello,
I am admittedly new to this, especially sql server and am in need of a pro's assistance.. I installed Microsoft Small Business accounting, which in turn installed and configured a sql server. When I installed ACT! 2005 (v7.0) and tried to create a database, it states that it cannot find the master file.... so I tried to install sql server from Microsofts site - downloaded all the packages, unzipped them and ran them... the error I get is that the sql server needs to have an sa password and to use some switch to change it... for the life of me I am lost here. I can't use ACT! at this point and I have not ideas of how to remove, reinstall or repair the sql server.... Any help you can provide would be greatly appreicated!

The default sa password is blank. Is it complaining that this is not acceptable and you need to change it ?

What version of SQL Server do you have ? It sounds like SQL Server Express 2005 ? You may well have two instances installed now, one that came with ACT, and one that you've installed.

Overall, I'd say ACT are the people to talk to, you're using SQL Server with ACT, right ?

|||Yes, it is saying that the sa password is empty...specifically: "A strong sa password is required for security purposes. Please us SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit." That is what is says when I attempt to run ANY installation version of SQL ... attempting to correct the sql error that I get when I run ACT!. Is there a way to repair or rebuild the sql server? I have only one instance, from the ACT! install... Thanks for the reply.. !!|||By the way.. that was the install error for SQL Server 2000 version A specifically... I installed SQL Server 2005 Express... or tried to... it would run either..|||

ACT will support either one ? I'm not sure that you don't have two instances running now ( SQL Server can have more than one version, or multiple instances of the same version, running on a machine ). If I were you, I'd uninstall the lot, including SQL Server, and reinstall ACT. To set the password, you run the installer for SQL Server from the command line and specify SAPWD="whatever", which will set the SA password. If the version of SQL Server you have installed has a management console, or whatever it was called in SS2000, you can go into it, find the Users section, and change the password there.

However, I would be more inclined to do a reinstall from scratch and then try the ACT site:

http://www.act.com/support/technicalsupport/index.cfm

I've looked and I can't see anything specific there, but the problem obviously relates to ACT, and if you've paid for it, they would be the ones who know what's going on, and should be supporting you to get their program working.

|||Sounds great... as for ACT! I called them already.. since I bought this version a while ago,. they stopped supporting it a couple months ago! Nice huh?! As for uninstalling them, I'm all for it.. how do I uninstall SS2000 and all the other instances of SQL Server? It's not in my remove programs dialog....... Thanks again for the help... look for to hearing back from you|||

If SS2000 is not in your list, perhaps MSDE is ( that's the free version ). Otherwise, maybe it uninstalls with ACT. If you go to Control Panel/Administrative Tools/Services, the list is alphabetical, if there are any listings that start with SQL Server, you still have SQL Server installed :-)

Your question is right on the edge of what is on topic here, and that means you're unlikely to find people with direct, first hand experience of the problem. If an uninstall/reinstall doesn't solve it, then I'd suggest looking for a forum populated with people who use ACT. I'm happy to try and help, but I'm pretty much in the dark, all I can do is comment based on what I know of SQL Server.