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
9
votes
3 answers

Do indexes count towards the 10gb database size limit on SQL Server Express?

I'm working on a project that uses a SQL Server Express database that is decently large already and I know indexing specific columns / tables can take up quite a bit of space. What I don't know is whether the space used by the index counts against…
PorcupineRending
  • 1,245
  • 1
  • 11
  • 16
9
votes
3 answers

Getting "SQLExpress database file auto-creation error" for site that uses AspNetSqlMembershipProvider, but connection string is to SQL Server 2005

I have an ASP.NET v2.0 website (not web application) where the root directory is public, but the "Admin" subdirectory requires authentication. Everything about the setup is very generic - I used a connection string defined in the root web.config,…
Tom Kelleher
8
votes
2 answers

Sql Server 2008 Express with full text search

I wanted to try out the fts feature of sql server 2008 express. According to the product page (http://www.microsoft.com/sqlserver/en/us/editions/express.aspx) , there should be fts included in the download. Offers reporting capabilities, full-text…
Kim
  • 201
  • 3
  • 6
8
votes
4 answers

Is there a way to stop SQL Express 2008 from Idling?

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 logged in for a 20 minute period SQL express will kick…
Element
  • 3,981
  • 7
  • 42
  • 51
8
votes
2 answers

SQL Server Silent installation get error during installation

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 SQL Server Express and here is a sample *.aip file to…
Reza Paidar
  • 863
  • 4
  • 21
  • 51
8
votes
2 answers

Connect to SQL Server Express Database with Python (Windows Authentication)

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;databaseName=4YP;integratedSecurity=true"; …
Aine
  • 195
  • 1
  • 2
  • 10
8
votes
4 answers

Copy SQL Server Express Database to Another Computer

I am upsizing the back end of a client's Access app tomorrow and need to be ready with a plan for a particular problem with this client. The boss needs to be able to take the data file away from the office where the SQL Server is on a regular basis…
David-W-Fenton
  • 22,871
  • 4
  • 45
  • 58
8
votes
0 answers

Can't get SQL Server 2012 Express EULA to suppress (despite using /IAcceptSqlServerLicenseTerms) with Visual Studio 2015 prerequisite install

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:\Program Files (x86)\Microsoft Visual Studio…
Hershizer33
  • 1,206
  • 2
  • 23
  • 46
8
votes
1 answer

SQL Server 2008 Express Grant User Permission

What is the appropriate SQL commands (not through the GUI) to add a windows user account to permissions on a SQL Server 2008 Database? ie.. I want to give someone read access and another person read/write..
Brett
  • 121
  • 1
  • 2
  • 4
8
votes
6 answers

How to create a connection string in asp.net c#

I am working on asp.net c# project, for connection I used: SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\19-02\ABCC\App_Data\abcc.mdf;Integrated Security=True;User Instance=True"); but I want to get this…
user3363485
  • 81
  • 1
  • 1
  • 5
8
votes
0 answers

How to install IIS Express 8 and SQL Server 2012 using WiX?

I want to create an installer using WiX, which will install following pieces of software, if they aren't installed already: installs IIS Server Express 8.0 SQL Server 2012 Express. To do this, I created following Setup.wxs file:
Glory to Russia
  • 17,289
  • 56
  • 182
  • 325
8
votes
3 answers

No SQL Server Express logins have permission to create db

I cant create a new db because there are only 2 logins: sa BuiltIn\Users I get permission denied when trying to create the db even though I am the admin. How can I add a user with permissions at this point or must I reinstall?
zsharp
  • 13,656
  • 29
  • 86
  • 152
8
votes
1 answer

How to determine LocalDb instance name in SQL script?

For a non-LocalDb SQL Server, I can SELECT SERVERPROPERTY('ServerName') to get the name of the server and the instance that I'm running on. For a LocalDb server, however, I get SERVERNAME\LOCALDB#SOMEHASH. How can I get the local instance…
carlpett
  • 12,203
  • 5
  • 48
  • 82
8
votes
4 answers

How can I assign a number to each row in a table representing the record number?

How can I show the number of rows in a table in a way that when a new record is added the number representing the row goes higher and when a record is deleted the number gets updated accordingly? To be more clear,suppose I have a simple table like…
Hossein
  • 24,202
  • 35
  • 119
  • 224
7
votes
2 answers

Is SQL Server Express' 4GB limit affected by FILESTREAM enabled columns?

I have read some conflicting reports on the net about whether the 4GB limit of SQL Server Express takes into account the contents of FILESTREAM. Can anyone say for certain citing official documentation whether SQL Server Express storage limit is…
joshcomley
  • 28,099
  • 24
  • 107
  • 147
1 2 3
…
99 100