Re: Opening large databases in Query Analyzer

Sorry, my bad. I meant SSMS.

In a nutshell, here's what happens:

1. I create a database in SQL Server 2000.
2. I use Primeworks Data Port Wizard to port the database to a SQLCE 2.0
SDF. (I can verify that this SDF is good because I use it in a Windows Mobile
application.)
3. I use Upgrade.exe on the Windows Mobile device to upgrade the SDF to SQL
Server Compact Edition (deployed to another version of the same application
ultimately to be deployed on a different device). (I can also verify that
this SDF is good because I can use it in my application.)
4. I load the SQL Server Compact Edition SDF in SSMS so I can make a small
change in one of the tables (a data change, not a schema change). In this
case, I update one character in an nVarChar(50) field.

As soon as I do step 4, the database gets corrupted. In one of the databases
I edited yesterday, the database grew from 268,480 KB to 400,256 KB. This
type of extreme growth does not always happen to every database I edit, but
there is always some kind of change that renders the database inert.

After the corruption, I am still able to open and access the database in
SSMS, but not in my Windows Mobile application. Calls to SqlCeConnection.Open
hang. Running compact and repair usually helps, but never fixes it entirely.

I will contact you as you requested. Thanks.

-djlucas

"Laxmi Narsimha Rao Oruganti" wrote:

I am confused here. Are you using SSMS or SSIS? SSIS standars for SQL
Server Integration Services and helps in Data Transfer Services. I am not
sure if SSIS has any 'edit table' kind of support. If you were indeed
referring to SSMS, I would definitely be interested in how the database is
getting corrupted. So far I have not seen a database getting corrupted for
such simple operations in v3.1 or v3.5. Can you please give more details on
how everything is done to make a database corrupted. Also if possible can
you contact us at our team blog http://blogs.msdn.com/sqlservercompact/ and
choose 'Contact Us' option. So that we really can nail down the issue.

Thanks,
Laxmi


"djlucas" <djlucas@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:750C9239-3336-4337-A7CA-24031F0A90C8@xxxxxxxxxxxxxxxx
That hasn't worked out too well for me. I've found that SSIS consistently
corrupts my SQL Server Compact Edition databases when I use it to edit
them.
Simply updating one field in one record damages it.

Thanks anyway.

"Laxmi Narsimha Rao Oruganti [MSFT]" wrote:

Unfortunately, Query Analyzer does not have any menu to take extra
connection string parameters like "Max Database Size" in this case.
Please
copy over the database to desktop and use VS IDE or SSMS to open the
database.

Thanks,
Laxmi

"djlucas" <djlucas@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8FB86F4E-8076-47B6-952C-20445DB58D38@xxxxxxxxxxxxxxxx
Is it possible to open a Compact Edition database larger than 128 MB in
SQL
Server Compact Edition Query Analyzer on a handheld device? Whenever I
try
to, I get the error: "The database file is larger than the configured
maximum
database size. This setting takes effect on the first concurrent
database
connection only. [Required Max Database Size (in MB; 0 if
unknown),,,,,]".
I
know how to overcome this in scenarios where I can specify a connection
string, but so far I haven't been able to find any documentation on how
to
overcome this in Query Analyzer on the device.

TIA.






.

Relevant Pages

  • Re: SQL Server Management Studio Cannot Open SQL Express Files
    ... Currently I can work with the DB in SSMS but not in VS. ... I suggest you to open SQL Server Configuration Manager and see how many SQL ... If I create the database in VS2005 using the ... If I create the DB in Management Studio I cannot work with it in VS2005. ...
    (microsoft.public.sqlserver.tools)
  • Re: data provider
    ... When I talk about a sdf file in my mind its a SQL Server Compact edition ... access the SSCE database and since express is free and can open sdf files I ... my current foxpro program will insert data from our foxpro database into ... Express Edition or SQL Server Compact Edition? ...
    (microsoft.public.sqlserver.ce)
  • Re: SSMS problem PS
    ... Tibor Karaszi, SQL Server MVP ... I see no way of doing it and I got a web site that hs been down for 2 days because it no longer has a user account for the database. ... I have both VS and SSMS on a number of machines, and I don't use VS to manage my databases. ...
    (microsoft.public.sqlserver.tools)
  • Re: SSMS problem
    ... I have both VS and SSMS on a number of machines, and I don't use VS to manage my databases. ... I'd check of you have the exe file for SSMS installed. ... I found out that the reason SSMS is not showing up is because Visual Studio 2005 is installed and you have to use its software to deal with the database. ... The other problem is adding a new user to SQL server for the purpose of having a web site that uses that database. ...
    (microsoft.public.sqlserver.tools)
  • Re: Need Help With Express Edition Tools
    ... created using SQL Server 2000 that I'm using in an ASP.NET ... I can open the database just fine and use it in the ... but when I try to attach to it from SSMS ... as the database file is already open by the the user instance. ...
    (microsoft.public.sqlserver.tools)
Loading