Mobile SQL 2005

[ThisBytes5]

Where can I find a Query analyzer for Mobile SQL 2005? I've done a bit
of searching and haven't found anything of much use.

Thanks

 

[Ginny Caughey [MVP]]

The best query analyzer to use with SQL Mobile comes with SQL Server 2005
Developer and it's called SQL Server Management Studio. Most people think of
using it with SQL Server, but it also works very well with SQL Mobile (but
not SQL CE) databases.

 

[ThisBytes5]

Ok, so how do I use the management tools to view the database?

 

[Ginny Caughey [MVP]]

There are a lot of resources on the web:
http://www.google.com/search?hl=en&q=sql+server+management+studio

Here's a tutorial:
http://msdn2.microsoft.com/en-us/library/ms167593(SQL.90).aspx

The main thing that's different when you're working with a SQL Mobile
database is that you specify that you want a SQL Mobile database to connect
to. The other main thing is that some of the functionality in Management
Studio doesn't apply (and is therefore disabled) when you're working with a
SQL Mobile database.