The sql-server-2008r2-express tag has no wiki summary.
2
votes
2answers
105 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
28 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
52 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
73 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 ...
0
votes
1answer
93 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 ...
3
votes
2answers
93 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
74 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 ...
0
votes
0answers
38 views
sql server 2008 error in working
I have Windows 7 professional and SQL Server 2008 Standard
In management studio when press connect it shows this error
( A network-related or instance-specific error occurred while
...
4
votes
1answer
123 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 ...
4
votes
1answer
191 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
103 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
110 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
197 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 ...
2
votes
3answers
4k 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 ...
1
vote
1answer
115 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 ...
