Do I stand a chance of being sucessful?

I'm basically a newbie; I understand the concepts of basic computer
management, databases, networks, and programming. But, I'm not experienced
in Sequel or MSDE.
I'm helping a friend who recently purchased a small service business (a
sports gym) that manages all the membership details using software that uses
MSDE. The current club management software is about 4 years old, it's
limping along without too many problems. The company that wrote the
software didn't survive the .com implosion, so I have very little
information on the product nor anyone to ask.
If his server was to die, he'd be SOL. I want to start 'backing up' the
data in a format I can use to import into potential replacement software (I
have no way to recreate the existing environment).
Is this possible? Without any information on the database (names,
passwords, field, layout, etc), is it possible to create a flat file that
contains the basic membership data (names, address, status, membership type,
etc). (the existing software does not have this capability) I'm assuming
that the future software will allow me to import such a file. I this too
big of a task for a newbie?
Thanks for your time in advance...
It is definitely doable. You need some very basic knowledge on SQL
Server/MSDE. MSDE is a free version of SQL Server, so your problem is MSDE
does not come with a GUI tool. However, armed with basic SQL Server/MSDE
knowledge, you can use Access to connect to MSDE (either *.mdb or *.adp
file), and to view/modify/export data in the said MSDE database.
"The Dodger" <someone@.somewhere.com> wrote in message
news:%23EVc37K4FHA.2352@.TK2MSFTNGP12.phx.gbl...
> I'm basically a newbie; I understand the concepts of basic computer
> management, databases, networks, and programming. But, I'm not
> experienced in Sequel or MSDE.
> I'm helping a friend who recently purchased a small service business (a
> sports gym) that manages all the membership details using software that
> uses MSDE. The current club management software is about 4 years old,
> it's limping along without too many problems. The company that wrote the
> software didn't survive the .com implosion, so I have very little
> information on the product nor anyone to ask.
> If his server was to die, he'd be SOL. I want to start 'backing up' the
> data in a format I can use to import into potential replacement software
> (I have no way to recreate the existing environment).
> Is this possible? Without any information on the database (names,
> passwords, field, layout, etc), is it possible to create a flat file that
> contains the basic membership data (names, address, status, membership
> type, etc). (the existing software does not have this capability) I'm
> assuming that the future software will allow me to import such a file. I
> this too big of a task for a newbie?
> Thanks for your time in advance...
>
>
sql

Do I HAVE to have IIS installed to use SQL Server Express 2005? and do I have to install SQLE2K5

Hi,

I'm an absolute beginner trying to learn SQL and Visual Basic/Visual Web developer.

I've downloaded SQL Express 2005 and want to install it on my laptop (Dell XPS, 2gb Ram) so that I can start doing the tutorials (for SQL and VB/VWS). I dont want any connection to the internet - i only want to have it on my local pc.

I'm confused as I 'm sure I read that I dont need to have the IIS service running, and that it wont require a server...however, I keep reading that IIS, and a server is a MUST, and for installing SQLE2005.

I'm so confused, and frustrated that I dare'nt install SQLE2005...

...Can anyone put me out of my misery?

All advice greatly appreciated.

SQLEB

Hi,

If you have downloaded SQL Express edition with Advance Services then only you require to have IIS installed on your system Refer http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/RequirementsSQLEXP2005Advanced.htm

and if you have installed SQL Express w/o Advance Services you don't require to have IIS Refer http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/RequirementsSQLEXP2005.htm

HTH

Hemantgiri S. Goswami

|||No, IIS is NOT required for the use and operation of SQL Server.sql

Distributed Transactions ?

Hi There

I realize this is probably a basic question or at least i hope so but i cannot get distributed transactions working.

BOL is just driving me in circles.
I am running SS2000, MSDTC is up and running on the server.

I have added a trigger to a table where on insert or update the triggers fires and inserts a row to a remote server.

When i execute the update or insert i get the error:
Cannot start a distributed transaction.

I have tried stating BEGIN DISTRIBUTED TRANSACTION before the update but i get the same error, i have also read up on SET REMOTE_PROC_TRANSACTIONS, but this is not a remote sp.

Can anyone please reccomend a good link as to how to get distributed transactions to work.

Thanx
P.S I have already checked this link http://support.microsoft.com/?kbid=816701.

Also i have found references to checking avrious services are running etc, seems there is alot to setup to get MSDTC to work but i cannot find the setup in BOL, not sure everything i have to do to egt MSDTC to work ?

Please help Thanx
|||

Have you tried setting XACT_ABORT ton ON?

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||Hi

Tried this

SET XACT_ABORT ON
BEGIN DISTRIBUTED TRANSACTION
UPDATE PSAPMSGSUBCON SET STATUSSTRING = 'ERROR'

Got this error:

[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].
Msg 7391, Level 16, State 1, Procedure PSAPMSGSUBCON_MESSAGE_ERROR_TRIGGER, Line 11
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.

ALso found this in BOL:

It is required that XACT_ABORT be set ON for data modification statements in an implicit or explicit transaction against most OLE DB providers, including SQL Server. The only case where this option is not required is if the provider supports nested transactions. For more information, see Distributed Queries and Distributed Transactions.

I think i am simply missing something to ensure MSDTC is setup and running correctly.
Is the only thing require for MSDTC to work , that it be running, servers have the network DTC enabled and you stipulate

BEGIN DISTRIBUTED TRANSACTION

?