The sql-server-2008r2-express tag has no wiki summary.
3
votes
2answers
131 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
43 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
86 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
59 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
38 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
127 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
156 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
79 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
533 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
107 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
87 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
40 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
169 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
247 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
150 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
121 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
204 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
6k 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
117 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 ...
