sql-server-express Questions
3
Solved
I am looking into using the new SQL Server Express LocalDB (I think it is code named "Denali") for a desktop application.
It is currently running with SQL Compact, but the user is wanting to shar...
Kentledge asked 8/2, 2012 at 12:57
19
Solved
In my Win 7 development machine, and in order to use SQL Express instance instead of the localDB installed by default. I unchecked "Use IIS Express" in my MVC 4 project properties page (Web tab), t...
Westfalen asked 6/12, 2012 at 17:27
4
Solved
Which datatype shall I use to store mobile numbers of 10 digits (Ex.:9932234242). Shall I go for varchar(10) or for the big one- the "bigint".
If the number is of type- '0021-23141231' , then whi...
Turf asked 1/6, 2011 at 7:28
2
Solved
I am deploying sql express with my application. I will like that database engine to accept remote connections. I know how to configure that manual by launching the sql server configuration manager,...
Wooden asked 4/2, 2012 at 3:30
3
Solved
I would like to do a silent install with /qs command to install sql server 2014 express. I did many installations with 2008 express and it did not have this kind of issue.
When I try to install, b...
Tiptoe asked 18/2, 2015 at 21:20
2
I want to add a new trigger to my table. As seen in the picture, New Trigger button is not active. new index, new column, new contraints, new statics is active.
I do not understand what is the p...
Saiff asked 11/11, 2014 at 17:19
5
Solved
I'm wondering if there is any desktop OLAP solution that can use SQL Express (and therefore does not require Analysis Services)
I've been tasked with finding a way to allow our customers to do 'Ad...
Deel asked 16/9, 2010 at 7:28
6
I'm running a small web application with SQL server express (2005) as backend. I can create a backup with a SQL script, however, I'd like to schedule this on a daily basis. As extra option (s...
Trafalgar asked 28/1, 2009 at 13:51
4
Solved
How do I list all the databases for a given sql server 08 instance using sqlcmd?
Shun asked 18/1, 2010 at 17:28
1
Solved
I am having quite a few problems understanding differences between regular SQL Server Express and express Localdb.
Before you go ahead and tag a previous post about this question, I've went throug...
Graeco asked 3/2, 2017 at 15:57
6
Solved
I don't have access to a SQL Server Express installation at the moment, but I know that the installer usually installs SQL Server Express with an instance name. What is the default instance name fo...
Unsaddle asked 27/8, 2010 at 16:21
1
Solved
Im getting this error when i try to connect to SQL from a remote computer
My firewall is disabled, my port is the default 1433, and is enable in the SQL Server Configuration Manager, also my IP on...
Woozy asked 31/12, 2016 at 0:49
2
Solved
I've got a Java Program connected to my SQLServer Express Database. The code I used to connect is:
Connection con = null;
try {
String url = "jdbc:sqlserver://GANESHA\\SQLEXPRESS:1434;databaseNa...
Guarino asked 1/12, 2016 at 14:31
3
Solved
I created a Web API project under VS 2010.
After I switched to VS 2012, I always get a warning:
The Web project 'xxx' requires SQL Server Express, whcih is not
installed on this computer. [...]...
Vermis asked 4/12, 2012 at 9:43
4
Solved
I am using SQL Express 2008 as a backend for a web application, the problem is the web application is used during business hours so sometimes during lunch or break time when there is no users logge...
Pridemore asked 23/2, 2009 at 21:0
3
Solved
In Microsoft SQL Server 2016 Express Management Studio (July 2016) cannot design a new or existing table.
Image 1: click on the tables node. Where is the menu option to add a new table?
Image 2...
Setback asked 5/7, 2016 at 21:59
2
Solved
How can I create a SQL user in a SQL Server Express database that I added to my project?
I need to create a user to use in a connection string that doesn't use Integrated Security.
Neaten asked 17/9, 2010 at 17:9
2
I'm working on a WPF app, and using WiX as an installer.
I'd like to start using SQL Express 2012, but want to resolve installer issues first.
I'm looking for a full-up example of detecting, boot...
Louvenialouver asked 21/9, 2013 at 9:6
0
I have a setup project in Visual Studio 2015 for my .NET Windows Forms project that needs SQL Server 2012 Express as a prerequisite. I have successfully created a bootstrapper (located in C:\Progra...
Gautama asked 29/1, 2016 at 20:23
3
Solved
I have trouble figuring out if the SP1 is already installed. I don't think I could check it from the Management Studio as its a different application. But the SQl server it self has no UI to check ...
Trammel asked 1/7, 2011 at 18:22
1
Solved
I am executing SQL command INSERT like this in my Visual C#.NET using MS VS 2010 Express Edition:
private void btnAdd_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(Pr...
Sandwich asked 24/7, 2015 at 7:49
8
Solved
I am new to SQL Server Management Studio and am wondering: is there is a way to see which queries have been run against a database?
In the Activity monitor, there is a "Recent Expensive Queries" ...
Immateriality asked 15/3, 2010 at 18:52
1
Solved
I have just downloaded SQL Server 2014 Express. In the setup client included, I chose "New SQL Server stand-alone installation or ...". I just left everything as default.
However, at the end of th...
Karyotype asked 12/5, 2015 at 10:47
0
I'm trying to access SQL Server Express installed on Windows Server 2012 on Google Compute Engine VM. I have assigned STATIC IP to the instance and also added an exception to the firewall in Window...
Tyson asked 22/4, 2015 at 9:29
3
Solved
I have a SP in my database. For EF4.1, using the DbContext API.
After importing the function from the data model, references to the stored procedure works fine in my development environment. But w...
Laureen asked 11/12, 2011 at 5:27
© 2022 - 2024 — McMap. All rights reserved.