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

Local SQL Server 2008 R2 database not accessible on Windows 10

I've inherited the job of maintaining an application which uses a local SQL Server 2008 R2 SP2 Express database as a back-end. I successfully installed the application some months back after upgrading to Windows 10 so that I could start testing and…
jmriebold
  • 76
  • 1
  • 3
0
votes
1 answer

Memory error: Allocation failure : Excel Powerpivot Add on

The table I am trying to refresh using the Excel 2010 PowerPivot add on is currently 2,670,634 rows, and approximately 473 MB when I export the query results from SQL server into a CSV file format. The operating system is in 64bit but my installed…
Pho
  • 98
  • 1
  • 9
0
votes
0 answers

How can I know when my table got hit in sql server 2008 r2 express profiler when run from browser

I have one important table called Person among hundreds of tables. But, I'm not sure when it is coming into play. I have to capture table information in such a way that as soon as the Person table is queried by one particular page in the browser, it…
Ashok kumar
  • 1,593
  • 4
  • 33
  • 68
0
votes
1 answer

Data from SQL view in entity collection are not sorted

I have a simple SQL view with 2 columns. First is the primary key, which is an nvarchar, and the second is an int. View is ordered by the int column. When I load data using EF, data is not sorted how is specified in SQL. What do I need to do to…
Ondřej
  • 1,645
  • 1
  • 18
  • 29
0
votes
2 answers

asp.net cannot open database login failed

I'm using the following to retrieve data from a database but the SqlConnection won't open. It throws an error at scon.Open(). I'm sure it's elementary but I can't work it out. protected void Page_Load(object sender, EventArgs e) { …
matt2605
  • 216
  • 1
  • 3
  • 18
0
votes
1 answer

Could not connect to SQL Server 2008 R2 Express

I am using Microsoft SQL Server 2008 R2 Express, suddenly I got a error while I am trying to connect: TITLE: Connect to Server Cannot connect to DEBANJAN\SQLEXPRESS. ADDITIONAL INFORMATION: A network-related or instance-specific error occurred…
Debanjan Roy
  • 21
  • 1
  • 8
0
votes
0 answers

Incremental commit to optimise insert query

I have the following insert statement that i am running daily and updating approx 55,000 records. INSERT INTO dbo.ETL_INPUT ( SCH_APPT_ID ,SCH_EVENT_ID ,MRN ,PERSON_ID ,NAME_FULL_FORMATTED ,Main_Bookshelf_Old …
Lucas Perrett
  • 15
  • 4
0
votes
1 answer

How to pass absolute database name,server name as parameter?

I have a requirement where I need to select data from database DB1 and insert into database DB2. update [Server1\SQLEXPRESS].[DB1].dbo.table1 set CName = (select CName from [Server2\SQLEXPRESS].[DB2].dbo.table1 where…
yogeshkmrsoni
  • 315
  • 7
  • 21
0
votes
0 answers

error: 40 - Could not open a connection to SQL Server:-provider: Named Pipes Provider

I created a Windows Forms application using C# and SQL Server 2008 R2 as back-end. I also created a click-once installer package by adding Microsoft SQL Server Compact 3.5 as a prerequisites. If I install my application on computer that have SQL…
Shantnu
  • 127
  • 11
0
votes
1 answer

SQL Server produces bad/invalid/damaged XML with FOR XML

I've got a simple (?) problem. I have a table t_dane_nieruch with one column nr_ewid (int, not null) My query looks like this: select top 40 nr_ewid from t_dane_nieruch for xml auto, elements It produces this output: …
BojowyZajaczek
  • 419
  • 1
  • 3
  • 10
0
votes
2 answers

Install SQL Server 2008 R2 Express using C#

I am in a situation where I need to Install SQL Server 2008 R2 Express silently. I want to use C# for this but couldn't get a working solution. Can someone post a working C# code for above scenario?
SuryaSan
  • 63
  • 1
  • 6
0
votes
2 answers

Using sql function on CHECK constraint for newly inserted row

First of all i need help with this for my bachelor thesis. I'm doing the whole database on sql server 2008 Release 2. The problem is with check constraint that is using a function that is working on her own but not with the use in the constraint.…
Caen
  • 3
  • 3
0
votes
0 answers

Using batch file for running SQL Server Express with parameter silently

I use this code for running Microsoft SQL Server 2008 R2 Express in silent mode but this program exit with error @echo off set DIRPATH=%~dp0%Sql Express 2008 R2 set Auth=""NT Authority\SYSTEM"" if exist "%DIRPATH%" goto installProg echo file not…
amir aziz
  • 1
  • 2
0
votes
1 answer

Cannot connect to SQL Server 2008 R2 with Management studio

Today I get this strange exception: Error HRESULT E_FAIL has been returned from a call to a COM component. (mscorlib) I cannot connect to my database! Tool started under admin rights. Services:
Ievgen
  • 4,261
  • 7
  • 75
  • 124
0
votes
1 answer

Startup program has intermittant problems connecting to local database

I'm writing an application that runs from the start-up folder, and tries to connect to a local SQLServer2008-r2 database as part of the startup process of the application. The database i'm connecting to is set to use windows authentication, and my…
EACHahn
  • 3
  • 1
1 2 3
…
14 15