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
115
votes
9 answers

How to get current instance name from T-SQL

How can I get the SQL Server server and instance name of the current connection, using a T-SQL script?
Guillermo Gutiérrez
  • 17,273
  • 17
  • 89
  • 116
38
votes
12 answers

Unable to connect to SQL Server instance remotely

I’m trying to access the SQL Server instance on my VPS from SQL Server Management Studio on my local machine. It’s not working (the error I’m getting is: A network-related or instance-specific error occurred while establishing a connection to SQL…
Leah
  • 2,547
  • 5
  • 23
  • 28
28
votes
19 answers

Unable to connect to SQL Express "Error: 26-Error Locating Server/Instance Specified)

I am at an loose end with one particular box that is running SQL Server 2008 R2 Express. Windows Firewall is configured to allow inbound TCP & UDP 1433, 1434. Windows Firewall is configured to allow outbound TCP & UDP on any port. No other software…
0x0000001E
  • 404
  • 2
  • 6
  • 15
18
votes
6 answers

SQL Server 2008 R2 Express permissions -- cannot create database or modify users

Recently just upgraded to SQL Server 2008 R2 Express. When I attempt to create a database after logging in using Windows Authentication with my id myuser I receive this error: An exception occurred while executing a Transact-SQL statement or batch.…
user8128167
  • 6,929
  • 6
  • 66
  • 79
12
votes
1 answer

Reporting Services availability SQL Server Express 2008 R2

I am trying to add Reporting Services to my already installed version of SQL Server Express 2008 R2. I am installing it on a Windows Server 2008 R2 Standard edition box. When ever I run the install program to add extra features Reporting services is…
Ross
  • 325
  • 1
  • 3
  • 18
12
votes
5 answers

Upgrading from SQL Server 2008 R2 Express to SQL Server 2008 R2 Enterprise

When I tried upgrading from SQL Server 2008 R2 Express to SQL Server 2008 R2 Enterprise, it passed all tests and then it failed at step "Select features", saying the following error: There are no features selected for upgrade. And a window error…
JoHa
  • 1,989
  • 10
  • 28
  • 42
11
votes
4 answers

SQL Server: How to concatenate string constant with date?

select packageid,status+' Date : '+UpdatedOn from [Shipment_Package] The below error is appeared when executing the above code in sql server. The type of UpdatedOn is DateTime and status is a varchar. We wanted to concatenate the status, Date and…
user2901979
  • 239
  • 2
  • 6
  • 13
11
votes
1 answer

login failed for user sa at SQL Server 2008 R2

After upgrading to Service Pack 1, sometimes i got failed to login my server at this time, Server Configuration Manager is like below Do I need to change anything? thank you. -- Once I could login, Server Configuration Manager is like below…
soclose
  • 2,773
  • 12
  • 51
  • 60
8
votes
5 answers

How to check if my SQL Server Express database exceeds the 10 GB size limit?

I am developing a web site, it uses SQL Server 2008 R2 Express for its database. And in testing, there is a lot of data and images stored into this database. According to wiki, the SQL Server Express edition has a 10 GB size limit. When I insert…
AechoLiu
  • 17,522
  • 9
  • 100
  • 118
8
votes
3 answers

In SQL Server 2008 R2 error occurred while start debugging, Error HRESULT E_FAIL has been returned from a call to a COM component. (mscorlib)

I am working on SQL Server 2008 R2 Express, when I am using SQL Server debugging feature from client pc, this error occurs: The EXECUTE permission was denied on the object 'sp_enable_sql_debug', database 'mssqlsystemresource', schema 'sys'.…
Haider Ali Wajihi
  • 2,756
  • 7
  • 51
  • 82
7
votes
2 answers

Entity Framework cached query plan performance degrades with different parameters

I have the following problem. Background I'm trying to implement an autocomplete selector with MVC3, EF4 and jquery over a table wit 4.5 million records. This is the table: CREATE TABLE [dbo].[CONSTA] ( [afpCUIT] nvarchar(11) COLLATE…
Jerónimo Vargas
  • 101
  • 2
  • 8
7
votes
1 answer

MS SQL Server's equivalent to PostgreSQL's EXPLAIN

Is there a SQL Server equivalent to PostgreSQL's EXPLAIN command that I can run on SQL Server 2008 R2 Express (ie. without SQL Profiler)?
ajbeaven
  • 9,265
  • 13
  • 76
  • 121
7
votes
2 answers

Re-assigning IDs in a non-IDENTITY type field in SQL Server database

WARNING: This tale of woe contains examples of code smells and poor design decisions, and technical debt. If you are conversant with SOLID principles, practice TDD and unit test your work, DO NOT READ ON. Unless you want a good giggle at someone's…
cometbill
  • 1,619
  • 7
  • 19
  • 41
6
votes
2 answers

Drop all the synonyms using cursor

I wanted to drop all the synonyms of a database (sql server 2008 r2) using cursor. environment-database name- 'mydatabase', schema name- 'dbo'.. Can you please guide me as i did try but the statement of while .. end, is not able to drop the…
chandan kumar
  • 61
  • 1
  • 3
6
votes
7 answers

How to delete all tables from db? Cannot delete from sys.tables

How can I perform this query on whatever way: delete from sys.tables where is_ms_shipped = 0 What happened is, I executed a very large query and I forgot to put USE directive on top of it, now I got a zillion tables on my master db, and don't want…
Shimmy Weitzhandler
  • 101,809
  • 122
  • 424
  • 632
1
2 3
…
14 15