hi expert
i have some questions
can any one answer to them?

what is difference between sql2005 express that attached to visual studio.net 2005 and sql erver 2000 or sql server 2005?

why we can not remote to sql express with SQLConnectio Class?
how i can run a stored procedure on SQL Express similarly that i run my stored procedure on sql server 2000?

we know for runnig my sql server data we need to MSDE for attaching my sqlFile on it// do we need MSDE SQL files that created with SQL Express?

where can i found information about using SQL Express inside the C#.NET 2005 ?

thatnks lot
regards

First the easy one. The difference between SQL Express and SQL Server is that SQL Express has limitiation on the size of database's you can attach to it (4GB) where a SQL Server database has a max size of about 1.2TB

All of your other questions I can not answer as I do not use the SQL Manager inside of Visual Studio as it provides limited functionality; I use SQL Server 2000 at work and I use SQL Server 2005 Express for my personal projects. In the latter of the two instances, I am connecting to the SQL Server 2000 Server in code and the MDF file isn't actually attached to my project in Visual Studio.

Imar or Peter may be able to better answer your other questions.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

You can do quite a bit with the database tools inside Visual Studio / Visual Web Developer, including creating new databases, managing tables, views, stored procedures and so on.

However, you may also want to get the free Management Studio for Express: http://www.microsoft.com/downloads/d...DisplayLang=en

It's similar to the official tools that come with the commercial versions of SQL Server 2005 and allow you to manage your database, create queries and so on.

There's not much difference between a database attached to Express and one attached to SQL Server 2005. You can grab a database created with 2005 Express and then attach it to a commercial version of SQL Server 2005. (Obviously, since 2005 added a lot new features, there are many differences between a 2000 and a 2005 database). So, you can create your system using the Express edition, and then "go live" on a commercial version of SQL 2005.

Check out the SQL Server section on the Microsoft site for more details.

Hope this helps,

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.