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
352
votes
17 answers

How can I clone an SQL Server database on the same server in SQL Server 2008 Express?

I have an MS SQL Server 2008 Express system which contains a database that I would like to 'copy and rename' (for testing purposes) but I am unaware of a simple way to achieve this. I notice that in the R2 version of SQL Server there is a copy…
Sergio
  • 9,761
  • 16
  • 60
  • 88
140
votes
2 answers

What is the difference between SQL Server 2012 Express versions?

I've come across this page http://www.microsoft.com/en-us/download/details.aspx?id=29062 and I am a bit confused about the different versions here. So I would like to know what is the difference between…
Rushino
  • 9,415
  • 16
  • 53
  • 93
136
votes
6 answers

Limitations of SQL Server Express

My hosting provider (Rackspace) is offering a fully managed dedicated server with SQL Server Web version () installed. My company handles web development, and has about 20+ clients using ASP.Net + SQL Server 2005. I am thinking of cutting down…
Donniel
89
votes
3 answers

How to create jobs in SQL Server Express edition

Could anyone please explain to me how to create jobs in SQL Server Express edition?
Pearl
  • 901
  • 1
  • 8
  • 8
71
votes
13 answers

Sql connection-string for localhost server

I am newbie in this .NET and please don't mind in answering my simple question. I am trying to write a windows application, where in I am using a localhost SQLserver for database. I need to know what is the exact connection string for my localhost,…
GB Hariharan
  • 927
  • 2
  • 7
  • 6
25
votes
1 answer

SQL - "Save results as CSV" - use comma instead of Semi-Colon

Hey, i need to export a query result to a CSV, but i get a semi-colon as a delimiter. I went to: Tools - Options - Query Results - SQL Server - Results to Text and set Output format: Custom delimiter Custom delimiter: , and i still get the…
André Alçada Padez
  • 10,987
  • 24
  • 67
  • 120
24
votes
3 answers

How can I restore a database backup file (.bak) from SQL Server 2012 into SQL Server 2008 Express?

A database that was originally from SQL Server 2008, was restored into SQL Server 2012. A backup from SQL Server 2012 was made and I am trying to restore it on my local SQL Server 2008 Express. However I get an error 'Specified cast is not valid'…
stormwild
  • 2,855
  • 2
  • 31
  • 38
23
votes
5 answers

Binary Blob truncated to 8000 bytes - SQL Server 2008 / varbinary(max)

I have upgraded from Fluent Nhibernate 1.0 with Nhibernate 2.1 to pre- release 1.x with NHibernate 3.0 GA and have hit what I think is a regression, but I want to hear if that's indeed the case. I am using SQL Server Express 2008 and the MSSQL 2008…
Ivan Zlatev
  • 13,016
  • 9
  • 41
  • 50
20
votes
3 answers

Need to create new database without using management studio

How to create new database with SQL Server Express 2008 without using Management Studio? Do i need to download sp1?
remo
  • 201
  • 1
  • 2
  • 3
18
votes
4 answers

How to find the worst performing queries in SQL Server 2008?

How to find the worst performing queries in SQL Server 2008? I found the following example but it does not seem to work: SELECT TOP 5 obj.name, max_logical_reads, max_elapsed_time FROM sys.dm_exec_query_stats a CROSS APPLY…
Thomas Bratt
  • 48,038
  • 36
  • 121
  • 139
18
votes
2 answers

The 'SQLNCLI' provider is not registered on the local machine

I have a NAnt-based script which that I run on my local PC that connects to SQL Server 2008 Express also running on my local PC to drop and recreate databases using .sql files - this works fine, no problem here. The problem comes when I have…
Brett Rigby
  • 6,101
  • 10
  • 46
  • 76
16
votes
7 answers

Can I get sql profiler for sql2008 for free?

Is it possible to get sql profiler for sql2008 for free or you have to have a license to get it? i.e. it won't work with sql express
Blankman
  • 259,732
  • 324
  • 769
  • 1,199
13
votes
1 answer

Upgrading from SQL Server 2008 Express to 2008 Developer

What is the best (or THE) way to change my SQL Express 2008 (with advance...) installation to a 2008 Developer edition? I need to keep the databases, along with the logins and so on. I need to upgrade because, I Want to use all the features in TFS…
josecortesp
  • 1,526
  • 4
  • 21
  • 38
12
votes
3 answers

An explicit value for the identity column in table 'customers' can only be specified when a column list is used and IDENTITY_INSERT is ON

Possible Duplicate: Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF I am new to SQL. I am trying to write a INSERT query in SQL server 2008 Express edition. The query is : insert into…
user1716251
  • 135
  • 1
  • 1
  • 6
11
votes
5 answers

.mdf is too new (661) my database supports version 655

I am using SQL Server 2008 express and i want to import .mdf and i get this error: .mdf version is 661, your db supports the version 655 Which version is 661 and how to import it in sql Server 2008.
senzacionale
  • 20,448
  • 67
  • 204
  • 316
1
2 3
…
22 23