Stack Overflow
Stack Overflow

Questions tagged [sql-server-2008r2-express]

Use this tag for questions specific to scaled down, free edition of SQL Server 2008 R2.

223 questions
2
votes
2 answers

Unicode strings using ServiceStack.OrmLite in SQL Server 2008 R2 Express

We started to use .NET version of OrmLite in our C# project that uses SQL Server 2008 R2 Express storage. https://github.com/ServiceStack/ServiceStack.OrmLite Now we discovered that it is not possible to save Unicode characters to the table by using…
Janeks Malinovskis
  • 511
  • 1
  • 5
  • 8
1
vote
3 answers

Error connecting to SQL Server 2008 R2 Express

I have installed SQL Server 2008 R2 Express on Windows 7. When I run a web project in VS2010 I receive the following error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not…
royu
  • 377
  • 2
  • 5
  • 15
1
vote
2 answers

How do I create a new database on SQL Server in a unique new name?

I'm using Visual Studio 2010 ASP.NET with C# on .NET 4.0 and SQL Server 2008 R2. I would like to create a database on the server named WINSRV\SQLSRV. How do I loop to test for a unique database name? My default database should be ab. In case this…
elarrow
  • 687
  • 3
  • 11
  • 19
1
vote
0 answers

CHECK CONSTRAINT ignored by variables/parameters

I'm using a database splitted into several databases I will refer to as "partitions". Each partition holds the same data structure for a particular month. A view on the top of all the partitions does a big UNION for data retrieval, and each table of…
Rémy Esmery
  • 658
  • 6
  • 14
1
vote
1 answer

SQL Server 2008 R2 Express doesn't start automatically

I have installed SQL Server 2008 R2 Express. It is set to automatic start in services. But when I start computer, it doesn't start automatically. I have installed SQL Server 2008 R2 Express SP1 as well.
DotnetSparrow
  • 27,428
  • 62
  • 183
  • 316
1
vote
4 answers

SQL Server 2008 R2 Express with advanced services installation does not have all options

I don't know how else to ask this, and I think the title could be changed. I've been downloading different SQL Server Express versions, and I can't seem to find the one that has the Management Studio Express, the fulltext search, and the Reporting…
pqsk
  • 2,124
  • 3
  • 23
  • 28
1
vote
1 answer

Need help understanding a query involving "case" and "select into" clauses

I am puzzled by the output of the following query: select 'Eq Type' = case when substring([Eq Type], 1, charindex('-', [Eq Type]) - 1) = substring([Eq Type], charindex('-', [Eq Type]) + 1, len([Eq Type])) then …
Sergey Koulikov
  • 267
  • 4
  • 7
  • 16
1
vote
3 answers

Getting an error when moving from SQL Server Express to SQL Server asp.net web app logon

I just moved from Visual Studio Web Express to professional. (2010) I have a web application were the log-on database was linked to SQL Server Express, but my new installation does not have SQL Server Express? What I have now is SQL Server 2008 R2.…
Mike
  • 1,221
  • 3
  • 15
  • 34
1
vote
1 answer

Nested select statement in FROM clause? Inner Join statements? or just table name?

I'm building a query that needs data from 5 tables. I've been told by a DBA in the past that specifying a list of columns vs getting all columns (*) is preferred from some performance/memory aspect. I've also been told that the database performs a…
RoyM
  • 53
  • 2
  • 5
1
vote
2 answers

SQL Server 2008 R2 setup error on Windows Developer Preview

I'm trying to install SQL Server 2008 R2(Express) on Windows Developer Preview (32bit) but getting a strange error: --------------------------- Microsoft SQL Server 2008 R2 Setup SQL Server 2008 R2 setup requires Microsoft .NET Framework and an…
hotcoder
  • 3,176
  • 10
  • 58
  • 96
1
vote
1 answer

Slow SQL transaction blocks table

I have a very slow sql transaction, which inserts new rows in the table. All other "select" queries from another connections wait for this transction to unlock the table. Is it posible to fetch old rows from the table, while the first transaction…
user879096
  • 13
  • 3
1
vote
2 answers

Ideal Account to use for SQL Server 2008 R2 Express?

What is the ideal "Log On As" account to use for SQL Server 2008 R2 Express?
kroehre
  • 1,104
  • 5
  • 15
1
vote
1 answer

Given a SQL Express database base file (.MDF) how can I wipe/clear/reset the schema and/or data?

Whats options do I have to clear the schema and data from a MDF file? What options to delete all the data? To reset a databases schema, it seems I need to copy a file from a backup of the database when it was empty. I was wondering if there was a…
Frank Schwieterman
  • 24,142
  • 15
  • 92
  • 130
1
vote
1 answer

SQL Server 2008 R2 Express 10GB Filesize limit

I have reached the file size limit on my SQL Server 2008 R2 Express database which I believe is 10Gb. I know this because I see Event ID 1101 in the event log. Could not allocate a new page for database 'ExchangeBackup' because of insufficient disk…
David P
  • 411
  • 7
  • 21
1
vote
1 answer

Unable to install SQL Server 2008 R2 Express

When I try to install SQL Server 2008 R2 Express, I get the following message : The feature you are trying to use is on a network resource that is unavailable Click ok to try again or enter an alternate path to a folder containing the installation…
A.Pissicat
  • 3,023
  • 4
  • 38
  • 93
1 2 3
…
14 15