Use this tag for questions specific to scaled down, free edition of SQL Server 2008 R2.
Questions tagged [sql-server-2008r2-express]
223 questions
0
votes
1 answer
How to Install SQL Server 2008 R2 Configuration Manager
I'm trying to install SQL Server 2008 R2 Express with SP2 from a command line.
Everything works fine, but the Configuration Manager is not being installed.
The file I'm using is SQLEXPRWT_x64_ENU.exe
the command line is
sqlexprwt_x64_ENU /q…
peterG
- 1,651
- 3
- 14
- 23
0
votes
2 answers
How do I get a substring value from a Sql column of varbinary type?
I am trying to get a substring, FIRST_NAME, attribute value from ADDRESS_XML column in a table using a simple select query. The column type is varbinary(1000).
GetXml is a custom method defined elsewhere which works fine.
My where clause is…
user3393933
0
votes
1 answer
SQL Server Error 26 When Using TableAdapter.FIll
When I am in the Dataset Designer and I ask to Preview Data on a Fill query all is well and data is displayed. When I try to use the TableAdapter.Fill method inside a program I get an exception for Error 26. This code was copied down from Team…
John D
- 1
- 1
0
votes
3 answers
How to deal with DATE column of multiple tables
I have 5 tables namely transaction, receipt, payment, wutran, mydates.
mydates table contains dates.It has only one single column that is dt.
and all remaining tables have two columns namely date,amount.
Now I have to calculate sum of the amounts…
Jasper
- 41
- 2
- 5
0
votes
3 answers
Schedule Stored Procedure in Microsoft SQL Server 2008 R2
I have to run a stored procedure on a daily basis at a particular time. I have struggled with Windows Service and after unsuccessful attempts I started looking into schedule a SQL job or schedule an event.
In order to schedule a SQL Server job I…
Sarah
- 1,895
- 2
- 21
- 39
0
votes
0 answers
Confused about creating mdf file
I have a window project. I am required to add Service based database. I have also added one.
After that I created a new table with few records. Visual studio prompted me where to store it. Then I saved it on the desktop.
But it's not a .mdf file,…
user3733078
- 249
- 2
- 11
0
votes
1 answer
Need to transpose Table Data with adding 0 for non existing column
I have data as follows -
FieldValue FiledID UnqiueID
Name1 13 1
Address1 14 1
NAme2 13 2
Address2 14 2
Name3 13 …
user1841927
- 35
- 1
- 6
0
votes
2 answers
Storing XML file in SQL Server 2008 R2 express
I am trying to store XML data into a SQL Server 2008 R2 Express database, every xml file has different data. What is the easiest way to do this?
What are the best options please explain with example.
user3202862
- 207
- 4
- 19
0
votes
1 answer
Exporting data from SQL Server 2008 r2 Express Edition
Is it possible to export data from a SQL Server 2008 r2 Express edition to a Standard edition?
Serhat Koroglu
- 1,263
- 4
- 19
- 41
0
votes
1 answer
SQL Case Statement Synax Error
I am new to SQL Server and doing a tutorial, but cant seem to find the error. It's exactly as the tutorial suggests, but won't execute. See error below. Does certain functionality need to be turned on? I am using SQL Server 2008R2 Express. Does that…
user3159004
0
votes
1 answer
Handling Intermittent SQL Timeout/Network Errors
I am working on an MVC application that connects to MS SQL Server 2008 R2. The development server is the Express Version - I don't know if that is a contributing factor...
Intermittently, when I run the application from Visual Studio (so it opens in…
Daniel
- 71
- 2
0
votes
0 answers
Stop reboot after installing SQL Server Express 2008 R2 SP2
We have a Wix Customer Bootstrapper which installs SQL Server Express 2008 R2 SP2 as an ExePackage.
Ranjith Venkatesh
- 1,322
- 3
- 20
- 57
0
votes
2 answers
How to Restore database automatically and periodically without Jobs?
I am allowing guest users to log onto my database and so I want to restore the database once a week to wipe it of the quest users details, etc.
I am using SQL Server 2008 R2 Express. This version does not have Jobs.
Is it possible to automatically…
TreasaNGC
- 62
- 1
- 10
0
votes
2 answers
SQL Server 2008 R2 Express and nightly C# database update job needs to "rollback" entire database on failure
I have a C# program that will run nightly. It reads in records from flat files and does many different inserts and updates to a SQL Server database depending on the contents of each record.
Despite using transaction blocks and Try...Catch in stored…
0
votes
1 answer
Sharepoint 2010 central administration empty page displaying after installation of ADDS on Windows Server 2008 R2 SP1
I have installed SharePoint 2010 on Windows Server 2008 R2. To make server as Domain Controller and to install Active Directory i have installed ADDS using dcpromo.exe command. I have installed ADDS successfully but SharePoint 2010 Central…
ramya
- 2,350
- 6
- 31
- 57