For questions about the SQL Server 2008 R2 Express Edition (build 10.50.xxxx)

learn more… | top users | synonyms

2
votes
3answers
435 views

Releasing Free Space

I am running a rather large database on SQL Server 2008 R2 Express. Recently I hit the 10GB limit, so the system would not allow me to create anymore objects, ect.. I have archived off a very large ...
1
vote
1answer
26 views

SSIS Packages with SQL Server Express 2008 R2

I understand from various questions [1] [2] that SQL Server Express 2008 R2 doesn't support SSIS packages and that there's only primitive support for ad-hoc data imports / exports. I have already got ...
0
votes
1answer
16 views

Sync MySQL with SQL Server 2008

My current project requires a form on my website to populate a table in a MySQL database with data a user submits via the form. This will work great but my complete goal involves getting that data ...
0
votes
0answers
16 views

SQL Server 2008 R2 Express for product fails silently

I am trying to install a product. As part of this product installation it installs SQLServer 2008 RS Express for . I get the prompt to install SQL Server 2008 R2 Express, say yes, and the ...
4
votes
3answers
348 views

Why SQL Server 2008 R2 do full installation for just adding another instance on the same machine

Why SQL Server 2008 R2 does a full installation for just adding another instance (only database engine) on the same machine? I thought it will be quick a installation, but it's not. What is SQL Server ...
3
votes
0answers
137 views

SQL Server not starting at Windows startup but starts manually

My SQL Server instance's (SQL Server 2008 R2 Express) service has Startup Type = Automatic. The past couple of times I've restarted my computer the service has failed to start on its own, but it ...
0
votes
0answers
43 views

LIKE or CHARINDEX to check String Contains a Substring [duplicate]

To check a string contains a sub string or not we can use [LIKE] or [CHARINDEX]. I know that like uses indexing in case we have name%.(while %name% may not use index) .Also charindex does not use ...
-1
votes
2answers
55 views

Copy whole table to another database [closed]

I want to insert a whole table's contents to another database which has the same table name. How can I achieve this? I am using SQL Server Express 2008 R2.
-1
votes
1answer
1k views

SQL import data when both source and destination has data and identity column

I am using Import and export data option to import data from one database to another database. Both database have similar structure of tables. All the tables have primary key which is identity ...
0
votes
2answers
1k views

Reducing database size to restore to SQL Server Express

I have a SQL Server 2008 R2 database, about 15 GB. I want to copy it for a partner, who is using SQL Server 2008 R2 Express. I deleted many tables and rows, and now I am sure that the data is ...
0
votes
1answer
70 views

SQL Server 2008 R2 Express Silent Install - FullText Service Not working

I'm trying to build an installer for an app that installs SQL Server 2008 R2 ADV with fulltext already enabled, but couldn't sort it out. It must support Windows XP, so that's the first OS I'm ...
0
votes
2answers
122 views

Upgraded from SQL Server Express to standard but CPU usage is maximum 50% on dual core [closed]

I have upgraded SQL Server Express 2008 r2 to SQL Standard Edition on amazon EC2 with a Intel Xeon E5-2670 v2 (Ivy Bridge) Processors with 2 vCPU. I have verified the edition by running this: SELECT ...
2
votes
2answers
635 views

Ideal values for wait time in SQL server

This is related to my own post here The SQL server starts everyday at 8:30 AM and stops around 9:30 PM.( So wait times will reset everyday) SQL server will be used by around 60 users ...
0
votes
2answers
206 views

How do I make SQL Server database accessible to PC's on the LAN?

We are using Microsoft SQL Server 2008 R2 Express on server machine with instance name abc12. This instance contains two databases: alarm report but when we connect to the abc12 instance from ...
2
votes
1answer
222 views

Does SQL check each And condition if first condition fails? [duplicate]

For a query of below kind does sql process data for each And condition if first And condition fails? If Emp_ID is not 12 for a row then does it check condition of Emp_Name? So how SQL process this ...
1
vote
0answers
1k views

Management Studio Generate Script Errors

I am trying to generate a script (right click database, tasks, generate scripts, tables) from SQL Server Management Studio 2008 R2 Express and I keep getting an error. I read somewhere that it could ...
0
votes
3answers
227 views

Need a faster method to concatenate rows into column(s)--currently using CTEs

Currently, we are using a view which I created that pulls data from a number of tables. The major factor about this is getting the view to specifications involves a mix of CTEs and string ...
1
vote
1answer
278 views

Autoclose property resets to true after attaching db even if model is set to false

I am using SQL Server Express 2008 R2. The auto close property of a newly created database will be set to value same as model db. In my case I have set autoclose to false for model so that when I ...
3
votes
2answers
145 views

Restore database to a instance in network

We are creating a application which requires sql database as backend to store data. So when user install my application he chooses a sql instance and its details. There we plan to restore the database ...
1
vote
0answers
114 views

SQL server taking too much time in opening properties in SSMS

I am using sql server express 2008 r2 SP2 from about 2 years. Now a days when i try to check properties of database using sql server management studio it takes too much time(25 to 30 seconds) to open ...
4
votes
2answers
482 views

Trace flag and which need to be turned off and Why

In SQL server there are so many trace flags. Why some of them need to be turned off. Some where i saw that trace flag 8017 need to be turned off. So i want to know which trace flag need to be tuned ...
3
votes
1answer
647 views

Restoring database to UNC path on local drive

When I try to restore a database using a restore command with a local UNC path: RESTORE DATABASE [dbname] FROM DISK = N'\\PC91\D\backup.BAK' WITH FILE = 1, MOVE N'test' TO N'\\PC91\D\dbname.MDF', ...
2
votes
1answer
425 views

