Udostępnij za pośrednictwem

SQL Server 2008 Express How Do I videos

  • Artykuł

Recently I’ve gotten a lot of questions about how to work with and connect to SQL Express data. (SQL Express edition is the free version of SQL Server that comes with Visual Studio). Well if you haven’t seen these videos on getting started with SQL Express you should check them out:

SQL Server 2008 Express How-To-Guide Series

I recommend this one in particular, SQL Server Express Troubleshooting which shows how to add logins to SQL server and troubleshoot connectivity problems.

Enjoy!

Comments

  • Anonymous
    February 04, 2010
    i was just thinking abt this sql server express conncetion to vb and here there is great posts thanks for that but how much express edition can handle in the meaning of the data size thanks again

  • Anonymous
    February 09, 2010
    Hi Athman, The free SQL Server Express edition supports 1 physical processor, 1 GB memory, and 4 GB storage. When you outgrow these limitations you can simply attach your database file to the full version of SQL Server without any code changes. HTH, -B

  • Anonymous
    February 16, 2010
    Greetings! Could you point me in the right direction please?  I am a VB.Net developer and have an application that uses SQL Express.   It works fine on my desktop but I am worried about deployment.   I am specifically worried about "attaching" during the connection.   Is there some way to create the "attaching" of a database during or part of deployment?   How do others solve this problem? I work all day with SQL Server and VB.Net but am weak on what is needed for a customer to connect the very first time to my database. Any suggestions?   Thanks! Bill Fournier Oregon

  • Anonymous
    February 17, 2010
    Greetings Beth, the link to SQL Server Express Troubleshooting  throws an error.

  • Anonymous
    February 17, 2010
    Hi Bill, Thanks for the heads up, looks like they changed the links. I updated the post. -B

  • Anonymous
    February 17, 2010
    Hi Bill, The way you deploy the database depends on many factors. Do you have a multi-user scenario? If so the best option would be to attach the database to a since machine's sql server instance then use a connection string to that. Auto-attach is only a single-user scenario.

  • Anonymous
    February 17, 2010
    The comment has been removed

  • Anonymous
    February 22, 2010
    Hi Bill, Here's information on how to do a single-user xcopy deployment on SQL Express database: http://msdn.microsoft.com/en-us/library/ms165716.aspx If you go multi-user then you would just attach this database to the SQL Server instance on one machine and then chance the connections strings of the client applications in order to connect to it. HTH, -B

  • Anonymous
    February 22, 2010
    Thanks Beth!   I appreciate your support. Bill

  • Anonymous
    May 30, 2010
    Hi Beth, huge fan here! I am having a hard time trying to figure out how can i display a related data from a child table when the user filter the parent table. In other words; I have a form with two tables with a One Two Many relationship, the parent is as detail view and the child is as grid view. I Also implemented a query filter, as seen in one of your videos on a none related tables scenario, on the dataset parent table, so that the users need to do a search in order to have the data loaded. The Form will load empty and all works fine but for the child data as i can't find a way on how to display it. Will appreciate any help on this one! Best Regards, 2005

  • Anonymous
    June 08, 2010
    The comment has been removed

  • Anonymous
    July 04, 2010
    Hello Beth thanx for for a whole lot of tutorials well i have created a database wanna know what to do to deploy them so that users in my network can update data from them

  • Anonymous
    January 27, 2011
    hi beth very very thanks for this teach nice teach i like your away of the learning .in one word .thanks

  • Anonymous
    July 28, 2011
    hello Beth how can you store data in a database using forms

  • Anonymous
    October 15, 2011
    An error occurred while establishing a connection to SQL Server instance '.SQLEXPRESS'. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

  • Anonymous
    July 07, 2012
    your vedio is so best but i wish that you could also put some vedio of login form for multiple users in vb.net and also crystal report thank