sql-server-express Questions
7
Solved
An instance of SQL Server 2012 Express became corrupted somehow.
I suspect it was related in some way to my use of Entity Framework, but have no proof yet.
When trying to repair the instance, the ...
Coenzyme asked 1/2, 2015 at 19:6
4
Solved
I've got a SQL Server Express 2008 install on my web server, which by default does not allow remote connections (probably a good thing.) I opted not to install SQL Server Management Studio Express ...
Eccles asked 29/12, 2009 at 17:22
2
Solved
I use a MS SQL express db. I can connect and fetch data. But inserting data does not work:
cursor.execute("insert into [mydb].[dbo].[ConvertToolLog] ([Message]) values('test')")
I get no error b...
Thusly asked 25/11, 2013 at 17:36
3
Solved
I've created a new project in VS2008, and added a .MDF file to the project. This is the first time I've tried to use the MDF files and .SQLEXPRESS databases (I've always used extenal Oracle servers...
Blob asked 30/5, 2009 at 2:23
13
I would like to make a copy of a database I have but keep it on the same server as a test database. However, everything I have found is to use the copy database wizard (I am using MS SQL Server Exp...
Volplane asked 24/11, 2010 at 17:2
8
Solved
I was just given a laptop to perform some development from a client and I am currently in the process of setting it up. Visual Studio 2010 is installed as well as SQL Server Management Studio 2008 ...
Chaotic asked 11/7, 2012 at 3:53
3
Solved
I'm putting together a simple test database to learn MVC with. I want to add a DateTime field to show when the record was CREATED.
ID = int
Name = Char
DateCreated = (dateTime, DateTime2..?)
I hav...
Mehitable asked 16/3, 2010 at 16:2
2
Solved
I have just restored a database backup to my local SQL Server express instance.
In management studio under the server instance node I went to: Security -> Logins -> New login...
Then I filled in...
Redmund asked 19/8, 2011 at 9:29
5
I'm trying to set up a SQL Server 2012 LocalDB (RTM, x64) shared instance on my Windows 7 x64 machine and I can't seem to connect to the shared instance. I'm using an Administrator command prompt f...
Icebound asked 18/4, 2012 at 17:28
4
I tried to start an instance of SQLLOCALDB 2017 on win7 (x64) but this message box Appears :
"The procedure entry point BCryptKeyDerivation could not be located in
the dynamic link library bcr...
Thyrsus asked 22/11, 2017 at 18:35
2
Solved
I am using Visual Studio 2010 premium, and I created a database by using Visual Studio database tool. I set a field as primary key and I want to make it auto incremented.
But when I look at the p...
Vesta asked 8/5, 2013 at 6:45
11
How is it possible to run a stored procedure at a particular time every day in SQL Server Express Edition?
Notes:
This is needed to truncate an audit table
An alternative would be to modify the ...
Crore asked 4/11, 2009 at 17:0
12
Solved
After I change the option as UserInstance="False", then the error starts to happen.
Because I want to use full-text search, the option change is required. BUT, it stopped to work. Is there any way...
Zeb asked 23/10, 2009 at 23:57
11
I'm trying to install SQL Server 2008 R2 Express from this site:
http://www.microsoft.com/express/database/
I have a 64-bit, Windows 7 machine.
I have tried both the 32-bit and 64-bit versions b...
Biform asked 13/8, 2010 at 12:23
2
Solved
Software:
SQL Server Express 2016
Visual Studio 2017
We've been trying without success to get a named instance of SQL Server Express 2016 installed as part of VS Installer Setup Project.
We'v...
Desireedesiri asked 28/8, 2018 at 19:34
3
I have been following this tutorial Getting Started with Entity Framework 6 Code First using MVC 5.
When I got to the section where I need to run the program and click on Student so that the progr...
Chlamys asked 21/3, 2014 at 20:17
1
Solved
I am trying to use boostrapper (Wix 3.11) to set up an installation, with SQL Server 2014 Express as a prerequisite.
It works well when I install setup.exe or SQLEXPR_x64_ENU.exe with command lin...
Dahlia asked 20/7, 2018 at 19:33
6
Solved
So..I managed to almost finish all my problems.But now i deal with another one.
I used this connectionstring :
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;Database=Database1....
Psycho asked 11/5, 2016 at 12:43
8
Solved
I'm having an issue at the moment which I am trying to fix. I just tried to access a database and insert some values with the help of C#
The things I tried (worked)
String query = "INSERT INTO db...
Meteorology asked 13/11, 2013 at 14:37
4
Solved
On my machine MSSQLLocalDB got corrupted:
PS C:\WINDOWS\system32> sqllocaldb i
MSSQLLocalDB
Projects
ProjectsV12
v11.0
PS C:\WINDOWS\system32> sqllocaldb i mssqllocaldb
The required L...
Lowminded asked 9/11, 2015 at 5:26
6
Solved
I need a safe (i.e consistent, robust) way of detecting whether or not the sql server I'm accessing is Sql Express. I think I'd prefer to be able to do this from TSQL, since I already have a connec...
Harkins asked 16/7, 2009 at 15:23
5
Solved
I am trying to construct a connection string to a 2008 SQL Express database file in VS 2012. I am getting an error dialog:
This database file is not compatible with the current instance of SQL
...
Shaffert asked 14/3, 2013 at 18:35
2
I want to install SQL Server Express (preferably 2008 or 2014) silently using Advanced Installer. I followed the instructions in two document created by advanced installer online:
How to Install S...
Amphitropous asked 29/10, 2017 at 15:0
2
Solved
After a program was installed by an admin user, different users with no admin rights experience the following problem with their logins to the same computer.
At the installation of the program by...
Callan asked 8/11, 2017 at 22:27
5
Solved
I'm installing some software and I need to tell it to use the default instance of SQL Server, however the Installshield GUI insists that I enter in information for a named instance.
The target SQL...
Murphey asked 13/3, 2011 at 2:39
© 2022 - 2024 — McMap. All rights reserved.