Do I have to install SQL server 2000

I have made a small database with SQL server 2000, and i have made
interface using C#.NET
and ADO.net ( this interface manage all queries -SELECT UPDATE INSERT
DELETE-), now i want to give this application ( database and interface
) to my friends,
so do they have to install SQL server 2000 ( 1 GB or more ) to use this
small database ( 1 MB )
or there is another solution which cost less space which i ask for
thanks for helpI'd test the app for SQL Server 2005 and have the friends use SQL Server express.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<yosif4444@.gmail.com> wrote in message news:1136199441.120847.28540@.g14g2000cwa.googlegroups.com...
>I have made a small database with SQL server 2000, and i have made
> interface using C#.NET
> and ADO.net ( this interface manage all queries -SELECT UPDATE INSERT
> DELETE-), now i want to give this application ( database and interface
> ) to my friends,
> so do they have to install SQL server 2000 ( 1 GB or more ) to use this
> small database ( 1 MB )
> or there is another solution which cost less space which i ask for
> thanks for help
>|||On 2 Jan 2006 02:57:21 -0800, yosif4444@.gmail.com wrote:
> I have made a small database with SQL server 2000, and i have made
> interface using C#.NET
> and ADO.net ( this interface manage all queries -SELECT UPDATE INSERT
> DELETE-), now i want to give this application ( database and interface
> ) to my friends,
> so do they have to install SQL server 2000 ( 1 GB or more ) to use this
> small database ( 1 MB )
> or there is another solution which cost less space which i ask for
> thanks for help
You could use MSDE 2000
http://www.microsoft.com/downloads/details.aspx?familyid=413744d1-a0bc-479f-bafa-e4b278eb9147&displaylang=en
or you could use its replacement SQL Express|||Your freinds has to install MSDE 2000 (Microsoft Desktop Engine 2000) which
is a free version. They can download the same from the link
http://www.microsoft.com/downloads/details.aspx?FamilyID=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en
regs
--
T.E.Nagaraj
Project Manager
Induscorp India Pvt Ltd
Blore
"Paul" wrote:
> On 2 Jan 2006 02:57:21 -0800, yosif4444@.gmail.com wrote:
> > I have made a small database with SQL server 2000, and i have made
> > interface using C#.NET
> > and ADO.net ( this interface manage all queries -SELECT UPDATE INSERT
> > DELETE-), now i want to give this application ( database and interface
> > ) to my friends,
> > so do they have to install SQL server 2000 ( 1 GB or more ) to use this
> > small database ( 1 MB )
> > or there is another solution which cost less space which i ask for
> > thanks for help
> You could use MSDE 2000
> http://www.microsoft.com/downloads/details.aspx?familyid=413744d1-a0bc-479f-bafa-e4b278eb9147&displaylang=en
> or you could use its replacement SQL Express
>sql

Do I have to install SQL server 2000

I have made a small database with SQL server 2000, and i have made
interface using C#.NET
and ADO.net ( this interface manage all queries -SELECT UPDATE INSERT
DELETE-), now i want to give this application ( database and interface
) to my friends,
so do they have to install SQL server 2000 ( 1 GB or more ) to use this
small database ( 1 MB )
or there is another solution which cost less space which i ask for
thanks for helpI'd test the app for SQL Server 2005 and have the friends use SQL Server exp
ress.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<yosif4444@.gmail.com> wrote in message news:1136199441.120847.28540@.g14g2000cwa.googlegroups
.com...
>I have made a small database with SQL server 2000, and i have made
> interface using C#.NET
> and ADO.net ( this interface manage all queries -SELECT UPDATE INSERT
> DELETE-), now i want to give this application ( database and interface
> ) to my friends,
> so do they have to install SQL server 2000 ( 1 GB or more ) to use this
> small database ( 1 MB )
> or there is another solution which cost less space which i ask for
> thanks for help
>|||On 2 Jan 2006 02:57:21 -0800, yosif4444@.gmail.com wrote:

> I have made a small database with SQL server 2000, and i have made
> interface using C#.NET
> and ADO.net ( this interface manage all queries -SELECT UPDATE INSERT
> DELETE-), now i want to give this application ( database and interface
> ) to my friends,
> so do they have to install SQL server 2000 ( 1 GB or more ) to use this
> small database ( 1 MB )
> or there is another solution which cost less space which i ask for
> thanks for help
You could use MSDE 2000
http://www.microsoft.com/downloads/...&displaylang=en
or you could use its replacement SQL Express|||Your freinds has to install MSDE 2000 (Microsoft Desktop Engine 2000) which
is a free version. They can download the same from the link
http://www.microsoft.com/downloads/...&displaylang=en
regs
--
T.E.Nagaraj
Project Manager
Induscorp India Pvt Ltd
Blore
"Paul" wrote:

