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
0
votes
1 answer

publishing a database from VS 2012

i want to publish a database using visual studio to my SQL instance, however i get this error CREATE DATABASE permission denied in database 'master'. when i "select user_name" i get the 'guest' account in a VS query, i do get 'dbo' in SSMS how can i…
CodeEmpower
  • 635
  • 1
  • 11
  • 29
0
votes
3 answers

.exe run error on other pc

I have written a desktop application (Windows Forms) in .NET Framework 4.0 using Visual Studio 2010 and SQL Server 2008. In the /bin folder, it creates an .exe file which works fine on my computer and other computers if they have Visual Studio and…
user2798264
  • 1
  • 2
0
votes
2 answers

Adding SQL indices

I'm currently working on a SQL assignment that wants me to: Add an index for each foreign key and an index on Company for Customer and Shipper. I've created the 3 tables that were needed, created the foreign and primary keys, and so on. But my…
Sir. Koop
  • 3
  • 1
0
votes
3 answers

SQL Express 2008 - table 2 column1 equals table1 column1

I have two tables: table1 has staffid table2 has staffid I want table2 staffid to be equal to table1 staffid and when changes are made to table 1 staff id they need to change staffid in table2 How do I do this?
user2829947
  • 1
0
votes
0 answers

Database 'MYdb' cannot be opened

I am using SQL Server 2008 Express I created a database using the following queries create database testdata on primary (name = testdata, filename='C:\data\testdata.mdf'), filegroup filestreamgroup contains filestream (name = testdata_1,…
walter chuks
  • 1
  • 4
0
votes
1 answer

Is the express version of SQL Server 2008 compatible with databases from full version?

There are databases that currently run in the full version of Microsoft SQL Server 2008, and I am looking to start developing with them from my personal computer, using the express version. Would there be any issues with this? My current thought…
Jono
  • 3,949
  • 4
  • 28
  • 48
0
votes
1 answer

Moving from SQL Server 2008 Express to SQL Server 2012

I have SQL Server 2008 Express on my pc, and I want to install SQL Server 2012 instead. Do I have to uninstall SQL Server 2008 Express first? Do I have to backup my databases first? Same question about VS 2010. I have VS 2010 Professional and I want…
Sertan Pekel
  • 593
  • 2
  • 5
  • 23
0
votes
2 answers

how to try execute repeatly if command.ExecuteNonQuery() fails

how to try execute repeatly if command.ExecuteNonQuery() fails?
loviji
  • 12,620
  • 17
  • 63
  • 94
0
votes
1 answer

SQL Server 2008 Express remote connection

I have a connection string to connect to sql server express 2008 string ConnectionString = @"Server=.\SQLEXPRESS,1433; Network Library=DBMSSOCN; Initial Catalog=mydb; user id=sa; password=12345qwerty"; this works normally but when i want to remote…
ReZa
  • 1,273
  • 2
  • 18
  • 33
0
votes
3 answers

SQL Server 08 Express Installed: But how to make a local database?

I try to connect to 127.0.0.1 with Windows Authentication using Management Studio Express 2008 but it never connects says it can't find the server or something. I ran the SQL Server Express 2008 Installer and it said that it was already installed…
MetaGuru
  • 42,847
  • 67
  • 188
  • 294
0
votes
1 answer

SQL Server Express connection to another computer by changing exe.config

I have problem to connect my application (on computer A) to another computer (computer B) that had the database (.mdf file). This is my code
Nore
  • 111
  • 2
  • 4
  • 20
0
votes
1 answer

How resolve Deployment when we change server

i built an application using sql server express , Wpf and LINQ To sql the problem is if we change the server we are obliged to change the connection string used in all the application . if we create another database in an other machine the…
gasroot
  • 515
  • 3
  • 15
0
votes
1 answer

SQL Server 2008 Linked Server Security

From server1, I've created a connection to a remote server (server2) with the Linked Server facilities. Both servers are on the same domain. When I log to server1 I can successfully execute my stored procedures from SQL Server Management Studio but…
user1405736
  • 365
  • 2
  • 4
  • 17
0
votes
3 answers

SQL Server character set and N prefix

[THIS IS NOT A QUESTION ABOUT NVARCHAR OR HOW TO STORE CHINESE CHARACTER] SQL Server 2008 Express Database collation is SQL_Latin1_General_CP1_CI_AS create table sample1(val varchar(2)) insert into sample1 values(N'中文') I know these Chinese…
gfytd
  • 1,747
  • 2
  • 24
  • 47
0
votes
1 answer

Get column a and column b through first parameter to last parameter

I'm newbie on tsql and stuck on this problem. Can anyone help this prb? I have a table like below; (use SQL 2008 Express Edt.) ID COL1 COL2 1 7 2 2 7 3 3 7 4 4 7 5 5 9 2 6 9 3 7 …
ZEK
  • 3
  • 3
1 2 3
…
22 23