Microsoft SQL Server Express, a freely downloadable and distributable version of Microsoft's SQL Server relational database management system, comprises a database specifically targeted for embedded and smaller-scale applications.
19
votes
3answers
4k views
Is the SQL Server Express memory and CPU limit per instance?
If I have 8GB of RAM in a server and I run 4 instances of SQL Server Express, will the total memory limit used by SQL Server be 1GB or 4GB?
Would it be advisable to run multiple instances like this ...
10
votes
5answers
2k views
SQL Server 2008 Full Text Index Never Seems to Complete
Our website has a SQL Server 2008 R2 Express Edition database with full-text indexing for our website search. Each time a new record is added or updated in one of the indexed tables, the indexing ...
8
votes
2answers
616 views
Do SQL Server Express Editions support CLR procedures?
Do SQL Server Express Editions (2005, and 2008) have support for installing, enabling and running CLR Stored procedures and functions.
8
votes
1answer
1k views
Why does SQL Server 2012 Express use 9.5GB of RAM on my server?
I am building an application in which I plan to embed SQL Server 2012 Express as the primary datastore. When testing on my development machine (Win7-32 with 3GB RAM), I never observed the ...
5
votes
3answers
5k views
Howto use Windows Authentication with SQL Server 2008 Express on a workgroup network?
I have two computers running SQL Server 2008 Express: c01 and c02, I setup both for remote connection using windows authentication. Worked fine for c02 but not for c01.
This is the error message I'm ...
4
votes
4answers
6k views
MySQL vs SQL Server Express (Compare Free DBMS)
I am searching for a comparison table between MySQL and SQL Server Express.
Comparisons should include...
Usage limit
Tools (management/dev/backup/monitoring/...)
"simultaneous connection"
It's ...
3
votes
2answers
1k views
datatypes in sql server , difference between similar dataypes, numeric, money , decimal ,float
What datatypes could be given to this value --> 45.58
Could these be given:
numeric
money
decimal
float
What's the difference then? Which one would be the best to use?
3
votes
1answer
404 views
SQL Server 2008 R2 Express - Runs at an average of 2-3% CPU, but gets stuck at 100% sometimes
Edit: Skip to the last paragraph for the summary-version!
I am dealing with a SQL Server 2008 R2 Express installation.
I have a fairly complex stored procedure.
Depending upon the inputs, it may ...
3
votes
2answers
4k views
How to install SQL Server Management Console in 2008 Express Version?
I started a dozen attempts to install the SQL Server Management Studio for the 2008 Express Version of SQL Server.
What i use:
Windows Vista 2007 SP 2
What i did:
a) I downloaded the install file ...
3
votes
2answers
508 views
command or query to ping SQL server
I have 2 windows 7 machines on a very high security domain one acting as a server, the other as a client.
Each box has a SQL Server Express 2005 database and application "A", however I'm only using ...
3
votes
1answer
744 views
Install SQL Server 2008 Express on same machine as normal SQL Server 2008 install?
When setting up a server, we installed SQL Server 2008. Now it turns out we don't need it, and we want to use the free Express version instead. Ideally without much interruption to things using the ...
3
votes
1answer
561 views
Removing Instances and SQL Server Express edition and going to Standard/Developer/Enterprise
I would like to move from SQL Server 2008 R2 Express to SQL Server 2008 R2 Developer or Enterprise.
I just noticed that I have the following services running:
SQL Server (MSSQLSERVER)
SQL Server ...
3
votes
1answer
60 views
linking databases for reporting
I am attempting to design a simple reporting feature for some financial market data.
I have a few sets of data, and I am trying to figure out what will be the best way to organize the tables, in ...
3
votes
2answers
369 views
Transaction independent writes inside a trigger
I am using sql express 2008 r2 express edition.
Is it possible to do writes inside a trigger independent from the the transaction of the statement which causes the trigger to fire?
I have triggers ...
2
votes
2answers
102 views
Which edition of SQL Server express
I am looking to learn SQL server - specifically T-SQL programming, writing stored procedures etc and getting familiar.
I had a look at the MS site to download SQL Server express, however it gives me ...
2
votes
2answers
233 views
Remove Database from SQL Management Studio Database List
I'm working with MS SQL Express 2008 and Visual Studio 2010.
If you are attached to a local MDF file how do you remove it from the Databases list without deleting the file? The reason is to purge the ...
2
votes
2answers
873 views
SQL Server 2008 R2 Express size
I have what I believe is SQL Server 2008 R2 Express installed on a production server. When I connect to it with SQL Server Management Studio it shows up as SQL Server 10.50.1600.
If it is in fact SQL ...
2
votes
3answers
2k views
After I replaced master mdf/ldf files, can no longer log in
Today I couldn't start SQL Server process anymore. Reason:
The log scan number (213:18:1) passed to log scan in database 'master' is not valid. This error may indicate data corruption or that the ...
2
votes
2answers
128 views
How to check if I am hitting the Express Edition size limit?
I am confused. AFAIK SQL Server 2005 Express has a limit of 4GB database data size. However I have the following results from sp_spaceused:
How can I check if my DB is hitting the size limit?
Is ...
2
votes
1answer
220 views
Using Service Broker internal to a single SQL Express instance?
I understand that SQL Express cannot send Service Broker messages to other instances without a Standard (or better) instance involved in the chain. But is it possible to use Service Broker to send ...
2
votes
1answer
549 views
SQL Server 2005 Tools makes SQL Server 2008 Express install fail
When I tried installing SQL Server 2008 Express, the install failed due to this line. How can I circumvent this, or fix the issue?
2
votes
2answers
295 views
Table not shown up on Linked Server
I have a machine which have 2 SQLServer instances
WINXP-PRO\SQLSERVER2000 (SQL Server 2000)
WINXP-PRO\SQLEXPRESS (SQL Server 2005 Express Edition).
In \SQLEXPRESS, I have database wavinet2 and ...
1
vote
3answers
816 views
Which SQL Server Express edition is right for me?
I have developed a Java program which works with SQL Server as it's database. I have installed SQL Server 2012 Enterprise edition on my Windows and designed the database via SQL Server Management ...
1
vote
2answers
94 views
How to attach an .mdf file that was not properly detached?
One of our clients had a SQL Server 2000 database, on a system which is no longer running. They have no idea what was in the database. They have given me the .mdf and .ldf files, and want us to ...
1
vote
1answer
82 views
sql server express install administration
is there a way to install sql server express without administration right?
Is there a portable version?
tank you
(I need to test sql server on my computer before using the server but I dont have ...
1
vote
4answers
426 views
Restore backup fails - not enough disk space [duplicate]
I have a backup that's about 6Gb. It's a "light" backup of the original (with the log tables purged), which is about 14Gb.
I try to restore the backup on my SQL Express local server. It fails with a ...
1
vote
1answer
105 views
SQL Server taking a lot of memory
I have SQL Server Express on my VPS(2GB RAM) with a database size of 1.5 GB that I expect will increase to 15 GB. I have noticed that SQL Server is using 1.5 GB RAM even when only small queries has ...
1
vote
1answer
95 views
How to store lots of small text in a SQL Server database?
I have a table with a varchar(max) column that stores text ~4-10KB in size. Data is just being added - never modified, it is a log. My problem is that a table grows too large in size - I would like to ...
1
vote
1answer
290 views
Can I install sql server on Win XP machine with user profile on D drive?
Is it possible to install sql server on a windows xp machine where the user profiles are created on a non system root directory, that is, on D drive rather than C drive?
I am trying to install SQL ...
1
vote
2answers
529 views
Login Failed for User
I have written a code in Visual Studio.NET and used data from SQL Server 2008. But after debugging, it says:
Login failed for user 'sunny'.
When I try to set the user as something else, it keeps ...
1
vote
1answer
89 views
Requirement of SQL Server 2008
The software I am installing requires SQL Server 2008. I have SQL Server 2008 R2 Express Version. I am having problem in the setup and finally I am arriving on the conclusion that my SQL Express can ...
1
vote
0answers
172 views
FOR XML EXPLICIT problems in SQL Server 2005 Express
SQL Server 2005 Express Service Pack 2 w/Advanced Services
Windows 2003 R2
I recently migrated a database from MSDE 2000 to MSSQL 2005 that is used for a tourist website that can be displayed in one ...
1
vote
0answers
192 views
Give permission to SQL Server Express database to Visual Studio MVC project?
(I am very familiar with MySQL but not SQL Server).
On my dev machine is installed:
SQL Server Express 2008 (Windows Authentication)
SQL Server Management Studio
Visual Studio 2010 (with ASP .NET ...
0
votes
1answer
43 views
Security Concerns of SQL Server Express for Web e-Voting web application
I am building a database driven web application. The web application is basically an E-Voting website, where users can register and vote on things that concern their community ... etc.
The database ...
0
votes
1answer
2k views
user “sa” cannot connect to SQL Server Express 2008 R2
Goal: connect to SQL Server Express 2008 database using SQL Server authenticated account "sa", rather than my Windows authenticated account.
When installing SQL Server 2008 Express, I took all ...
0
votes
1answer
499 views
How To insert records in SqlExpress Database tables through sqlscript while installing setup?
I'm creating a database and all of my tables using SQL Server Express through SQL scripts. Now, I want to insert some records in tables like States (all states names), city (all city names).
How ...
0
votes
1answer
2k views
Remove an instance of “SQL Server 2008 R2” after reinstalling “SQL Server 2008”
I have installed "SQL Server 2008 R2" with an instance name "SQLEXPRESS". Then I found out it cannot restore from my older "SQL server 2008" backup files .
So I uninstalled SQL Server 2008 R2 and ...
0
votes
1answer
868 views
sql server express admin tool portable/web
Is there a way to manage sql server express db, remotly, without installing a software.
As a portable apps or a web admin (like phpmyadmin)
0
votes
0answers
141 views
How to move folder of SQL Server LocalDB instances from the default location?
I get multiple errors with LocalDB (startup error, can't create DB from SQL Server Management Studio and also multiple issues when trying to restore a backup) and none of the fixes I found are helping ...
0
votes
0answers
27 views
Max connections sql server express could have? [duplicate]
Possible Duplicate:
Max connections SQL Server Express could have?
I have sql server 2005 express edition installed on one of my client's machine, and lots of other users are also connected ...
0
votes
1answer
81 views
Not able to connect to server [closed]
I am trying to connect to the server in SQL SERVER 2012, but every time it shows this error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. ...
-1
votes
2answers
297 views
SHRINK FILE works with SA but not as a normal user
My problem is that when I try to shrink the Log it works when I am logged in as SA but when I log in as a "normal" USER it does not shrink the log. (SQL Express 2008r2)
I have tried to find a answer ...
-1
votes
1answer
50 views
Back up my ASPNETDB
I want to back up my database but I got this error:
Cannot open database "ASPNETDB" requested by the login. The login failed. Login failed for user 'My-laptop\user'.
I'm using SQL Server Express
...
-4
votes
2answers
289 views
SQL Server equivalent to MySQL UNIQUE index?
In MySQL (5.1) I am able to create a Index on a field that is type UNIQUE. This ensures that the field contains only unique items.
Is there something equivalent to that feature in SQL Server 2008?
...
-6
votes
3answers
362 views
SQL Server Express with 20000 databases won't start
I have a SQL Server Express instance with 20,000 databases (twenty thousand databases).. and the service won't start.
I get error message 1053:
The service did not respond to the start or ...
