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
1 answer

Controls spill over to next page in RDLC Report

Problem no 1 (refer pics): When the horizontal tablix expands at runtime, controls which are positioned after the tablix get pushed to the next page. Problem no 2 (refer pics): How to get vertical lines to expand at runtime? (the endpoints of these…
Prasad Kamath
  • 182
  • 2
  • 15
2
votes
1 answer

Transitioning from Domain Authentication to SQL Server Authentication

Greetings all, I've run into a problem that has me stumped. I've put together a database in SQL Server Express, and I'm having a strange permissions problem. The database is on my development machine with a domain user: DOMAIN\albertp. My…
Albert Perrien
  • 1,153
  • 12
  • 27
2
votes
4 answers

Read from Database and Insert into DataGridView

How i can read records from Database and Can insert into DataGridView. I don't want to bind data source. Just want to read and insert using While Loop. I know how to read from Database Sql Server 2008 R2 Express Edition But unable to insert records…
Mistr Mowgli
  • 131
  • 1
  • 3
  • 10
2
votes
1 answer

SQL Server : update multiple records from joined tables

I'm using SQL Server 2008 R2 Express in my test environment and the full version in production. I have written a select statement that finds all the records I want to update. About 1200 of them. It Joins multiple tables and the selection is based on…
David P
  • 411
  • 7
  • 21
2
votes
5 answers

select from subquery two times

I've got TableA with userAId and UserBId. I also got another TableB with UserId I would like to select all records from TableA in which userAId and UserBId are in tableB My solution is: select * from TableA where userAId IN ( select UserId…
gruber
  • 28,739
  • 35
  • 124
  • 216
2
votes
1 answer

"The server was not found or was not accessible" on local machine

I've upgraded to a Windows 8.1 machine, and installed SQL Server 2012 (version 11.0.3128.0), and SQL Server Express 2008 R2 (v 10.0.5500.0). I've created a database in the 2012 instance, and populated it by restoring it from a .BAK from another…
Ed McCarroll
  • 21
  • 3
2
votes
1 answer

SQL Server is executing two Insert queries simultaneously that results in the pulling of same registration no for two patients

I am using SQL Server 2008 R2 Express with VS2010 ultimate c#. It's a client server architecture software of registering patients. there are 4 clients where 4 users are registering the patients. When 2 users are registering 2 separate patients and…
user2831374
  • 21
  • 1
2
votes
3 answers

Splitting the results into separate columns

I need a view compatible SQL query to accomplish the following result (View 1). Table 1: -------------- ID | Folder -------------- 1 | foo 2 | bar Table 2: ------------------------------------- ID | Table1_ID | Name | …
Bonzai
  • 39
  • 1
  • 3
2
votes
2 answers

SQL Server 2008 R2 Express restore

I am working on project in which I have used visual c# as front end and SQL Server 2008 R2 Express for backend. Now I know that SQL Server express database has a size limit is of 10 GB, so I have written the code for database backup when pick limit…
Real Master
  • 347
  • 3
  • 14
2
votes
1 answer

Can the size of this SQL Server Express 2008 R2 installation (for client) be minimized more?

I want to deploy my application with an instance of SQL Server Express 2008 R2, the installation file is about 100 MB but after installed on the target computer, its final size is about 500 MB, it's too large for client's machine. I installed it…
King King
  • 61,710
  • 16
  • 105
  • 130
2
votes
3 answers

Order Query by Timestamp and Name from two Different Tables

Note: I am a little new to SQL Server, so this should be an easy question, and I apologize for mistakes in formatting this question. This is SQL Server 2008 R2. I have two tables. Table 1: DATA has key ID and columns PROD_ID, COLLECT_TS Table 2:…
user1811001
  • 23
  • 3
2
votes
1 answer

SQL Server flatten hierarchy table

I have this data in a recursive table, and I want to flatten this hierarchy information. I have accomplished this by doing a query but I was wondering if there is a better way to get the same result. Data that I have: CREATE TABLE…
foluis
  • 988
  • 2
  • 10
  • 23
2
votes
1 answer

Entity Framework one-to-one relationships errors on insert

I'm having some troubles getting a set of Entities setup to work correctly. I'm using EF v5 in VS2012 against SQL Server 2008 R2 Express. Everything seems to be correct with the generated database but I'm not having any success writing to some of…
Jammer
  • 9,969
  • 11
  • 68
  • 115
2
votes
2 answers

Accessing Server under Windows 7 x64

we decided to start a new project using the Microsoft SQL Server R2 under Win7. I installed SQLEpress R2 on my system and it was decieded to called it BEACONExpress. At first we could not get it to run, until we had our Domain SysApp come in and set…
user1181334
2
votes
4 answers

run-time error '3197'. MS Access 2010 and SQL Server 2008R2

I have an application written in MS Access 2007-2010 and a back end is an SQL database. After building a new database, when I view the records from SQL in the Access report, trying to edit or enter new input results with a run-time error 3197. The…
mikimr
  • 311
  • 3
  • 8
  • 18
1 2 3
…
14 15