Distributed - across multiple databases or servers - Transactions

I have some doubts related to transactions in SQL. I perform below steps. Connection 1 open for DB1 database Begin transaction for Connection 1 Run the commands on Connection 1 Connection 2 open for ...
0
votes
3answers
795 views

Indexing for query containing xml column

I have below queries which performs little slow.So i am planning to create index.I created primay xml index and now performance improved little bit(by looking at execution plan) .Queries are shown ...
0
votes
3answers
2k views

SQL Server Database grew too much too fast

I have an issue with one database. The issue is as follows: The database is being running on SQL Server 2000 Standard for the last 6 years in Full Recovery mode. In the beginning of this summer the ...
3
votes
2answers
856 views

Database defragmentation and autogrowth settings

We do have some maintenance plan for our sql server 2008 r2 express. Every month we do defragment of the database if any table has page count more tahn 50 for any table and average fragmentation more ...
3
votes
2answers
3k views

Installing Full Text Search to SQL Server 2008 R2

I installed sql server 2008 R2 Express successfully, then realised I need to get Full Text Search. So I downloaded the "Advanced Services Installation Package", but when I run it there is no option in ...
2
votes
2answers
2k views

SQL server windows authentication through network

I am using sql server 2008 r2.There are about 50 pc in my office connected in network by using LAN.In a sql server 2008 r2 express(installed in windows 8) i have created all users windows account with ...
-3
votes
3answers
2k views

Shrink Database using query [closed]

I have deleted tons of records from my database and now i want to shrink the database. So please give me script which shrinks the database
0
votes
1answer
78 views

Hazards of Upgrading SQL Server Express 2008 to R2

A client of mine reached the 4GB database limit on a SQL Server 2008 Express. As a test I installed the R2 version on another machine and restored a backup of the database. I'd like to upgrade the ...
2
votes
2answers
584 views

Can I open a SQL Server 2008 R2 database in SQL Server 2008 R2 Express?

This question has probably been asked a dozen times but I couldn't find them here or at SO. Can I attach/restore a SQL Server 2008 R2 database to my local SQL 2008 R2 Express instance?
0
votes
0answers
30 views

SQL 2008R2 Trial [duplicate]

I currently have a small db running on SQL Server 2008R2 Express. I'm considering moving to SQL 2008R2 Small Business or Standard to use all the sever is capable of. I have a Dell T610 - 2xQuad Core ...
0
votes
1answer
2k views

How to do an in-place upgrade of SQL Server 2005 Express to SQL Server 2008 R2 Express

I would like to upgrade my SQL Server 2005 Express instance which is installed using this command: SQLEXPR.EXE/qs /action=INSTALL /IACCEPTSQLSERVERLICENSETERMS /FEATURES=SQLEngine ...
-1
votes
1answer
207 views

Query returns no data [closed]

I am running a query to show LastName and Hire_Date and my results display the columns but do not include any data. This is an assignment for an online class and I have been waiting for my instructor ...
2
votes
1answer
13k views

CREATE DATABASE permission denied in database 'master'

I've developed a desktop application using WPF and Entity Framework code-first. In my application the user can create multiple databases at run-time. But Entity Framework can't create database if ...
4
votes
2answers
2k views

Error while taking backup using SSMS

I am using SSMS. I have about 5 logins. For a particular login I have all server roles other than sysadmin. It is a sql login (not windows authentication). In user roles it has all permission for ...
-1
votes
1answer
359 views

Deleted rows but database size is still large [duplicate]

I am using SQL Server 2008 Express which has maximum database size limit of 10 GB. Every month I hit the limit and the application can't store more data. To overcome this problem we run a job every ...
4
votes
1answer
2k views

Moving MSDB database

When I am trying to move msdb database from it's default location (C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA) to another drive(E:). After moving the database I am getting ...
6
votes
1answer
842 views

Newly discovered SQL Server Express has all databases inaccessible/offline

We have several remotes sites at my company and today one of the employees came to me and said their SQL reporting tool stopped working. Up until this point I did not even know this server or ...
2
votes
1answer
1k views

Selecting with varbinary(max) criteria (in the where clause)

Basic info Database: SQL Server Express 2008 R2 Client: SQL Server Management Studio Backround (skip if not interested): A project I'm maintaining uses an ORM, which apparently stored my enum ...
1
vote
2answers
197 views

SQL Server Express in a shared hosting environment

I have created an ASP.NET project in Visual Studio. The database is a SQL Server Express database TestDB.mdf. I uploaded this with .ldf file to the standard App_Data directory but the connection ...
3
votes
1answer
367 views

SQL Server 2008 R2 Express password overwrite

I'm using a program that requires SA log-in to SQL Server. We had issues where some 3rd party support numpty changed the SA password and never informed us, so the program couldn't log-in. I've ...
4
votes
6answers
32k views

Download SQL Server profiler for SQL Server Management Studio

How can I profile a SQL Server 2008 database to see code that's being executed on a particular database? I remember using the SQL Server profiler, but I don't see it in SQL Server Management Studio ...
2
votes
2answers
2k views

Network-related or instance-specific error

I have a problem when I run my web project. I get this error : A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was ...
1
vote
1answer
133 views

Update Table with Network Client Connection Status, I need help with DB design. SQL 2008 Ex R2

I have C# client application that updates a Server Database, SQL 2008 Express R2. The client application send a ping to a group of devices once every 30 seconds and displays their status then updates ...