I am developing an application with Microsoft Sync Services. The server will be running SQL Server Express and there will be multiple clients running SQL Server CE. I'm using SQL Server change tracking. Data to download is set to "New and incremental changes after first synchronization". I have a small demo application that lets me d...
Hi guys, I have a problem with Visual C# 2008 express (SP1) connecting to SQL Server 2008 express. The "Add Connection" window (wherever initiated) doesn't list existing sql server and no option for sql server except a compact edition. Note that, I've got the VWD 2008 express (SP1) on the same machine which shows the window regularly (...
I'm working on a SQL Server 2008 Express + silverlight project, and so far things are working pretty well on the local machine. I've set it up to where the silverlight app connects to the SQL Server using a service reference and LINQ, and I believe the SQL Server allows remote connections with TCP/IP. However, since the silverlight app ...
Hi Due to the lack of documentation for this on MSDN, I am forced to ask here. Does the Express version support the same Change Tracking Feature(s) as the other editions does? Thanks leppie ...
How can I add SQL Server 2008 Express to the list of Pre-requisites in Visual Studio 2008 SP1 MSI Installer Project. Thanks Kishore ...
This stems from a previous question I asked - about a write conflict with a form, but the problem seems to be originating from the fact that I can update existing records in a linked table provided by one System DSN, but not another linked table provided by another DSN (different database) - allowing me to enter records at first, but the...
Hi, I have a 2008 SQL Server Express installed on one of my machines and I'm attempting to establish a remote connection... when I use the MS SQL Server Management Studio I can log into the database without any problems at all (with the same credentials), but when I try to create a connection string in my C# application I get an excepti...
I want to install SQL Server 2008 Enterprise and SQL Server 2008 Express side-by-side on the same machine, which should I install first for a simpler install process and easier maintenance in future? ...
Hi there, I am about to move servers and i was talking to somebody and they suggested using sql server express 2008 installed on the servers. I have full access to the server. Does this express engine work at the same speed (performance) as a true sql server 2008? I know about the limitations i..e max 4 GB per DB ... and max 1 GB of r...
Without wanting to sound too stupid, SQL Express is free and the free resources make it a good choice for a beginner like me. I know it has limitations (read other posts) but the figures mean little to me I'm afraid. Can anyone give me ball park figures on the number of users it can handle? I'm looking at possibly 40-50 users maximum,...
I'm trying to connect ColdFusion 8 to SQL Server 2008 Express and I'm experiencing some issues when I try and run CF queries. When I try and run a query I get: (data source name removed, I didn't use [Name]) Datasource [Name] could not be found. The error occurred in [FilePath]: line 1 1 : <cfquery name="tasks" datasource="[Name]" > ...
Hi, My hosting provider (Rackspace) is offering a fully managed dedicated server with SQL Server Web verion () installed. My company handles web development, and has about 20+ clients using ASP.Net + SQL Server 2005. I am thinking of cutting down costs by installing the free SQL Server 2008 Express instead. I am aware of the 1GB RAM a...
I have Database project which I'm unable to load in VS2008 and I have SQL Server 2008 Express edition installed on my machine.. I get following error message, when I try to load Database projects require a connection to a local instance of Microsoft SQL Server 2005 for design-time validation. To perform this operation, you m...
Hi, If you look the edition comparison... http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx It says for Express Edition that this option is not enabled for SQL Server Express.. Enhanced Gauges and Charting Anyone know what the limitations are on this item? I can't seem to find any more information.. Many thanks, ...
I am using Visual Studio 2008 and SQL Server 2008 Express. How can I change the name of the view? I can change tables' names, but I can't change the view name. Any suggestion? Thank you, Fabio Milheiro ...
I would like to copy a database (tables, it’s data, stored procs & views) from SQL Server 2008 database to SQL Server Express. Is it possible? If so, would you please let me know how to do it? When I tried, it is giving some error. Please note that I have only few records in SQL Server 2008 database tables. Thanks and Regards.. Shruth...
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 recreated the same set-up on another PC, I get the error in my NAnt script saying that: Syst...
I am trying to bootstrap SQL Server 2008 Express SP1 into my application. Previously I used Wise for Windows to perform the prerequisite installation, but Wise doesn't support Windows Installer 4.5 yet. I am now trying to use the Visual Studio 2008 bootstrap technology with WiX 3.0, and have had good success getting the SQL Server prer...
I'm currently using an ancient extended procedure -xp_smtp_sendmail to send mail from sprocs via localhost. Has anyone coded a way to achieve the same with a GoogleApps account? thx ...
How can I do usage-based perfromance optimization if I am running SQL Server 2008 Express and using SQL Server Management Studio Express? ...