Too Many Email Accounts


I've just downloaded and installed sql server 2005 compact edition, and I'm having some issues that I'd like to get clarification on. Minor stuff, but irritating.

1. Although you can drop an sql file onto the management studio for a normal mssql connection, you can't do this with a compact edition connection. Instead you have to paste the contents. True Or am I goofing up somehow

2. Compact edition doesn't support varchar, but does support nvarchar. True Or [etc]

3. I can't seem to get compact edition to run a sql script. It seems to only take one command at a time. I'm pretty sure this is a screwup on my part since the tutorials show scripts being run. Are there limitations that I don't know about

TIA for any help.





Re: Early issues with Compact Edition

Laxmi Narsimha Rao ORUGANTI MSFT


Thanks for using SQL Server Compact.

1) We integrate with tools for big products like SQL Server Management Studio, Visual Studio. We have just strated this. Sure, we will take this feedback and improve upon like Drag-N-Drop you are expecting.

2) Yes, we dont support varchar. The world started with ANSI and is now moving to UNICODE. We being new product started now, dont want to reinvent the wheel and started with UNICODE. After all UNICODE is super set of ANSI. And, we have internal techniques to store it in a compact manner. So, no plans to support varchar/char/text in future too.

3) SQL Compact does not support batch queries. However, in the tools you should not experience it at tools level like SSMS/VS. If you select multiple SQL queries, there is a batch processor in these tools which automatically splits the batch into individual queries and runs them. However, all of them are exected in a single transaction.

Thanks,

Laxmi