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

Failed to install SQL Server 2008 Express/Developer edition on WIndows Vista Ultimate (SP1)

I visited a few forums and tried everything short of wiping out and reinstalling OS while trying to install SQL Server 2008 Express; uninstalled failed installation everytime, cleaned up registry and install folder, disabled UAC, cleaned up WMI…
emkay
0
votes
2 answers

How Do I Attach a SQL Server Express Database to a Visual Studio 2010 project?

How do I do this? Attach an SQL Server Express Database to a Visual Studio project so that... my source control contains the most resent schema for the database including stored procedures (can' t use SQL Compact Ed. because need to be able write…
user297691
0
votes
2 answers

Is SQL Server 2008 Management Studio Express the same as Standard?

A while back, I installed SQL Server 2008 Express with Advanced Services, which installed SQL Server 2008 Management Studio (SSMS) Express as well. Now that we have SQL 2008 Standard on the network some months later, I want to confirm that I don't…
ddavis
  • 15
  • 1
  • 4
0
votes
1 answer

C# Insert new record to dataset with sql

i have spent the few days trying to get this to work and checked a tonne of tutorials but it still won't work. i get go build errors and it works perfectly, but the new row isn't loading into the dataset to be saved to the database. the data shows…
Ardenexal
  • 543
  • 6
  • 20
0
votes
1 answer

How can I compare 2 columns in 2 tables to check for UNEQUAL values

I have a table say Table 1 with column A with values {22,18,17} and another table Table 2 with column B with values {18,22} when I do a query like select * from Table 1 where column A not in (select column B in Table 2). This gives me 3 rows…
sreeprasad
  • 3,242
  • 3
  • 27
  • 33
0
votes
2 answers

How to specify a table dynamically in a Stored Procedure

Thanks for the feedback, but I was hoping for help with an UPDATE command, not SELECT. Can anyone help with the syntax for an UPDATE command? I am passing a table name into a Stored Procedure but the SQL does not seem to recognize it. DECLARE…
htm11h
  • 1,739
  • 8
  • 47
  • 104
0
votes
1 answer

How to view errors live while debugging a script or stored proc in SQL Server Express 2008

New to the SQL Server Express 2008 debugger. Here's what happens. Let's say I have stored proc with 4 delete statements and the 2nd delete results in a FK violation on some other table. When I exec the sp and flip to the messages tab (which is next…
Gullu
  • 3,477
  • 7
  • 43
  • 70
0
votes
1 answer

Cannot open database "UmbracoDB.myDB" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

I am receiving the following error: Cannot open database "UmbracoDB.myDB" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Previously to this error everything was running fine. My database is running as…
Obbles
  • 533
  • 3
  • 17
0
votes
1 answer

Most efficient procedure for migrating SQL Server Express databases from one location to another

What is the most efficient way to migrate an SQL Server Express database from one server to another? I have several databases that need to be moved, and I want to do as little work as possible and avoid breaking anything.
smartcaveman
  • 41,281
  • 29
  • 127
  • 212
0
votes
2 answers

How to integrate SQL Server Express with VS C# Express

I have just installed VS C# Express 2008 which includes SQL Server Express 2008. It all went ok and I can see VS C# and SQL Server in the list of installed products. When I start VS C# it looks fine but in the DB Explorer / Data Connection context…
paul
  • 13,312
  • 23
  • 81
  • 144
0
votes
4 answers

Enable SSRS My Reports using Express edition

Is there a way to enable the “My Reports” feature in SQL Server Reporting Services 2008 when I am using SQL Server 2008 Express edition with Advanced Services? As I am using Express edition, I cannot connect SQL Server Management Studio to Reporting…
Andy Jones
  • 1,472
  • 9
  • 15
0
votes
2 answers

Getting a ASP .NET MVC database working on a non-development machine?

This may be a basic question but I'm not very proficient in SQL Server. I am Using Visual Studio 2008 Professional. In a ASP .NET MVC 3 project I created a database that resides in 'App_Data'. The web.config file uses this as the connectionString…
John M
  • 14,338
  • 29
  • 91
  • 143
0
votes
1 answer

SQL Query doing strange thing

If I run this query on SQL Server Express 2008 : Insert NoteBook (Date, Note) Values ('11/04/2011 11:02:46', 'test') It stored the date as 04/11/2011 How can I prevent this?
TeaDrinkingGeek
  • 1,995
  • 5
  • 34
  • 52
0
votes
1 answer

Sql Server 2008 connection fails

I have two internet connections (let's say A and B) at my home using two different modem/routers. I am using Sql Server 2008 Express client to connect with a remote Sql Server 2008 server instance. I can connect easily when I use my internet…
Rohit Sahasrabudhe
  • 191
  • 2
  • 14
0
votes
2 answers

SQL Server 2008 Express - Got "The columns do not match an existing primary key or UNIQUE constraint" despite constraints being set

I have the following tables ModuleClass ( ,
, , StartDate, EndDate) ClassEnrollment ( ,
, , , Role) Now a ModuleClass entity can have more than one enrollment, so there is a 1 to M…
Extrakun
  • 19,057
  • 21
  • 82
  • 129
1 2 3
…
22 23