Stack Overflow
Stack Overflow

Questions tagged [sql-server-2008-express]

SQL Server 2008 Express is a free edition of SQL Server that is an ideal data platform for learning and building desktop and small server applications, and for redistribution by ISVs.

Microsoft SQL Server 2008 Express is a powerful and reliable data management system that delivers a rich set of features, data protection, and performance for embedded application clients, light Web applications, and local data stores.

It is a version of Microsoft's SQL Server relational database management system that is free to download or distribute. It comprises a database specifically targeted for embedded and smaller-scale applications. The product traces its roots to the Microsoft Database Engine (MSDE) product, which was shipped with SQL Server 2000. The 'Express' branding has been used since the release of SQL Server 2005.

340 questions
11
votes
2 answers

How to expire a particular row in SQL Server once a date is reached?

It may be very simple scenario for experienced developers, but as a beginner I have been hanging around this for a long time. I am creating a website in asp.net where a user can purchase a packages. These packages have some expiry date associated…
vivek
  • 1,595
  • 2
  • 18
  • 35
9
votes
1 answer

SQL server "Cannot send mails to mail server" "Failure sending mail"

I am using MS SQL Server 2008 R2 SP2 Express edition, 64 bit. I do not have access to the Database Mail setup wizard, but the Binn directory contains DatabaseMail.exe (v10.50.16600.1) and DatabaseMailengine.dll. I found several references to "Cannot…
WeststarEric
  • 321
  • 1
  • 2
  • 12
8
votes
3 answers

SQL Server: How to change name in a view?

I am using Visual Studio 2008 and SQL Server 2008 Express. How can I change the name of the view? I can change tables' names, but I can't change the view name. Any suggestion? Thank you, Fabio Milheiro
Fabio Milheiro
  • 8,100
  • 17
  • 57
  • 96
8
votes
3 answers

Can't connect to server on SQL Server Management Studio 2008

When I open the Management Studio and try to connect using the [PCNAME]/SQLEXPRESS it shows this error: "Cannot connect to [PCNAME]\SQLEXPRESS" ADDITIONAL INFORMATION: Error Message: A network-related or instance-specific error occurred while …
Alternatex
  • 1,505
  • 4
  • 24
  • 47
7
votes
5 answers

Using SQL server 2008 for ASP.net 2.0 Membership provider

I tried to set-up the SQL tables for ASP .net 2.0 membership provider by clicking on ASP.net Configuration under Project. I have completely uninstalled SQL 2005 Express and installed SQL 2008 Express instead. It seems like that it can not connect to…
Raha
  • 1,959
  • 3
  • 19
  • 28
7
votes
5 answers

What is the default username and password of my SQL Server Express?

It installed automatically with Visual Studio 2010 Ultimate. I didn't create any users for the server or ANYTHING. I'm using: string connectionString = @"Server=.\SQLEXPRESS;Database=SportsStore;Trusted_Connection=yes;"; I get error that…
Sergio Tapia
  • 40,006
  • 76
  • 183
  • 254
6
votes
5 answers

c# 2008 SQL Server Express Connection String

I have a 2008 SQL Server Express installed on one of my machines and I'm attempting to establish a remote connection... when I use the MS SQL Server Management Studio I can log into the database without any problems at all (with the same…
Kiril
  • 39,672
  • 31
  • 167
  • 226
6
votes
5 answers

Save password for ODBC connection to MS SQL server from MS Access 2007

I am in charge for migrating old Access 2007 project to MS SQL server 2008 Express. The first stage is to move all the data from MS Access database to SQL server while keeping the Access forms and reports at the client. So, the data are now moved,…
Passiday
  • 7,573
  • 8
  • 42
  • 61
6
votes
2 answers

SQL Server 2008 Express Edition - how to create a sequence

I'm using SQL Server 2008 Express Edition. I wanna create a sequence with this code: CREATE SEQUENCE Postoffice_seq AS bigint START WITH 1 INCREMENT BY 1 MINVALUE 0 NO MAXVALUE; and the error is Msg 343, Level 15, State 1, Line…
user437925
  • 101
  • 1
  • 2
  • 3
6
votes
1 answer

How do I grant a database role execute permissions on a schema? What am I doing wrong?

I am using SQL Server 2008 Express edition. I have created a Login , User, Role and Schema. I have mapped the user to the login, and assigned the role to the user. The schema contains a number of tables and stored procedures. I would like the Role…
Lewray
  • 1,164
  • 1
  • 11
  • 26
6
votes
3 answers

Visual studio 2010 and Sql Server

Do visual studio 2010 include already Sql Server instance, or I need to install Sql Server developer edition to develop an application that need a Sql Server db. If it installs a Sql Server express edition, it this enough or it's better to have Sql…
Fitzchak Yitzchaki
  • 9,095
  • 12
  • 56
  • 96
6
votes
2 answers

SQL: Deleting duplicate records in SQL Server

I have an sql server database, that I pre-loaded with a ton of rows of data. Unfortunately, there is no primary key in the database, and there is now duplicate information in the table. I'm not concerned about there not being a primary key, but i…
rockit
  • 3,708
  • 7
  • 26
  • 36
5
votes
2 answers

full text search using sql server 2008

I had installed sql server 2008 express edition with tools but I need to use full text search which i understand is missing in the edition that I have. How do I go about upgrading to get full text search feature? As it was an online installation I…
Sneha
  • 121
  • 3
  • 16
5
votes
5 answers

SQL Server Browser showing only hostname, not instance name

I just setup a new Windows Server 2008 machine with an instance of SQL Server 2008 Express. The SQL Browser service does not appear to be working correctly. In Management Studio, browsing for servers shows the hostname of the new server, but not…
ScottStonehouse
  • 24,155
  • 7
  • 32
  • 34
5
votes
1 answer

Does SQL Server 2008 express allow remote connections?

I have tried to remotely connect to SQL. I put in port 1433, I restarted the service, and I don't have Windows' firewall active. However, I can only use local connection, I can't remotely connect. I read that SQL Server 2005 Express doesn't allow…
angel
  • 4,474
  • 12
  • 57
  • 89
1
2
3
…
22 23