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
3 answers
Doesn't work th SqlCommand with multiple queries
With one SELECT query, the code seems to add to the listbox correctly, but when I add another query, the listbox doesn't show anything anymore, and it seems that that rdr[3] does not exists (Contact has 3 columns and Numar_contact has one column…
user3806279
- 23
- 5
0
votes
2 answers
Should I remove NOT NULL for columns changed by AFTER INSERT trigger?
(SQL Server 2014 Express)
Hi,
I reference this article: http://msdn.microsoft.com/en-gb/magazine/cc164047.aspx
I have this AFTER INSERT, UPDATE, DELETE trigger to set or update DateCreated, DateModified, and WhoUpdatedID columns in several tables…
Scott
- 169
- 1
- 3
- 14
0
votes
5 answers
Problem with importing an mdf created with SQL Server Express 2008 into SQL Server 2005
The question is probably extremely easy to resolve, but I need to resolve it because I need to carry on with my project. I am using SQL Server Express 2008 at home, and I've been working on an ASP.NET MVC app that stores my DB in an mdf file in the…
xantrus
- 1,975
- 1
- 22
- 44
0
votes
1 answer
Can't modify data on SQL Server table (Cannot drop database error)
I'm using SQL Server and Visual Studio 2013 for a specific project. I have a database (.mdf) file, which has a lot of data.
The problem is, when I modify this data, that being both via Visual Studio "Show Table Data" option or via the SQL console on…
user3763857
- 1
- 2
0
votes
2 answers
Don't know how to read a sp from vb.net 2013
I have a stored procedure which returns variable columns as a table. I need to put this output in a DataGridView. Can anyone help me?
I'm using SQL Server 2012 Express and Visual basic 2013 on windows 8.1
ALTER PROCEDURE [dbo].[sp_Pivot]
@Dias…
Capanga
- 77
- 1
- 8
0
votes
2 answers
Cant connect application with connection string .\\Sqlexpress
i am a beginner and using mircosoft Sql Server 2005. i connect with Server name : USER-PC on Windows Authentication.
now this is creating a serious problem in my Windows Application. i want to use .\SQLEXPRESS in the connection string in my…
Divyanshu
- 5
- 1
- 5
0
votes
1 answer
SQL view from another Database
I want to create a view in a Database residing in SQL Server Express 2008.
The view will be take its data from table residing on another server SQL Server 2008 on another machine in the same LAN.
My Question is if a must create a Linked Server for…
apomene
- 14,282
- 9
- 46
- 72
0
votes
1 answer
LocalDb Unspecified Initial Catalog?
I've recently been placed on a project using EF 6.0 and Code First principles. The ApplicationDbContext is loaded from this connection string:
name="DefaultConnection" connectionString="Data Source=(LocalDb)\v11.0;Integrated Security=True"…
user3572106
- 1
- 1
- 2
0
votes
1 answer
How to configure SQL Server 2005
I have just downloaded SQL Server 2005 express edition from here:
To be used as a database for a vb.net program.
But I'm confused in using sql server. I do not know where to start from here:
http://screencast.com/t/ZTdiMDU5
Do I have to create the…
user225269
- 10,743
- 69
- 174
- 251
0
votes
1 answer
aspnet_regsql not working at all
I would like to create the ASP.NET User database template on a database of my own, because I'd like to fully untegrate the user system with the rest of my DB. As I've read, i needed to use the aspnet_regsql tool. I put all the options (because my…
xantrus
- 1,975
- 1
- 22
- 44
0
votes
3 answers
sql exception when transferring project from usb to c:\
I'm working on a C# windows program with Visual Studio 2008. Usually, I work from school, directly on my usb drive. But when I copy the folder on my hard drive at home, an sql exception is unhandled whenever I try to write to the database. it is…
jello
- 745
- 5
- 12
- 21
0
votes
1 answer
SSRS This feature is not available?
Ive installed SSRS on my local machine, we want to test it before we deploy it for the whole system. It is running off SQL 2012 Express edition (this maybe why- however if it is then ssrs is virtually unusable on express?).
I keep getting error…
user3519515
0
votes
1 answer
How can i know if someone in the network connected to the SQL Express 2008 on my system
I have installed a SQL Express 2008 Server on my Desktop for some local work. This has mixed authentication. I have enabled TCP/IP connection so that one colleague can connect to this server. However, this exposes the server to everyone in the…
Chakra
- 2,525
- 8
- 43
- 82
0
votes
5 answers
How can I convert Dataset column value to an integer
public DataSet ds = new DataSet();
public SqlDataAdapter adapter = new SqlDataAdapter();
public int AuthenticatedUserAge(String User_name)
{
string sql = "SELECT UserName, Age FROM tblDataProg WHERE (UserName ='" + User_name + "')";
ds =…
user3649869
- 1
- 1
- 2
0
votes
2 answers
Connecting to SQL Server Express from C#
I'm trying to connect to a SQL Server database from C#, but keep get thrown by an exception:
System.Data.SqlClient.SqlExceptionwhen trying toopen()` the connection.
I have created a simple web form, with two text boxes: usernameTextBox, and…
so.very.tired
- 2,958
- 4
- 41
- 69