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

Retrieving an Image from SQL using C# to an asp:Image

I am trying to retrieve an image from SQL Server 2008 Express and insert it into an . I have tried using a MemoryStream but I just can't seem to get it right. My C# code at the minute looks like: try { con.Open(); …
Ciara Murphy
  • 43
  • 2
  • 6
0
votes
0 answers

Simple stored procedure with linked server select query inside works only once from .NET app

I am playing a few days with annoying problem with stored procedure with linked server usage. On the server I have shared DB. The server is running MS SQL Server 2008 EE sp3. As new user I cannot put images so I will try without So assume that I…
MartinM
  • 61
  • 1
  • 2
  • 6
0
votes
1 answer

SQL Server 2008 Express and windows authentication

I have a SQL Server 2008 Express instance running and I can access the server with the default account sqlexpress using sqlcmd. Now I have created a new windows account on the machine where SQL Server is running and created a login for sqlexpress…
cableload
  • 4,215
  • 5
  • 36
  • 62
0
votes
1 answer

SQL Server Express much faster than SQL Server?

Does anyone know why SQL Server Express could be much faster that full SQL Server from VBA code? The difference is huge so I wonder if it could be in drivers? Thanks for your thoughts.
Karel Bém
  • 97
  • 8
0
votes
3 answers

cannot open database

Not sure why this is failing...I'm sure it's my fault. Any help would be greatly appreciated. I'm getting the classic Cannot open database "Northwind" requested by the login. The login failed. Login failed for user 'MyMachine\MyUserName'. I can…
Anonymous
  • 1,978
  • 2
  • 28
  • 37
0
votes
1 answer

Transfer a database to SQL Server 2008 from SQL Server 2008 Express

Anyone know the generic practices transfer the database to SQL Server 2008 from SQL Server 2008 Express (I'm not sure it is r2), when I try to attach the .mdf file from Express, there is an error message. the database cannot be opened because it…
hkguile
  • 4,235
  • 17
  • 68
  • 139
0
votes
1 answer

Connecting microsoft sql server 2008 r2 to netbeans IDE 7.0 "error 18456 severity 14 state 38 login failed"

I have been working on this for last two days and I just can't finish it! I'm trying to add Microsoft Sql Server 2008 r2 to netbeans 7 by using Jtds or sqljdbc and none of them seem to work. Both of them are giving me this error:…
First R0cRid3r
  • 55
  • 2
  • 8
0
votes
1 answer

SQL Server 2008 Filestream File Size Contribution

Just a question regarding the Filestream in SQL Server 2008: does the size of the file itself contribute to the total size of the database, or because the Filestream stores in the file in the NTFS, and stores the relative path in the database (this…
Heinrich
  • 2,144
  • 3
  • 23
  • 39
0
votes
1 answer

SQL Server Express : Reporting Services.. limitations on charts?

If you look the Edition Comparison... It says for Express Edition that this option is not enabled for SQL Server Express.. Enhanced Gauges and Charting Anyone know what the limitations are on this item? I can't seem to find any more…
Brett
0
votes
3 answers

How to input data into SQL Server for first time start of C# application

I created a C# program using SQL Server 2008 Express. There is some data that must exist in the database table initially, for the C# application to run correctly. I would like to transfer this data into the table the first time the C# application…
Mahdi Radi
  • 429
  • 2
  • 10
  • 30
0
votes
1 answer

How to connect to SQL Server 2008 R2 using SQL Server 2008 Express via stored procedures

How to connect access the data from SQL Server 2008 R2 database using SQL Server 2008 Express through stored procedure?
Saranya Jothiprakasam
  • 294
  • 2
  • 6
  • 17
0
votes
2 answers

Unable to Load Database project in VS2008

I have Database project which I'm unable to load in VS2008 and I have SQL Server 2008 Express edition installed on my machine.. I get following error message, when I try to load Database projects require a connection to a local instance of…
Prashant Cholachagudda
  • 13,012
  • 23
  • 97
  • 162
0
votes
1 answer

Bulk copy all tables from sql server 2008 to sql server express on Amazon RDS

I am attempting to copy about 5GB of reference data from a local SQL Server 2008 standard instance to a SQL Server 2008 Express instance on Amazon RDS. (This is a once off import) Amazon recommend using Bulk Copy for anything larger than ~ 1GB. I…
bcleary
  • 1,268
  • 10
  • 17
0
votes
2 answers

How to use delete cascade in stored procedure?

I just need some in help to implement delete cascade in my stored procedure because I have REFERENCE constraint error Create PROCEDURE [dbo].[DeleteProject] @ProjectID uniqueidentifier AS BEGIN -- Insert statements for procedure here …
user474901
0
votes
1 answer

SQL Server 2008 Express 32-bit Import and Export Wizard installation

My first post on StackOverflow, so please excuse me if I am being ignorant. Lately, I have been playing around with MS Visual Web Developer for work purpose, and I have installed the 2008 Express edition on both my home and work computers. I only…
C.F.
  • 97
  • 2
  • 3
  • 8
1 2 3
…
22 23