Compress MSDE DB

Is there a way to run a compress using the command line?
If so what is the command?
What do you mean by compress the MSDE ? If you want to try to shrink the
logfile / the datafiles (releasing unsused space int the files to the
operating system) you could try executing the commadn to compress these
files via osql.exe
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Jon" <anonymous@.discussions.microsoft.com> schrieb im Newsbeitrag
news:175901c54f32$3e0b1540$a601280a@.phx.gbl...
> Is there a way to run a compress using the command line?
> If so what is the command?

compress database....

I work with MSDE, now the dimensions are of 2 GB...I have deleted many pages, is possible to compress the database?

Thanks in advanced

What is likely taking up so much space is the transaction log. Each time you perform data updates MSDE (SQL Server, actually) keeps a record of this in a transaction log. Performing a BACKUP operation will automatically clear out the transaction log (because for MSDE the "truncate log on checkpoint" opton is automatically set to ON).

Have you performed a BACKUP of your MSDE database?

Alternately, you should be able to perform aDBCC SHRINKDATABASE.

completely ignorant

Hello, I admit I am completely ignorant of MSDE and SQL in general. Ive
developed many things with php / mysql and a few with access but MS SQL is a
completly new beast for me. Ive been told i need to develop it locally with
MSDE then upload the finished project to the SQL server and just change the
connection string.
Ive installed MSDE (i think) with the SAPWD switch, the installed completed.
Now how do I get access to it? Is there a GUI I can download (like
mysqlAdmin) or does access act as a front end?
Im not even sure that I have it installed right or that it is running. If
there is anyone that would be as kind as to help me though this I would be
most greatful.
hi,
eramus wrote:
> Hello, I admit I am completely ignorant of MSDE and SQL in general.
> Ive developed many things with php / mysql and a few with access but
> MS SQL is a completly new beast for me. Ive been told i need to
> develop it locally with MSDE then upload the finished project to the
> SQL server and just change the connection string.
> Ive installed MSDE (i think) with the SAPWD switch, the installed
> completed. Now how do I get access to it? Is there a GUI I can
> download (like mysqlAdmin) or does access act as a front end?
> Im not even sure that I have it installed right or that it is
> running. If there is anyone that would be as kind as to help me
> though this I would be most greatful.
wow... this deserves a book :D
anyway, you can use Access as front end for MSDE, or you can have a look at
other free and/or commercial tools listed at
http://www.microsoft.com/sql/msde/partners and/or
http://www.aspfaq.com/show.asp?id=2442...
please download and install the SQL Server Books On Line from
http://www.microsoft.com/downloads/d...displaylang=en ,
the best guide ever you need to run and reference for your activity
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||"Andrea Montanari" wrote

> wow... this deserves a book :D
;-)

> anyway, you can use Access as front end for MSDE, or you can have a look
> at other free and/or commercial tools
Or use the commandline tool osql.exe (which is included with MSDE)
This gives you the option of a nice crash course in T-SQL
With BOL (Books OnLine) it is possible :-)
http://www.microsoft.com/downloads/d...displaylang=en ,
- Peter
|||Hi,

> Hello, I admit I am completely ignorant of MSDE and SQL in general. Ive
> developed many things with php / mysql and a few with access but MS SQL is
a
> completly new beast for me. Ive been told i need to develop it locally
with
> MSDE then upload the finished project to the SQL server and just change
the
> connection string.
> Ive installed MSDE (i think) with the SAPWD switch, the installed
completed.
> Now how do I get access to it? Is there a GUI I can download (like
> mysqlAdmin) or does access act as a front end?
Try our tool, it works fine with MSDE and its called Database Workbench
www.upscene.com
It also includes MySQL connectivity and schema migration tools.

> Im not even sure that I have it installed right or that it is running. If
> there is anyone that would be as kind as to help me though this I would be
> most greatful.
>
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Compatibility of MSDE with .NEt

Hai frnds,

Can i use MSDE for my .net applications instead of SQl server ?

Yes.|||

Can u sugget some good documents regarding MSDE compatibility with .NET

