Microsoft SQL Server Express is a freely downloadable and distributable version of Microsoft's SQL Server relational database management system. It is targeted for embedded and smaller-scale applications, having a number of technical restrictions.
Questions tagged [sql-server-express]
1718 questions
0
votes
0 answers
SQL Server Express number of small databases
Having possibly several thousands customers I want to create one DB for each client where I will hold a small sized number of tables and records (from 5000 to less than 100,000 records per DB).
Is there a limitation with SQL Server 2012 or 2014…
user3553401
- 109
- 2
- 15
0
votes
2 answers
I would like to mark all updated rows with the date that they have been updated
After updating rows in a table I would like to mark all the updated rows with the date that they have been updated.
What code do i need to write to do this
p.s. I should have stated that i am updating using a view because it helps me see clearly…
frustrationmultiplied
- 439
- 8
- 18
0
votes
1 answer
I would like to set the Default value for a column to Current Time + 6hrs
I have a column in an Sql server express table called DepTime which has a Time data type.
I would like to set the Default value for this column to Current Time + 6hrs.
How can I do this.
Thank you
frustrationmultiplied
- 439
- 8
- 18
0
votes
1 answer
Nesting Tables in SQL Server Express
I am creating a purchase order system where someone can store details of their purchase. So I created a database, with tables for supplier information from which we will buy stuff and another table where we store what we are buying.
In the…
Vinny
- 48
- 8
0
votes
1 answer
Does VS2010 does not install SQL Server during installation
Just confirming -does VS2010 does not install SQL Server during installation? I'm assuming no.
This being the case I therefore need to download a copy of SQL Express 2005 or something to develop against on my windows XP home PC? Is this correct? …
Greg
- 34,042
- 79
- 253
- 454
0
votes
0 answers
Can't see SQL Server table data in Server Explorer Window
In my asp.net MVC application I created the database and then went to server explorer and I select one table and select open table data. I received the following error message.
Here is my connection string
chuckd
- 13,460
- 29
- 152
- 331
0
votes
2 answers
SQL Server Express 2008 Stored Procedure execution time spikes periodically
I have a big stored procedure on a SQL Server 2008 Express SP2 database that gets run about every 200 ms. Normal execution time is about 50ms. What I am seeing is large inconsistencies in this run time. It will execute for while, say 50-100 times…
user156241
- 51
- 4
0
votes
1 answer
skipping null values in MS SQL
Background:
creating a database that has multiple identical inputs with unique identifiers, for example: input_option_1, data_type_1, input_option_2, data_type_2, etc...
input_option_1, data_type_1 and input_option_2 and data_type_2 are separate…
0
votes
0 answers
SQL Server 2014 - Windows Installer error message: An error occurred during the installation of assembly 'Microsoft.VC80.ATL,version="8.0.50727.6229"
I am trying to install SQL server 2014 Express on a windows 7 PC for 2 days now. I re-installed then installed SQL Server 2014 several times but I keep getting the same window installer error message
I keep getting the following errors here's the…
Weeroo
- 1
- 1
- 2
0
votes
1 answer
How to Create A New SQL User For Aspnetdb Membership Db?
I have created a membership database using the asp_regsql.exe tool instead of the default wizard on an existing database.
When I create new user account with membership createuser method for aspnetdb membership database, I get below error:
A…
Peiman Noroozi
- 76
- 1
- 8
0
votes
1 answer
Nsis Error while installing Sql Express
Using following function to Sql Express using Nsis But getting error while running this function named InstallSQL the function is shown below
Function InstallSQL
File /oname=$TEMP\SQLEXPR32.exe Prerequisites\SQLEXPR32.exe
ExecWait…
Abdul Adhar
- 65
- 10
0
votes
1 answer
Similar Records Remove One
Well, i posted a similar question earlier, and got a solution for it, but i am doing something similar and little different, and i need a little help.
There is a Seeker table, employer table, category table ,interest table..
FK_is_id = Seeker…
Rifshan
- 153
- 1
- 4
- 13
0
votes
1 answer
How do you upgrade a SQL Express Database to SQL Server Workgroup or Standard?
I have a website that was originally developed using a SQL Express database in the App_Data folder. Now I need to take upgrade it, without loosing any data, to SQL Server 2005 Workgroup or Standard.
Is there a guide on how to properly upgrade by…
Brian Boatright
- 36,294
- 34
- 81
- 102
0
votes
0 answers
SQL Server CE instead of SQL Server Express
When creating a new ASP.NET MVC application in VS2010 you get Account (Simple Membership Database) database in SQL Server Express format.
Since I have problems with database migration / configuration on my remote host I decided to switch to SQL…
Jacek Wojcik
- 1,223
- 2
- 19
- 33
0
votes
4 answers
Installing sql server express: VS2008 sp1 problem
I am trying to install SQL server express 2008 on my machine. I get an error message that says that older version of VS 2008 in installed on the computer. Upgrade to VS2008 SP1 before installing Sql server 2008.
I tried to install sp1 but I get an…
Anon
- 1,431
- 3
- 16
- 18