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

How can I setup an application that uses SQL Server 2008 Express on a machine that already has SQL Server 2005 Express

I have developed an application in VB.Net (VS2010) and make a setup & deployment that checked in prerequisites SQL Server 2008 Express. When I install it on another system that use installed application that uses SQL Server 2005 Express, I get this…
student
  • 3
  • 4
0
votes
2 answers

SQL update statement to replace string partially like after @ text of an email address

I want a query to update a table named users where emails are not entered properly. Like this: praneeth@gmail ram@gmail.co krishna@gma farooq@gmail.com I need a query to make sure that all the text after @ is set to gmail.com for all the text…
PraneethArnepalli
  • 33
  • 2
  • 10
0
votes
1 answer

Cannot connect to User-PC in SQL Server 2008 Express?

I want to connect to a SQL Server 2008 Express but I get this error - how to solve it? TITLE: Connect to Server Cannot connect to DHARMARAJ-PC. ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a…
G D
  • 47
  • 8
0
votes
1 answer

When installing setup prerequisite is not asking for SQL Server 2008 Express

I have an application which has SQL Server 2008 Express as a prerequisite. It is working fine on Windows XP and Windows 7 Home Basic. But when we install it on a Windows 7 Professional machine it asks for .Net framework but not ask for SQL Server…
maneesh katiayar
  • 1
0
votes
1 answer

unixODBC driver trace only shows tracing from pl/perl but not perl?

I added to odbcinst.ini the following: [ODBC] Trace = yes TraceFile = /777path/odbctrace.txt This produces the file indicated; however, it seems to be tracking only one particular connection out of the multiple connections there are:…
Kev
  • 15,899
  • 15
  • 79
  • 112
0
votes
1 answer

How to avoid MSTDC

I want synchronize data between two SQL servers 2008 Express Edition. I would like to avoid escalating SQL queries to MS DTC service (MS DTC service is not running). For synchronization I use stored procedures without transactions. I have more…
MartinM
  • 61
  • 1
  • 2
  • 6
0
votes
2 answers

Does Sql Server Compress Database size on similar data

Just to find out my would be DB size on production environment, I just populated my tables with 1.5 million rows of nearly same data (Except Primary key). It currently shows 261 MB... Now, Whether I can rely on this, or since the Data is almost…
The King
  • 4,600
  • 3
  • 39
  • 58
0
votes
1 answer

SQL Server 2008 Express Automatic Backup Methods?

i would like to ask you about the available automatic backup methods for SQL Server 2008 Express Editition. I tried Replication method on other server, but it is not available with Express Edition. Please help, i searched a lot for solutions but…
user3213767
  • 179
  • 2
  • 2
  • 9
0
votes
1 answer

Is it possible to run arbitrary SQL Server Express application on a network share?

I have an application, written probably in C# or VB.NET and accessing a SQL Server Express database. It has .MDF and .LDF files in the same directory as executable. How to make this application to run from network share in general…
Dims
  • 47,675
  • 117
  • 331
  • 600
0
votes
3 answers

Leave only rootmost paths in sql stored procedure

Based on the great solution provided by Sergey for my c# question here: Filter out path strings beginning with strings, i went away to craft a similar thing for T-SQL. I can refactor this to use in memory table as opposed to cursors, but i would…
zaitsman
  • 8,984
  • 6
  • 47
  • 79
0
votes
0 answers

Cannot start SQL Agent in SQL Server 2008 Express

So my SQL Server Express version does not allow the SQL Agent service to run. I want to automate a query to execute about every 10 seconds. I suppose, given my task, it could be done every minute. Is there a way to execute an automated SQL query…
user3242661
  • 89
  • 4
  • 12
0
votes
0 answers

Issue installing SQL Server 2008 Express as a dependency via ClickOnce

I'm currently working on a project which has a Winforms component that is installed via ClickOnce. The original target OS was Vista and above and it continues to work fine for those platforms. However, the customer has now requested that the…
DilbertDave
  • 3,406
  • 3
  • 33
  • 42
0
votes
1 answer

How to include database file and SQL Server Express installer for Deployment with VS2010

I am using Visual Studio 2010 and SQL Server 2008 Express I would like to deploy my project with setup and deployment project and would like to include the SQL Server database file and SQL Server 2008 Express installer, so the user can easily…
donata
  • 43
  • 6
0
votes
1 answer

Login failed for user 'MyPC\Useraccount'

Hi I'm trying to connect to SQL Server 2008 Express using the following code. The Connection string was given in the app.config
Saratchandra
  • 166
  • 5
0
votes
2 answers

Unable to open the physical file failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share

I have developed and website as for my assignment purpose and then my teacher asked me that he doesn't have SQL Server to run separately my database file so I must have to make built in database. I then added the .mdf file to the App_data folder…
Yasir
  • 55
  • 2
  • 9
1 2 3
…
22 23