Topic profile page for SQL Server Express.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: SQL Server Express.
Topic "Sql server express" was discussed 2,353 times on 218 sites in last 3 months
Started 2 days, 17 hours ago (2009-11-30 19:24:00)
by James Shao
I work with both SQL Server Express 2008 and Microsoft Visual Web Studio Express 2008. However the two programs don't seem to be "in sync" properly. Probably this is because I set up the database wrong, but I'm not sure. I first add a new database and a table in VWD (Visual Web), which creates two files, a MDF and a log file under Documents\VisualWebStudio2008Express\Websites\Webs ite\APP...
Started 2 days, 17 hours ago (2009-11-30 19:00:00)
by Stortman
I cannot install SQL Server 2008 Express because "SQL Server Express 2008 with Service Pack1 is incompatible with Microsoft Server Express 2005". I have tried using the Web Platform Installer v2.0 but get this message. I have also tried using Windows Installer v4.5 after installing Windows Powershell v1.0 but without success . Setup reports "Restart computer" failed. I have Win XP Pro sp3 ...
Started 3 days, 4 hours ago (2009-11-30 08:41:00)
by jburnard
Hi Folks, I've been jumping from site to site trying to find a solution for this and still no luck. I have tried this update many times but it always fails. I have the results of the installation log here if it helps. I am on HP hardware using XP. Any help is most appreciated. Thanks for reading! Time: 11/30/2009 06:25:09.718 KB Number: KB955706 Machine: BOULDERMAIN OS Version:...
Started 3 days, 19 hours ago (2009-11-29 17:19:00)
by Joe_newman
Hi, I've just installed SQL Server express on my Windows 7 PC but I can't find an icon anywhere to actually run it. All I have on the start menu are "Import and Export data" and "Configuration tools". Any suggestions please? Thanks
Hi! I have a .net application which communicates with a webbased server database provided by SQL Server Express 2005. This databse has to be synchronized a couple times a day with a local database server (als sql sever express). I started looking at replication, but since sql server express cannot be a publisher, this will not be an option... I have looked into Microsoft ...
> Hi! I have a .net application which communicates with a webbased server database provided by SQL Server Express 2005. This databse has to be synchronized a couple times a day with a local database server (als sql sever express). I started looking at replication, but since sql server express cannot be a publisher, this will not be an option... I have looked into ...
Started 1 week ago (2009-11-25 16:50:00)
by Brian Conner
I have a couple files I am trying to import into SQL Server Express 2008 that are in RPT File Format. Apperantly someone just executed a Query to File. The Folder they are stored in is read only so I can't rename to .txt. Does anyone know how I can import these files? When I use the Import Wizard I can't get the files to Delimit properly, It looks like tab delimited but that doesn't work. ...
Started 1 week, 1 day ago (2009-11-25 09:26:00)
by Brian Conner via SQLMonster.com
I have a couple files I am trying to import into SQL Server Express 2008 that are in RPT File Format. Apperantly someone just executed a Query to File. The Folder they are stored in is read only so I can't rename to .txt. Does anyone know how I can import these files? When I use the Import Wizard I can't get the files to Delimit properly, ...
Started 1 week, 1 day ago (2009-11-24 22:23:00)
by dave_skin
I am thinking of upgrading from Access to SQL Server Express but in surfing around I see many have problems finding the correct connection string. My Access databases are only used as "property stores" for ASP generated pages and as such really only function in a "read" mode when accessed from my website scripts, so minimal security is required. The current connect strings I use for Access ...
Started 1 week, 1 day ago (2009-11-24 17:23:00)
by dave_skin
I am thinking of upgrading from Access to SQL Server Express but in surfing around I see many have problems finding the correct connection string. My Access databases are only used as "property stores" for ASP generated pages and as such really only function in a "read" mode when accessed from my website scripts, so minimal security is required. The current connect strings I use...
Started 1 week, 1 day ago (2009-11-24 14:22:00)
by dave_skin
I am thinking of upgrading from Access to SQL Server Express but in surfing around I see many have problems finding the correct connection string. My Access databases are only used as "property stores" for ASP generated pages and as such really only function in a "read" mode when accessed from my website scripts, so minimal ...
Started 4 days, 10 hours ago (2009-11-29 02:21:00)
by javelin
I have had SQL Server 2005 Express installed on another system and it appeared when running the Data source configuration wizard. Now, with 2008, it doesn't show up there, nor in the ODBC manager when trying to create a new SQL Server data source. It's getting frustrating, but I don't know what too do. Please advise if you can. Thanks in advance!!! J
Started 5 days, 6 hours ago (2009-11-28 06:47:00)
by dvdavid2001
Hi guys, I have a strange problem in my SQL Server 2005 Express Edition. I am using Express Edition with Advanced Services SP3 with one table was full-text indexed. The table is rather huge and it is around 1.8 GB in size. Everything was okay, the population was successful and the state of the full-text index is working normally. -- Return state of 5 which is working normally select * ...
Started 4 days, 20 hours ago (2009-11-28 16:09:00)
by Jim0717
I have attempted to load Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) several timese but it just comes back and says it failed. Any ideas what is wrong. I am running XP SP3
Started 2 days, 23 hours ago (2009-11-30 13:27:00)
by Johan Kwaspen
Dear, When I install SQL server 2008 express after extracting gifs its an error Native SQL Install Bootstrapper Does not work any more Is this a 64 bit problem ? (in 32 bit runs the install perfect) Nice to know: Windows7 Pro 64 bit (clean install) File to install : SQLEXPRWT_x64_ENU.exe Disable Virusscanner Thanks for advice!! Johan
Started 1 day, 12 hours ago (2009-12-02 00:00:00)
by magicalclick
I need to define my own keywords in the SQL schema. And I need to translae my own queries, keywords, using terms defined in schema to SQL queries. Basically I need to extend SQL to my own stuff. If it can be done on Express, I will do that. So, is it possible? And how do I do that? Any reference? If not, I will resort to MySQL, but, I prefer to give Express a try first. Thanks.
Started 2 days, 6 hours ago (2009-12-01 06:23:00)
by ChunSong Feng -MSFT
Hi Joe, Like Lek said, you need to install SQL Server Management Studio to connect the SQL Express database engine service. Which version of Express Edition, 2008 or 2005, you can download corresponding version of Management Studio from Microsoft Download Center . Hope this helps
Started 2 days, 10 hours ago (2009-12-01 02:33:00)
by James Shao
Thank you Ted, though I'm still confused about why in SQL Server Management Studio, it shows that it's pointing to the database under the VWD folder rather than the C:\ folder, and when I delete the files in the C:\ folder, I don't see them anymore in SQL Server Management Studio?