Applications

|||

There's nothing much to say. MSDE is basically the same thing as SQL Server execept some performance limitations and missing components (no graphical interface tools, no analysis services etc). Other than that it supports exactly the same SQL syntax and data types, views, triggers etc like SQL Server 2000 and for connection you use the same classes (System.Data.SqlClient) and connection strings.

You may also want to check SQL Server 2005 Express Edition which is also free and works with .NET and replaces MSDE. See http://www.microsoft.com/sql/editions/express/default.mspx

http://www.microsoft.com/sql/editions/express/upgrade.mspx

http://www.microsoft.com/sql/editions/express/features.mspx

Compatibility between sql express and MSDE

I need to know if I will run into problems with sql express on a sql 2000 server. I get the impression that my isp is using 200 server just by lookng at the connection string. Is there a addin I could use if needed I seen a post mentioning the publishing wizard cpt but not much after is it released yet. and then there is the web data admnistrator for msde will that work with sql express.One other question can I reinstall sql and change the authentication process from windows to user name and password.

DKB

Compatibility between sql express and MSDE there is none, it is not simple to move SQL Server 2005 database to 2000 it is covered in details by another user in the thread below.

http://forums.asp.net/thread/1494648.aspx

To use SQL Server with password you need to change to mixed authentication mode and that is covered in the SQL Server docs below. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms188670.aspx

|||

Thank you Caddre I guess I will have to wait and see by the looks of it I have two options find a new isp or unistall the instances that are installed and remove sql express and install msde.

DKB

Compatibility between installation of MSDE 2000 and SQLServer 7

I want to install MSDE 2000 rel A on a Windows Server 2000 where SQLServer 7
is installed.
CAn I do it? Can MSDE and SQLServer live together?
Must I do any action before to install MSDE?
Thank you in advance
enzo giurleo
hi Enzo,
Enzo Giurleo wrote:
> I want to install MSDE 2000 rel A on a Windows Server 2000 where
> SQLServer 7 is installed.
> CAn I do it? Can MSDE and SQLServer live together?
> Must I do any action before to install MSDE?
> Thank you in advance
> enzo giurleo
you can install MSDE 2000 on a pc already hosting SQL Server 7.0..
SQL Server 7.0 will be the default instance, as it does not support multiple
instances, while MSDE will become a named instance you have to connect to
using the <computername>\<instancename> syntax but...
but...
MSDE 2000 will install and register it's own part of the shared component,
such as SQL-DMO and so on, and it does not contain the full client tools
like Enterprise Manager, Query Analyzer, Profiler and so on, so you loose
the possibility to administer your SQL Server 7.0 with your original 7.0
tools...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Compatability between MSSQL server and MSDE??

Can we install both MSSQL and MSDE in the same server? And can they operate
at the same time? Just in case when the CAL is exceeded in the SQL server I
can use MSDE as alternative for other applications.
Yes, you can run them at the same time. Only one can be a default instance, the other(s) need to be
named instances.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"AdrianY" <AdrianY@.discussions.microsoft.com> wrote in message
news:8B83C9E8-0449-4ECA-85D2-7556D5121F5E@.microsoft.com...
> Can we install both MSSQL and MSDE in the same server? And can they operate
> at the same time? Just in case when the CAL is exceeded in the SQL server I
> can use MSDE as alternative for other applications.

Compatability between MSSQL server and MSDE??

Can we install both MSSQL and MSDE in the same server? And can they operate
at the same time? Just in case when the CAL is exceeded in the SQL server I
can use MSDE as alternative for other applications.Yes, you can run them at the same time. Only one can be a default instance, the other(s) need to be
named instances.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"AdrianY" <AdrianY@.discussions.microsoft.com> wrote in message
news:8B83C9E8-0449-4ECA-85D2-7556D5121F5E@.microsoft.com...
> Can we install both MSSQL and MSDE in the same server? And can they operate
> at the same time? Just in case when the CAL is exceeded in the SQL server I
> can use MSDE as alternative for other applications.