> On 2 Jan 2006 02:57:21 -0800, yosif4444@.gmail.com wrote:
>
> You could use MSDE 2000
> http://www.microsoft.com/downloads/...&displaylang=en
> or you could use its replacement SQL Express
>

Do I have to install SQL server 2000

I have made a small database with SQL server 2000, and i have made
interface using C#.NET
and ADO.net ( this interface manage all queries -SELECT UPDATE INSERT
DELETE-), now i want to give this application ( database and interface
) to my friends,
so do they have to install SQL server 2000 ( 1 GB or more ) to use this
small database ( 1 MB )
or there is another solution which cost less space which i ask for
thanks for help
I'd test the app for SQL Server 2005 and have the friends use SQL Server express.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<yosif4444@.gmail.com> wrote in message news:1136199441.120847.28540@.g14g2000cwa.googlegro ups.com...
>I have made a small database with SQL server 2000, and i have made
> interface using C#.NET
> and ADO.net ( this interface manage all queries -SELECT UPDATE INSERT
> DELETE-), now i want to give this application ( database and interface
> ) to my friends,
> so do they have to install SQL server 2000 ( 1 GB or more ) to use this
> small database ( 1 MB )
> or there is another solution which cost less space which i ask for
> thanks for help
>
|||On 2 Jan 2006 02:57:21 -0800, yosif4444@.gmail.com wrote:

> I have made a small database with SQL server 2000, and i have made
> interface using C#.NET
> and ADO.net ( this interface manage all queries -SELECT UPDATE INSERT
> DELETE-), now i want to give this application ( database and interface
> ) to my friends,
> so do they have to install SQL server 2000 ( 1 GB or more ) to use this
> small database ( 1 MB )
> or there is another solution which cost less space which i ask for
> thanks for help
You could use MSDE 2000
http://www.microsoft.com/downloads/d...displaylang=en
or you could use its replacement SQL Express
|||Your freinds has to install MSDE 2000 (Microsoft Desktop Engine 2000) which
is a free version. They can download the same from the link
http://www.microsoft.com/downloads/d...displaylang=en
regs
T.E.Nagaraj
Project Manager
Induscorp India Pvt Ltd
Blore
"Paul" wrote:

> On 2 Jan 2006 02:57:21 -0800, yosif4444@.gmail.com wrote:
>
> You could use MSDE 2000
> http://www.microsoft.com/downloads/d...displaylang=en
> or you could use its replacement SQL Express
>

DMO, VFP and SQL 2005

I have an application writing in VFP that is used to manage some database
processes, some of these processes are currently writing in DMO. We are in
the process of upgrading to sql 2005 and I’m running into some trouble. I
m
currently changing some of the process to t-sql statements but I have an
issue where I think I need to use DMO. I’ve installed the backwards
compatible objects but I can not seem to connect via DMO. I have a default
instance of sql 2000, a named instance 2000 and a named instance of 2005
running on laptop running XP Tablet edition.
Code
ox= CREATEOBJECT("SQLDMO.sqlServer")
?ox.Connect("MA-ENG-PCANINO2\sql2005","sa", "SASA")
Executing that returns this error.
OLE IDispatch exception code 55555 from Microsoft SQL-DMO (ODBC SQLState:
42000): [Microsoft][ODBC SQL Server Driver][SQL Server]To connect to this
server you must use SQL Server Management Studio or SQL Server Management
Objects (SMO)...
Thank you in advance.
Pauly CIt’s working now, I read in another post to unregistered and reregister th
e
SQLDMO.dll - \\Program Files\Microsoft SQL Server\80\Tools\Binn\SQLDMO.dll.
I did just that and now I’m able to successfully connect to SQL 2005 via D
MO.
YIPPEE
"Pauly C" wrote:

