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

Retrieving only primary key column numbers from article_tbl and checking against?

Would like to figure out how to better retrieve data from database without performance cost. Plan as follows: Select id from article table; store ids in List arr; find out last article id. int x = arr.Count() Select * from article_tbl where…
user610961
  • 181
  • 1
  • 10
0
votes
1 answer

Sql update query doesn't fire update trigger for all records

I called update query from table1 trigger, when that query runs, it updates other table2 successfully but update trigger of table2 is fired only 1 time means not for every record that was updated from query of update I'm using SQL Server 2008…
Ovais
  • 41
  • 5
0
votes
1 answer

What mstrConnection should I use on a webpage to access local SQL Server Express (localhost\SQLEXPRESS)?

Would the following suffice? Dim mstrConnection As String = "workstation id=COMPUTER;packet size=4096;data source=localhost\SQLEXPRESS; integrated security=false;user id=x309-PC\x309;password=abc"
user133466
  • 3,391
  • 18
  • 63
  • 92
0
votes
2 answers

SQL Server 2008 vs SQL Server 2008 Express size

I migrated a SQL Server database (source) into a SQL Server Express database (destiny). Used "generate scripts..." in SSMS. I verified if the tables (tested with the 3 biggest tables) in the source DB had the same number of rows has the Express and…
Artur Carvalho
  • 6,901
  • 10
  • 76
  • 105
0
votes
1 answer

Problems with "Pro Business Applications with Silverlight 4"

I'm having problems setting up the database described in Apress's Pro Business Applications with Silverlight 4. I have SQL Server 2008 R2 Express which doesn't support Full Text Search, and I can't install the database from codeplex…
Jordan
  • 9,642
  • 10
  • 71
  • 141
0
votes
1 answer

Combining several queries into 1 new query

I have a table that consists of all of our agency records. I have several queries set up that count something specific about these records and each query groups them all by date. What I am trying to figure out is how I can combine these queries…
Wendy
  • 3
  • 1
0
votes
0 answers

Change color in datagridview and SQL database

How can I change the color of my Datagridview using C# so that all users connected to a database will see the color? For example a superuser selects that a row should be red, and other people connected to the database loading the datagridview will…
Steven Brachna
  • 1
0
votes
1 answer

How to synchronize from SQL Express 2008 to SQL Server 2008?

I have an app the runs at the store level extracting data out of a POS system. This app asks the POS system for data which in return produces some .DBF files. The app loads the DBFs in memory and saves it to SQL Server 2008 Express at the store…
Fabio S.
  • 460
  • 7
  • 22
0
votes
0 answers

Can't connect my desktop application to local SQL Server 2008 Express

I am using SQL Server authentication for login through SQL Server Management Studio and I can access SQL Server. However, my desktop application cannot establish a connection to the server. I use the following connection…
Sonam
  • 87
  • 2
  • 9
0
votes
1 answer

FILESTREAM driver for Windows Server 2003 or XP?

Does Microsoft FILESTREAM RsFx driver (for MSSQL filestreams) work on Windows Server 2003 or Windows XP if using MSSQL Express? I know of FILESTREAM driver certified for Windows Server 2008, but what about older systems?
Boris B.
  • 4,933
  • 1
  • 28
  • 59
0
votes
1 answer

create sql server table function thru java

I used a simple sql statement for testing purposes if it is possible to create a table function thru java. However, it takes a very long time for the creation of function to finish and causes other db users to time-out. Any thoughts? I'm using…
Elmer
  • 262
  • 2
  • 15
0
votes
1 answer

Which SQL Server edition works when adding a local database to a project?

I am using Visual Studio 2008 Professional SP1. On my PC, SQL Server 2008 Express R2 and SQL Server 2008 Compact Editions are installed. When I right click on Solution Explorer and add "Local Database", which database I am creating? Is it the…
RKh
  • 13,818
  • 46
  • 152
  • 265
0
votes
1 answer

upgrading sql server 2008 R2 express edition to standard edition

I am using sql server 2008 R2 express edition,it only supports 10 Gb DB space. how can i get know how much space is used and how much free space i have balance,i have tried sp_spaceused, but i didn't get clear answer. i think i have 2 DB's. and if i…
Rizwan
  • 1
0
votes
0 answers

Integrating custom database to an ASP.NET MVC4

I have an existing database in SQL Server Express, and I'm developing an ASP.NET MVC4 application, which needs to connect to this database. When I've created my project, I have selected "Individual user account" for the authentication. My question…
Morgan
  • 476
  • 9
  • 23
0
votes
2 answers

How to restore Master db in SQL Server 2008 Express?

Please can I ask for your assistance in investigating as to why I cannot restore the master db from a recent backup? Physical copies taken of .mdf and .ldf master files (just in case!) and then I've recreated a corrupted master database by manually…
L.Kibbey
  • 1
1 2 3
…
22 23