Use this tag for questions specific to scaled down, free edition of SQL Server 2008 R2.
Questions tagged [sql-server-2008r2-express]
223 questions
4
votes
2 answers
T-SQL: For Loop, Temporary (in-memory) Tables and Stored Procedures
I have a database structure like so:
SELECT * FROM Culture;
------------------------
Id ShortName FullName Supported
22 en-US English (United States) 1
23 fr-FR French (France) 1
24 hi-IN Hindi (India) …
Water Cooler v2
- 32,724
- 54
- 166
- 336
4
votes
1 answer
What collation should I use to store £ (British Pound sign) in varchar?
I'm using SQL Server Express 2008 R2.
I'm importing from a csv file and some of the columns have a "£" sign as part of some free text. When this file is loaded into a database, the "£" sign is displayed as "ú". I think this is definitely to do with…
user1509107
4
votes
2 answers
Setting up Publication on SQL Server 2008 R2 Express
I cannot find the Local Publication folder in the node Replication in my SQL Server Management Studio.
I recently installed SQL Server 2008 R2 Express edition.
I also created two instances for testing purposes.
Solution for SQL Server 2005 is…
RAJ
- 41
- 1
- 4
4
votes
2 answers
Fluent nhibernate SQL Server 2008 R2 Express very long string saving issue
I have an Article object which has various properties:
public class Article {
public virtual string Title { get; set; }
public virtual string Body { get; set; }
}
I am using the fluent configuration to load the…
Jon
- 15,110
- 28
- 92
- 132
3
votes
2 answers
Unable to upgrade to Microsoft SQL Server2008 R2 RTM - Express with Advanced Services
I am trying to upgrade my current Express edition to Express with Advanced Services for supporting full-text search.
The current system setup is:
OS version: Windows server 2008 R2 web server 64 bit
SQL Server 2008 R2 Express, SP1,…
user1289811
- 81
- 1
- 4
3
votes
2 answers
Cannot connect to SQL Server Express from SSMS but can from VS 2010
I have installed SQL Server 2008 R2 Express. I have also installed SQL Server Management Studio. I cannot connect to my localhost\sqlexpress server using SSMS. However, I can connect via Visual Studio 2010. I can also connect to my SQL Azure…
Brian
- 91
- 1
- 5
3
votes
1 answer
Setting Up Windows Azure End To End Development Environment
I downloaded AppFabric VS Tools and Tried To Install but it ends up with fatal Error.I have read n followed all the system requirements of exe, except the one with SQL Express point.I tried installing SQL Express 2008 r2 with default instance, but…
Siddharood
- 908
- 1
- 12
- 24
3
votes
3 answers
order by in select statement sql server
I try to fetch date from table in descending order but when i write order by clause in query this shows date in ascending order .. i can not post whole query i post specific line e.g. order by .. when i tried this is what query shows
date
…
Bakhtawar
- 75
- 1
- 10
3
votes
1 answer
how to install sql server express 2008 R2 silently by installshield 2010
I want to Install sql server express 2008 R2 silently by installshield 2010 but it has problem.
I think the problem is i don't know where place setup file and configuration.ini
would you please say me where i call sql setup file and .ini file?
i add…
user2330791
- 41
- 3
3
votes
1 answer
SQL Server Query time out depending on Where Clause
I have a query that uses 3 functions and a few different views beneath it, which are too complex to post here. The odd thing I am experiencing is when running the top level query, having more than 1 search key is causing the query to take around an…
Molloch
- 2,261
- 4
- 29
- 48
3
votes
1 answer
How to join a database user to the db_owner role using a T-SQL script?
I use SQL SERVER 2008 R2 Express.
I'm on a NEW project with a database named myDatabase with the db owner username myUsernamae.
I would like to use ALTER ROLE instead of sp_addrolemember due to this message from Microsoft regarding sp_addrolemember…
elarrow
- 687
- 3
- 11
- 19
2
votes
1 answer
SQL Server 2008 OLE DB CONNECTION FAILS FROM OUTSIDE
I have a working SQL Server 2008 R2 Express installed on a Windows 2008 server on a cloud machine. All type of connections (ado.net, nhibernate etc.) from several client applications works fine except the OLEDB one. SQL Native Client also works…
mece
- 21
- 1
- 2
2
votes
3 answers
Having Foreign Key relations between two different columns in two different databases
I have two databases A and B. A has table tableA with columnA similarily B has tableB with coulmnB. Can I have a Primary , Foreign Key relationship between these two columns.
Both databases will be in the same Sql Server 2008 R2 instance.
I am using…
bleu
- 87
- 1
- 2
- 11
2
votes
1 answer
Accessing SQL Server 2008 R2 Express with SQL Server Management Studio
OK maybe I'm being stupid somehow, and my googleing has not found a clear step by step user case for beginners.
I have just installed into my Win 7 Pro 64-bit SP1 machine SQL Server 2008 R2 Express Database with Advanced Services [downloaded from…
Elijha
- 181
- 3
- 13
2
votes
2 answers
SQL based encryption performance
I am doing some research for a future project and it requires some data to be encrypted.
In my research today, I have noticed that there are many different encryption algorithms (including AES, Triple-DES, X-DES etc) and I wish to use one of the…
Stuart Blackler
- 3,732
- 5
- 35
- 60