Stack Overflow
Stack Overflow

Questions tagged [sql-server-express]

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.

1718 questions
0
votes
1 answer

Where do I find the databases? Visual Studio and SQL

I have installed Visual Studio Ultimate, and installed the Microsoft SQL Server, and tried to find my way around it, using some tutorials I found on line. I have successfully compiled and run the following C# code: namespace ConsoleApplication2 { …
so.very.tired
  • 2,958
  • 4
  • 41
  • 69
0
votes
1 answer

Can't generate scripts from LocalDB in SQL Management Studio

I can't export scripts from my LocalDB database (localdb)\v11.0. (SQL Express is fine) The error I get is Save or Publish Scripts Report Getting the list of objects from 'XXX'. Failed System.IndexOutOfRangeException: Index was outside the…
Tom
  • 12,591
  • 13
  • 72
  • 112
0
votes
3 answers

Bunch of Inserts (transaction) is quicker than each insert separately

Bunch of Inserts (transaction) is quicker than each insert separately, i think so, maybe not, tell me who check, is there a difference, maybe if many indexes on a table.
Igor Golodnitsky
  • 4,456
  • 7
  • 44
  • 67
0
votes
3 answers

SQL Express Edition, SQL Compact Editin and SQLCMD for learning purpose

I want to learn programming in SQL from some SQL tutorial sites of which I heard of here but I need some environment for executing query's. I think I have both SQL CE and SQL EE installed on my computer but I have some doubts about these DBMS and I…
Mil
  • 81
  • 1
  • 1
  • 3
0
votes
1 answer

SQL Server Connection string with non-administrator user

I'm new to SQL in general. I wrote a long time ago a software using ADO libraries in VB.Net but now I'm moving toward pure SQL statements. I'm trying to figure out a problem in my connection string with non-administrator users. The server has…
LightAndrek
  • 41
  • 8
0
votes
1 answer

Sql Express Connection in ASP

I am trying to connect to sql express db and inserting record to one of the table inside it using following code. set conn=Server.CreateObject("ADODB.Connection") SQL_Conn_STRING = "Driver={SQL…
user3030342
  • 111
  • 1
  • 2
  • 13
0
votes
1 answer

SQL to skip running Create Partition Function under SQL Server Express

Our database schema is stored in a single file that is intended for production use but we also use when running functional tests on our local boxes. We drop the database and rebuild it from this file and then add a known set of test data. All was…
Epsilon Prime
  • 4,576
  • 5
  • 31
  • 34
0
votes
5 answers

c# alter table name add column

Command executed successfully look at here,.. string strConn = "Data Source=USER\\SQLExpress; Initial Catalog=empdata; Integrated Security=true"; SqlConnection conn = new SqlConnection(strConn); conn.Open(); SqlCommand…
ARJUN
  • 399
  • 1
  • 3
  • 15
0
votes
4 answers

SQL Server Express - Website not working

I have a new website that I'm trying to deploy. It works great on my local machine, but when I install on the server, it no longer works and I don't get any error messages. I'm using SQL Server Express, but this isn't installed on the server. Do I…
Neil Knight
  • 47,437
  • 25
  • 129
  • 188
0
votes
1 answer

SQL localdb problems with ADO

I have a native c++ application which uses ado connections to access a SQL Server Express database. For the demo purpose am planning to use LocalDB. But I read that localdb doesn't support ado connections. Is this true??
user1687824
  • 807
  • 2
  • 10
  • 24
0
votes
1 answer

Is IF Executed either way?

I am getting errors executing the following statement: /* AccountTypes Constraints */ IF EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AccountTypes]') AND type in (N'U')) BEGIN PRINT 'Table [AccountTypes] exist.' IF…
Basel Nimer
  • 18
  • 4
0
votes
2 answers

Can't connect to local database while using connection string?

Here's my connection string Server=XXX.XXX.XXX.XXX\SQLExpress;Database=inspection;User Id=sa;Password=xxx; I'm getting an error that it couldn't connect, but when I use connection string like this Server=.\SQLExpress;Database=inspection;User…
user3188370
  • 107
  • 1
  • 1
  • 7
0
votes
3 answers

SQL query to choose row before two consecutive true values

Here is my table. Price Volume ------------------ 60 0 70 10 80 0 90 0 100 40 200 40 300 40 400 0 500 50 600 60 It is ordered by Price. I need to choose all rows…
user1700890
  • 7,144
  • 18
  • 87
  • 183
0
votes
2 answers

Database Create on SQL Server2008 Express/Windows VIsta Home Edition

I successfully installed Express on Windows Vista Home Edition. When I tried to create a database using the account under which it was installed I received this message: TITLE: Microsoft SQL Server Management Studio Create failed for Database…
Jim
  • 1
  • 1
  • 1
0
votes
1 answer

Reporting Services running on SQL Server 2008 Express

I know I can run Reporting Services on SQL Server Express w/ Advanced Services. The articles I have read do not touch on my question. I'm wondering, in this scenario, can remote users execute reports from the report server remotely using URL…
Dan
  • 905
  • 4
  • 10
  • 16
1 2 3
…
99 100