> I have an application writing in VFP that is used to manage some database
> processes, some of these processes are currently writing in DMO. We are i
n
> the process of upgrading to sql 2005 and I’m running into some trouble.
I’m
> currently changing some of the process to t-sql statements but I have an
> issue where I think I need to use DMO. I’ve installed the backwards
> compatible objects but I can not seem to connect via DMO. I have a defaul
t
> instance of sql 2000, a named instance 2000 and a named instance of 2005
> running on laptop running XP Tablet edition.
> Code
> ox= CREATEOBJECT("SQLDMO.sqlServer")
> ?ox.Connect("MA-ENG-PCANINO2\sql2005","sa", "SASA")
> Executing that returns this error.
> OLE IDispatch exception code 55555 from Microsoft SQL-DMO (ODBC SQLState:
> 42000): [Microsoft][ODBC SQL Server Driver][SQL Server]To connect to this
> server you must use SQL Server Management Studio or SQL Server Management
> Objects (SMO)...
> Thank you in advance.
> Pauly C
>

Distribution Agent error

I use SQLServer2K to manage a sortation system. I have
one server that acts as the primary server and a backup
server that subscribes to the publication on the primary.
Lately, my distribution agent has been failing with the
following comment as the Last Action:
"The row was not found at the Subscriber when applying
the replicated command."
The time stamp shows this to occur at the beginning of
the work day. The last command run is
'CALL sp_MSdel_tblData (1920859)' where tblData is one of
the articles in a transactional publication. I also note
the Transaction Log start to pile up.
To clean things up, I wait til the end of the work day
(when replication should be idle) and do the following
procedure in this order:
1) Run the sp_ReplDone stored procedure.
(EXEC sp_repldone @.xactid = NULL, @.xact_segno = NULL,
@.numtrans = 0, @.time = 0, @.reset = 1)
2) Reinitialize subscriptions.
3) Run the snapshot agent.
4) Restart the distribution agent.
5) Backup the Transaction Log file.
6) Shrink the Transaction Log file.
USE Database
GO
DBCC SHRINKFILE (Database_Log, 1)
GO
Everything seems to run fine until the next morning and
the dist agent fails again. Is there something I'm
lacking? or am I doing something out of sequence?
Roger.
When you get this problem it means that the distribution agent is trying to
delete a row on the subscriber that does not exist there.
The first thing you have to do is identify why you have a database
consistency problem between your publisher and subscriber. You should run a
validation to determine how out of sync you are and then figure out why your
subscriber is out of sync. Are there any ohter processes writing to the
subscriber? Any users incorrectly pointing to this database instead of teh
publisher. You might want to run profiler to identify them.
If you like to live dangerously you can use the continue on data consistency
errors profile of the distribution agent, but then you will have no idea how
out of sync your subsciber is, or whether it is getting progressively out of
sync, or getting more in sync.
Your Transaction log should not be "filling up". You should be dumping it to
prevent the log from getting too large. For VLDBs dump every minute. Run the
full recovery model for best results, although you can run the simple
recovery model if you simply don't care about point in time recovery.
run a dbcc opentran to see if there are any open transactions and if you can
kill them.
if there is a value for the oldest non distributed transaction, your log
reader is getting behind or stopped.
While your strategy does work, it is not the best approach for this problem.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Roger Denison" <anonymous@.discussions.microsoft.com> wrote in message
news:243601c49bfc$47b93340$a601280a@.phx.gbl...
> I use SQLServer2K to manage a sortation system. I have
> one server that acts as the primary server and a backup
> server that subscribes to the publication on the primary.
> Lately, my distribution agent has been failing with the
> following comment as the Last Action:
> "The row was not found at the Subscriber when applying
> the replicated command."
> The time stamp shows this to occur at the beginning of
> the work day. The last command run is
> 'CALL sp_MSdel_tblData (1920859)' where tblData is one of
> the articles in a transactional publication. I also note
> the Transaction Log start to pile up.
> To clean things up, I wait til the end of the work day
> (when replication should be idle) and do the following
> procedure in this order:
> 1) Run the sp_ReplDone stored procedure.
> (EXEC sp_repldone @.xactid = NULL, @.xact_segno = NULL,
> @.numtrans = 0, @.time = 0, @.reset = 1)
> 2) Reinitialize subscriptions.
> 3) Run the snapshot agent.
> 4) Restart the distribution agent.
> 5) Backup the Transaction Log file.
> 6) Shrink the Transaction Log file.
> USE Database
> GO
> DBCC SHRINKFILE (Database_Log, 1)
> GO
> Everything seems to run fine until the next morning and
> the dist agent fails again. Is there something I'm
> lacking? or am I doing something out of sequence?
> Roger.