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
1 answer
I cannot connect to my SQL Server 2012 Express over ip 127.0.0.1, local and localhost
I cannot connect to my SQL Server 2012 Express instance using addresses 127.0.0.1, local and localhost.
I added ports and test the databases on ODBC. I can also login over SQL Server management with all users but when I am trying to login over IP I…
Ken Lin LIEN
- 1
- 1
0
votes
2 answers
Trying to do a count query with subqueries and jointures
I have tried different ways of achieving this task with subqueries
But finaly tried it with jointures. with little success
The main task is finding how many (so count them) COMMANDES (NCOM) that specify one or more PRODUITS in ACIER there are
…
KastelA Kastel
- 83
- 1
- 1
- 3
0
votes
1 answer
Visual Studio C# Change entity variables names for dbml file
I know how to create Foreign Key in sql express and how to use dbml file and it's entities, But I like to change the name of a variable in one of my entities.
Let me explain this:
Lets think I have a Table named "Person" and this table has a Foreign…
amir.sh
- 193
- 6
- 18
0
votes
1 answer
Disable the SQL powershell prompt
I have just installed SQL Server 2014 Express Exition, and are now faced with a prompt whenever turning to a powershell.
The prompt looks like this: SQLSERVER:\>
How can I disable this behavior and get my good old powershell back?
thilemann
- 397
- 4
- 16
0
votes
2 answers
SQL how to show list of people with no orders
I'm trying to solve this SQL query (it's in French)
I've got 4 different tables : CLIENT , COMMANDE (order), DETAIL (of the orders) and PRODUIT (product)
I have to give the number(NCLI) and the name(NOM) of the clients of 'Namur'(that is in the…
KastelA Kastel
- 83
- 1
- 1
- 3
0
votes
2 answers
SQL Server Express 2008
I am going to install Visual Studio 2010 Premium. I have SQL Server 2008 Express already installed on my laptop along with Visual Studio 2008 Professional.
Do I have to uninstall SQL Server 2008 Express or will it be configured to operate in the…
robblot
- 395
- 2
- 5
- 15
0
votes
1 answer
How to increase cpu quota for SQL Server Express in classic ASP script
I have a classic ASP application with SQL Server Express that includes a couple of maintenance scripts that take potentially a few minutes to run. On the old Windows Server 2003 and 2008 installations, SQL Server Express would be capped at 50% of…
user1207313
- 79
- 7
0
votes
1 answer
How to install sql server express on client machine...?
I'm developing winform application(.net) which using database at very minor level. Some very basic structure of tables.
I've created windows installer project(.msi,.exe). I know how to put .net framework with this installer, so when user try to…
Manish Jain
- 842
- 1
- 11
- 29
0
votes
1 answer
Refresh tables in Visual Studio?
How can I refresh the tab in Visual Studio for a database table? Currently I re-open the table but I would think there is a way to refresh the table. I am referring to tables opened via the Server Explorer/SQL Express.
The clear results does not…
Curtis White
- 6,213
- 12
- 59
- 83
0
votes
0 answers
The parameterized query '(@username nvarchar(4000)) UPDATE Seller Set Status='deactivated' expects the parameter '@username', which was not supplied
Hi im having a problem with the code,i'm not being able to figure out the problem..if anyone could help..thank you
Protected Sub btnActive_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnActive.Click
Dim connectionString…
0
votes
3 answers
How to schedule data insertion from dbf to SQL Server on 64-bit Windows Server 2012
I am working on a Windows Server 2012 64-bit. I want to be able to import data from a .dbf file into a SQL Server table. I used the import wizard and it worked correctly. However, I have SQL Server Express and can't schedule this insertion.
Is…
fcdimitr
- 528
- 3
- 16
0
votes
2 answers
Search within ColA duplicates against specific unique vals in ColB to exclude all of ColA
I apologize in advance I feel like I'm missing something really stupid simple. (and let's ignore database structure as I'm kind of locked into that).
I have, let's use customer orders - an order number can be shipped to more than one place. For…
analias
- 51
- 5
0
votes
2 answers
SQL - Cannot change column type
I am trying to change a column type:
This is the code I have made so far, but it doesn't work at all.
ALTER TABLE VILLE
ALTER COLUMN NVIL char(12); <-- Here I am trying to change from char(4) to char(12),
ALTER TABLE CLIENT I do…
user3742475
- 7
- 1
- 2
- 6
0
votes
2 answers
"Input String was not in a correct format" - Why?
I get this error:
Input string was not in a correct format.
from my code shown below. I want to delete a row in my database just with click on a button.
SqlConnection conn = new SqlConnection(@"DataSource=.\SQLEXPRESS;
…
Ehsan
- 3
- 1
0
votes
1 answer
Replication: SQL Server 2008 Publisher with SQL Server Express 2005 Subscriber
Here is the setup:
SQL Server 2008 Enterprise Server with a Merge Publication.
SQL Server 2005 Express with pull subscription.
There is no web or ftp setup. This is direct merge replication.
Using the RMO objects from C#, I get a "class cannot be…
Jeremy
- 145
- 1
- 8