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
2
votes
2 answers

Encrypting Whole Database

I need to encrypt whole databse, not any specific column in the database. This should be done in SQL 2008 or in SQL 2008 Express edition If any one can, do favour for this
sabarinathan
  • 21
  • 1
2
votes
3 answers

Can't connect to local computer via SQL Server 2008 Express Management Studio

HI, folks, Previously, I had a SQL Server 2008 installed, but then I deleted it, and installed SQL Server 2008 Express Management Studio. And now I can't connect to local computer. I get error : A network-related or instance-specific error…
Dzmitry
  • 749
  • 2
  • 11
  • 25
2
votes
3 answers

Visual Studio 2010 database project does not recognize SQL 2008 geography data type

I've created a new SQL 2008 database project in Visual Studio 2010 and filled it with the contents of a local SQL Express database. When I try to build the database project I get this error: SQL03006: Column: [dbo].[table1].[geog] has an unresolved…
Mathieu Diepman
  • 151
  • 1
  • 11
2
votes
3 answers

Create an SQL Express 2008 database in C# code, but login fails when trying to connect with a sysadmin

I have a piece of code that creates an SQL Server Express 2008 in runtime, and then tries to connect to it to execute a database initialization script in Transact-SQL. The code that creates the database is the following: private void…
andragon
  • 658
  • 7
  • 8
2
votes
1 answer

Exporting MS SQL Schema and Data

I'm used to MySQL and PHPMyAdmin - I had to switch over to MSSQL for an ASP.net project, and I'm having tons of trouble. I'm using the express version of SQL 2008, with SQL Server Management Studio. The following are 2 questions I've been struggling…
stringo0
  • 2,720
  • 7
  • 38
  • 52
2
votes
3 answers

cmd line SQL server 2008 express install

I am trying to install SQL server 2008 express on windows 7 64 bit machine using the following command: Setup.exe /qs /Action=Install /Features=SQL /InstanceName=XXX /SQLSYSADMINACCOUNTS="Builtin\Administrators" /SQLSVCACCOUNT="NT…
Balaram Palasamudrum
  • 21
  • 1
  • 1
  • 2
2
votes
2 answers

Query for rows including child rows

A few weeks ago, I asked a question about how to generate hierarchical XML from a table, that has a parentID column. It all works fine. The point is, according to the hierarchy, I also want to query a table. I'll give you an example: Thats the table…
Michael Niemand
  • 1,578
  • 3
  • 23
  • 39
2
votes
1 answer

Access denied when starting SQL Server Express from command line

Windows 7 computer running SQL Server Express 2008 (sp1). When I try to run net start mssql$sqlexpress I receive an error: System error 5 has occurred. Access is denied The SQL service is running under "Network Service" account The service…
Brettski
  • 19,351
  • 15
  • 74
  • 97
2
votes
3 answers

Convert SQL Server Express 2005 .mdf to 2008 .mdf?

Hi I have a Visual Studio solution and an ASP.NET MVC project that uses a SQL Server Express 2005 database file in the App_Data. I want to know how I can upgrade this file so it works for SQL Server Express 2008 ? Thanks
Pricey
  • 5,799
  • 12
  • 60
  • 84
2
votes
1 answer

Migrate db from SQL server 2008 to SQL express 2008 and estabilish connection

SQL server 2008 db on one physical server was migrated to other physical server with SQL express 2008. All tables and data were successfully migrated, but I am not able to connect with my asp.net mvc app to the new express db. In my connection…
nevo
  • 47
  • 2
  • 7
2
votes
3 answers

Ninject: Provide an un-opened SqlConnection when asked for DbConnection

I want to map DbConnection to an un-opened SqlConnection using Ninject. This is what I've done: string constr = @"Server=.\SQLEXPRESS; Trusted_Connection=True; Database=TestDB"; Bind().To() …
Tomas Aschan
  • 58,548
  • 56
  • 243
  • 402
2
votes
2 answers

How do I backup the data in SQL Server 2008 on a third party host?

I have a SQL Server 2008 database that is hosted by a third party host (heart internet). How would I go about backing this up? I used SQL Server Management Studio Express 2008 to create the tables within the database, but the backup options within…
Sergio
  • 9,761
  • 16
  • 60
  • 88
2
votes
0 answers

SQL Server service not starting automatically on Windows Server 2008 express

My websites are running on virtual Windows server 2008 R2 Standard. The server had an unplanned reboot. The SQL Server 2008 Express instance service Startup Type is automatic but the service did not start upon reboot and I had to manually restart…
rumi
  • 3,293
  • 12
  • 68
  • 109
2
votes
2 answers

No Management Studio seen after SQL Server 2008 Express installation

I have recently successfully completed the installation of SQL Server 2008 Express. After installation when I tried accessing SQL Server Express I found there was no Management Studio installed. Is there an issue with express, that Management Studio…
tejas
  • 43
  • 2
  • 4
2
votes
2 answers

T-SQL: How to join @variable tables (another try)

I know, this is a duplicate question of this question. But i encountered the same problem and maybe i can provide some more available informations. If i try out the following example query: DECLARE @_Files TABLE (ID INT, Filename…
Oliver
  • 43,366
  • 8
  • 94
  • 151
1 2 3
…
22 23