Questions tagged [sql-server-express]

For questions about Microsoft SQL Server Express (except Express LocalDB).

Filter by
Sorted by
Tagged with
2
votes
1answer
29k 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 ...
6
votes
1answer
2k 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 (...
32
votes
3answers
39k 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 ...
3
votes
1answer
116 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 ...
6
votes
3answers
35k views

MySQL vs SQL Server Express (Compare Free DBMS) [closed]

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 for ...
0
votes
1answer
4k 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 ...
2
votes
2answers
2k 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 ...
4
votes
2answers
5k 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 ...
4
votes
1answer
2k 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 ...
12
votes
2answers
5k 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.
3
votes
2answers
277 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
3answers
5k 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 ...
-4
votes
2answers
1k 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? ...
5
votes
2answers
1k 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 ...
4
votes
1answer
3k 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 ...
-1
votes
1answer
9k 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 ...
3
votes
2answers
8k 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?
0
votes
2answers
5k 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 2 3 4