Stack Overflow
Stack Overflow

Questions tagged [sql-server-express]

Microsoft SQL Server Express is a freely downloadable and distributable version of Microsoft's SQL Server relational database management system. It is targeted for embedded and smaller-scale applications, having a number of technical restrictions.

1718 questions
17
votes
5 answers

SQL/C# - Best method for executing a query

I need to execute a sql query from within a c# class. I have thought of 2 options Starting a process of sqlcmd. Using a SqlCommand object. My question is which would be the better way? It's important that the solution only holds a connection to…
Ash Burlaczenko
  • 24,778
  • 15
  • 68
  • 99
16
votes
3 answers

How to check if SP1 for SQL Server 2008 R2 is already installed?

I have trouble figuring out if the SP1 is already installed. I don't think I could check it from the Management Studio as its a different application. But the SQl server it self has no UI to check under "about". :) Any ideas?
Houman
  • 64,245
  • 87
  • 278
  • 460
16
votes
7 answers

Can I get sql profiler for sql2008 for free?

Is it possible to get sql profiler for sql2008 for free or you have to have a license to get it? i.e. it won't work with sql express
Blankman
  • 259,732
  • 324
  • 769
  • 1,199
14
votes
3 answers

Can't Install SQL Server 2008 R2 Express

I have a problem with installing SQL Server 2008 R2 Express. On my computer, I have installed VC# and VWebdev 2010 express. It included SQL Server 2008 Express inside. After that, I did an upgrade to SQL Server 2008 R2 Express. The consequence is I…
Pipat Methavanitpong
  • 223
  • 1
  • 2
  • 7
14
votes
2 answers

How do I insert Chinese characters into a SQLExpress text field?

How do I insert Chinese characters into a SQLExpress text field? I'm using SQL Express from VS 2008. When I add Chinese characters, either via an import app I wrote or by pasting them in from the data view inside Visual Studio, they end up as…
Martin Shoemaker
14
votes
7 answers

Repair/Remove/Install processes for SQL Server 2012 Express get stuck or hung

An instance of SQL Server 2012 Express became corrupted somehow. I suspect it was related in some way to my use of Entity Framework, but have no proof yet. When trying to repair the instance, the repair process seemed to be stuck at the…
jk7
  • 1,958
  • 1
  • 22
  • 31
14
votes
6 answers

Crystal Report: Unable to connect incorrect log on parameters

When printing a report, the user sometime have the following error: CrystalDecisions.CrystalReports.Engine.LogOnException: Error in File C:\DOCUME~1\carolec\LOCALS~1\Temp\temp_b117cc2e-c184-4556-a493-e04e6d4126fb…
izokurew
  • 448
  • 1
  • 4
  • 15
13
votes
9 answers

create table permission denied in database 'master'

I have installed the free version of sql server 2008 (sql server management studio express edition) on my PC. After installation I get the following error create table permission denied in database 'master' I tried reinstalling several times, but I…
user1212
  • 861
  • 4
  • 13
  • 22
13
votes
1 answer

Violation of UNIQUE KEY constraint during SQL update

I have a simple database table (SQL Server 2008 R2 Express), which has a definition as follows: ID INT Auto Inc, PK Name VARCHAR(64) Unique Key Telephone VARCHAR(128) I have a stored procedure which I execute to update…
Bryan
  • 3,224
  • 9
  • 41
  • 58
13
votes
5 answers

How do I connect to the default instance of SQL Server if a "named instance" parameter is required?

I'm installing some software and I need to tell it to use the default instance of SQL Server, however the Installshield GUI insists that I enter in information for a named instance. The target SQL Server is version 2008R2 I'm hoping there is a clean…
makerofthings7
  • 60,103
  • 53
  • 215
  • 448
13
votes
3 answers

How to export an entire Access database to SQL Server?

I've just got a lovely Access database, so the first thing I want to do is to move it over to a normal database management system (sqlexpress), but the only solution I've found sounds like craziness. Isn't there an "export database to .sql" button…
marcgg
  • 65,020
  • 52
  • 178
  • 231
12
votes
4 answers

which datatype to use to store a mobile number

Which datatype shall I use to store mobile numbers of 10 digits (Ex.:9932234242). Shall I go for varchar(10) or for the big one- the "bigint". If the number is of type- '0021-23141231' , then which datatype to use?
sqlchild
  • 8,754
  • 28
  • 105
  • 167
12
votes
2 answers

sp_dropserver and sp_addserver not working

I am using SQL Server Express 2008 R2 and I wanted to change the instance name from "machine name"\SQLEXPRESS2008R2 to just "machine name". I ran: sp_dropserver 'old_name' go sp_addserver 'new_name', 'local' go Then restarted the SQL Service. …
scarpacci
  • 8,957
  • 16
  • 79
  • 144
12
votes
2 answers

How to connect to SqlExpress for Entity Framework using Visual Studio 2010 Express?

I'm trying to use the Visual Studio 2010 Express editions to set up an ASP.NET MVC 2 Web Application using SqlExpress + Entity Framework as the data access. I have both the "C# Edition" and "Web Developer Edition" installed. If I try to add a data…
Mike
  • 5,560
  • 12
  • 41
  • 52
12
votes
2 answers

SqlDataReader to read into List

I am writing a method in C# to query a SQL Server Express database from a WCF service. I have to use ADO.NET to do this (then rewrite it with LINQ later on). The method takes two strings (fname, lname) then returns a "Health Insurance NO" attribute…
reallybadatmath
  • 305
  • 1
  • 2
  • 11
1 2 3
…
99 100