Stack Overflow
Stack Overflow

Questions tagged [sql-server-2008-express]

SQL Server 2008 Express is a free edition of SQL Server that is an ideal data platform for learning and building desktop and small server applications, and for redistribution by ISVs.

Microsoft SQL Server 2008 Express is a powerful and reliable data management system that delivers a rich set of features, data protection, and performance for embedded application clients, light Web applications, and local data stores.

It is a version of Microsoft's SQL Server relational database management system that is free to download or distribute. It comprises a database specifically targeted for embedded and smaller-scale applications. The product traces its roots to the Microsoft Database Engine (MSDE) product, which was shipped with SQL Server 2000. The 'Express' branding has been used since the release of SQL Server 2005.

340 questions
0
votes
1 answer

Sql Server Express failed to generate user instance

I am using Visual Studio 2010/c# and created an application where I am trying to access as a data source,a database which I created in SQLSERVER Express (via management studio). I have several instances from previous installs which I remove - SQL…
user1555945
  • 21
  • 3
0
votes
1 answer

Can't connect to SQL Server 2008 express through a vb.net application remotely

I have done subsequent research on how to connect to SQL Server remotely and even configured it to allow remote connections. Now I can connect to my sql server instance on remote computer through SSMS but while connecting through my vb.net…
user1556885
  • 1
0
votes
1 answer

How Create DataBase in SqlServer2008 Express With Code Lines

I Work on C# Project (WinForm) I Install Sql Server 2008 Express On Client PC. in Start Of My Program Must Create a Database. So I Use This Code For Create a Database: string sqlCreateDBQuery; SqlConnection tmpConn = new…
mehdi
  • 59
  • 4
  • 10
0
votes
1 answer

Generating Schema and Data for SQL Server Express Edition with Advanced Services

I have Microsoft SQL Server Express Edition with Advanced Services for 2008. I only see script option for the database and not for Schema and Data. Is this feature available in SQL Server Express Edition? I came across a resource which…
kalls
  • 2,797
  • 17
  • 55
  • 75
0
votes
1 answer

how to create a scheduler to make an SQL Server DB back up?

I have created a database in SQL Server 2008 Express Edition. Can I write a program in VB.net express to take a daily backup at a specified time? What code do I need to write?
Red Swan
  • 15,157
  • 43
  • 156
  • 238
0
votes
1 answer

How do I insert a Date and Image into my table?

CREATE TABLE Kitaplar ( Id INT NOT NULL, Isim NVARCHAR(50) NOT NULL, Yazar NVARCHAR(50) NOT NULL, Resim IMAGE, Alinis_Tarihi DATE, Verilis_Tarihi DATE, PRIMARY KEY (Id) ) I have this table and I want to create an instance. insert into Kitaplar…
Anıl Canlı
  • 432
  • 9
  • 20
0
votes
1 answer

SQL Server 2008 Express - Split Date and Time / Change Date / Concatenate New Date with Original Time

I'm relatively new to SQL and need to do the following Split a Date and Time Change the Date Concatenate the New Date with Original Time Any help on this would be greatly appreciated as Google searches haven't found me anything yet! Thanks Paul
user1343776
  • 1
0
votes
1 answer

MVC3 web app / tutorial won't "log in" using ASPNETDB.mdf on IIS7 webserver

I have just uploaded my MVC3 ASP.net web application to my server 2008 R2 IIS 7.5 Express webserver. The web app loads fine, but when clicking on the logon link and either trying to register a user account or log a existing user account on I get the…
Harry
  • 735
  • 5
  • 16
  • 27
0
votes
2 answers

I want to install SQL Server 2008 Enterprise and SQL Server 2008 Express on the same machine, which should I install first?

I want to install SQL Server 2008 Enterprise and SQL Server 2008 Express side-by-side on the same machine, which should I install first for a simpler install process and easier maintenance in future?
Tom Robinson
  • 8,348
  • 9
  • 58
  • 102
0
votes
1 answer

SQL Server 2008 R2 and SQL Serve 2008 Express not playing ball

I have a database created on a box using SQL Server 2008 Express and am developing a website between that and another box (set up by a friend a while back) using 2008 R2. Unfortunately, I've hit two problems. The first is that on the R2 box, while…
Nodoid
  • 1,449
  • 3
  • 24
  • 42
0
votes
3 answers

SQL Server Express 2008 Connection Error (26)

So I have few ASP.NET apps all running off SQL Server Express 2008 and working fine and dandy. I just put up a new one to test something and am now getting the Error 26 - can't find instance. What's weird is that the app is talking to the DB…
Valien
  • 1,125
  • 2
  • 17
  • 38
0
votes
2 answers

SQL2008 Express Edition: two instances on same computer?

Can we installed two instances of Express edition? I have one instance installed and when I try to install 2nd one, Product Key page/optionbs is grayed out (Specify Free Eidtion / Enter Prod. Key) Is it by design or due to something I am missing…
Tom
  • 3
  • 1
  • 5
-1
votes
1 answer

i am using Visual web developer 2010 express with sql server 2008 R2 ...i m not able to access the default database named "ASPNETDB.MDF"

error is network related or instance specific error occurred while establishing a connection with SQL Server. The Server was not found or was not accessible. Verify that the instance name is correct and SQL Server is configured to allow remote…
Kamesh Biniwale
  • 1
  • 2
-1
votes
4 answers

How to convert YYYY-MM-DD HH:MM:SS TO MM-DD-YYYY HH:MM:SS IN SQL Server?

How to convert yyyy-mm-dd hh:mm:ss (in 24 hours format) to dd-mm-yyyy hh:mm:ss (in 24 hours format? I am using Sql Server 2008. Given Date Format: 2017-12-18 18:16:49 - Its in DateTime format Required Date Format: 18-12-2017 18:16:49
Md Kamran Azam
  • 129
  • 2
  • 17
-1
votes
2 answers

Using ANY free SQL Server version to simply create a local SSIS/dtsx file run on local machine

Yes I KNOW there are a lot of questions about this on styack overflow, and I'm sorry but all I found was reading through dozens and dozens where every one seemed to disagree, or things were terribly version specific and more importantly - many of…
Isaac
  • 351
  • 1
  • 4
  • 21
1 2 3
…
22
23