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

Permissions on XML execution missing?

I have taken this function from https://stackoverflow.com/a/9714484/1678652 SET @XML = N'' + REPLACE(@s, @sep, '') + '' INSERT INTO @result(Id) SELECT DISTINCT r.value('.','int') as Item FROM @xml.nodes('//root//r') AS…
Leif Neland
  • 1,416
  • 1
  • 17
  • 40
0
votes
1 answer

is the same recursive CTE and trigger instead of delete?

I am using SQL Server 2008 Express R2 and I have a table that is self referencing, because I have a hierarchy struct. I need to delete a root node, but I get an error because of foreign key. I have read that I can use two option, use a recursive CTE…
Álvaro García
  • 18,114
  • 30
  • 102
  • 193
0
votes
2 answers

SignalR 1.01 hubs in ASP.Net: storing group information across pages

I am currently building a SignalR application (using ASP.Net MVC4, on IIS7 with SQL Server 2008 R2 Express), where users enter a lobby and are placed into groups and then interact on different pages. Html5 LocalStorage is a requirement for any…
jank
  • 665
  • 6
  • 14
0
votes
1 answer

Remove Addin from SQL Server 2008 R2 Management Studio

Recently I have installed an addin (Fulltext Manager) into my SQL Server 2008 R2 Management Studio. But it's not compatible with this version. This is the message I am getting Its not removing after clicking on yes button.Its always showing this…
Rakesh
  • 2,730
  • 10
  • 39
  • 65
0
votes
1 answer

MSAccess moved to sql server as Back end

We are moving our back end from MSAccess to Sql server 2008 R2 Express. We have changed our MSAccess queries to Store Procedures. The data is about 250,000+ records . We have two tables in the backend of MSAccess that can become very…
faheem khan
  • 471
  • 1
  • 7
  • 33
0
votes
1 answer

How to restore a .bak file on a remote Win7 system, which I have limited permissions at?

We have an old project which is planned for an upgrade, and now as a seed, we took the backup of the whole database which is in a remote location. I saved it in my remote desktop, which I have limited permissions. I tried to use SQL Server…
dileep
  • 11
  • 2
0
votes
2 answers

vb.net update query with vb.net

in an sql updatate query runnging in a vb.net application i am updating the data of some columns to the sql datatable, here is the code dim cnn = New SqlConnection(connetionString) Dim q As New SqlCommand("UPDATE products SET…
user1570048
  • 880
  • 6
  • 35
  • 69
0
votes
2 answers

How to secure SQL Server Management Studtio

I have SQL Server 2008 R2 Express installed on client systems. We got information that some people just open the Management Studio and change the data. How can we stop from this happening and can we make a log of what is being changed by them?
faheem khan
  • 471
  • 1
  • 7
  • 33
0
votes
1 answer

Can't access database from SQL Server Management Studio Express and causes the machine to freeze?

Sometimes I cannot access the databases in SQL Server Express (installed in same machine) via the MSSMSE. I have to restart the machine to get this corrected. Other thing is very slow responsiveness of SSMSE! Management Studio itself is very slow…
CRoshanLG
  • 498
  • 1
  • 8
  • 20
0
votes
1 answer

After installing SQL Server Express 2008 R2 using SQLEXPRWT_x86_ENU.exe, SQL Server can't create database

I have an NSIS install script which successfully installs an instance of SQL Server Express 2008 R2 on Windows 7, but when I later try to create a database from the install script I get an error saying access denied. My detailed steps follow. I…
Mike Heffelfinger
  • 413
  • 1
  • 8
  • 18
0
votes
0 answers

Local asp.net installation - SQL Server Express, IISExpress

I have an ASP.NET project that I run on localhost with a SQL Server 2008 R2 Express. I want to make a setup with all that i need to install in client's PC, and automate it in a way that I do not need to configure the SQL Server Express (like…
Proposition Joe
  • 107
  • 2
  • 13
0
votes
1 answer

Issue with SQL Server Management Studio

I have installed SQL Server 2008 R2 onto my machine. Looks my I have problem with my SSMS (SQL Server Management Studio). For every login it is showing the credential information differently. Please observe the tooltip on below screen shot of…
Software Enginner
  • 675
  • 2
  • 14
  • 43
0
votes
1 answer

select @variable=case when...end from... order by len(@variable)

What I'm trying to do is concatenate two fields of a table, sort them by the descending length of the concatenated fields and get the top result... Here's the SQL I'm using to try and achieve this... declare @color nvarchar(255); declare…
Drew Chapin
  • 7,779
  • 5
  • 58
  • 84
0
votes
1 answer

Is it possible to create backup jobs on SQL Server 2008 R2 Express with SMO

In our software because the users are using SQL Server 2008 R2 Express, I would want to create backup jobs for them programmatically using the SMO API. Is it possible? If possible point me to any articles written on this light of this topic.
Soham Dasgupta
  • 5,061
  • 24
  • 79
  • 125
0
votes
0 answers

Cannot setup remote connection to SQL Server 2008 R2

I've installed the server on a windows 7 64bits PC, the download from MS was for SQL Server 2008 R2 Express x64 with management tools. Firewall is open port 1433 for SQL Server and Management Studio (just in case). All SQL Server services have been…
user1555945
  • 21
  • 3
1 2 3
…
14
15