Recent update: 2008-3-21
187 byte By
Olly at 2008-3-7
Hi everyone, I have an mdb file that I want to import using sql server 2005 express edition. I am using the Management Studio Express and have had no success. Thanks in advance
1525 byte By
Tailor at 2008-3-6
Hi, Background: I'm on a Pentium 2.4 with 1024 mb Memory and 160 Gb harddrive, running XPPro with SP2. I started a project in VS2005Beta2 with Sql2005Beta. When the RTM versions came along I ungraded to VS2005Pro, and tried to upgrade the SqlDeveloper. This ran amuck, but I could still access ...
417 byte By
neto at 2008-3-5
I'm trying to distribute an application but I face a little problem. I want to install the .net framework and SQL Server Express while my app installs itself in the host PC. Also I would like to let SQL server express prepared for remote conections, all of this in a single install project and ...
99 byte By
Bkl at 2008-3-3
From database explorer isn't possible obtain the result of a store procedure in a grid panel ?
Is there any way to have an automatic backup of a database in SQL Server Express?
2006-03-26 20:33:09.42 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.0 (Build 2195: Service Pack 4) 2006-03-26 20:33:09.42 Server (c) 2005 Microsoft Corporation. 2006-03-26 ...
897 byte By
neto at 2008-2-27
I'm developing with Visual Studio 2005 Standard Edition and SQL Server 2005 Express Edition, my problem is that as default SQL Server Express uses windows authentication. Since I develop in my own PC and install the software in another PC, my SQL Server Database is useless cause it still tries ...
2006-03-26 20:33:09.42 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.0 (Build 2195: Service Pack 4) 2006-03-26 20:33:09.42 Server (c) 2005 Microsoft Corporation. 2006-03-26 ...
897 byte By
neto at 2008-2-25
I'm developing with Visual Studio 2005 Standard Edition and SQL Server 2005 Express Edition, my problem is that as default SQL Server Express uses windows authentication. Since I develop in my own PC and install the software in another PC, my SQL Server Database is useless cause it still tries ...
2006-03-26 20:33:09.42 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.0 (Build 2195: Service Pack 4) 2006-03-26 20:33:09.42 Server (c) 2005 Microsoft Corporation. 2006-03-26 ...
Hi, This might be obvious - but if so I've missed it so far. Is it possible to connect remotely to an Express database used in a website which is created in the App_Data folder by VWDEE 2005 and attached by filename? As far as I can tell these databases don't have a name and aren't mounted ...
Hi, This might be obvious - but if so I've missed it so far. Is it possible to connect remotely to an Express database used in a website which is created in the App_Data folder by VWDEE 2005 and attached by filename? As far as I can tell these databases don't have a name and aren't mounted ...
Hi, This might be obvious - but if so I've missed it so far. Is it possible to connect remotely to an Express database used in a website which is created in the App_Data folder by VWDEE 2005 and attached by filename? As far as I can tell these databases don't have a name and aren't mounted ...
479 byte By
Hasan at 2008-2-21
Hello All; I downloaded the VWD2005 recentrly, it was really agiant achievement , i appreciate the people who developed such an easy-to-learn web development package. I noticed the difference between VS2002 and VWD2005. I really liked it. (i am sorry if this speech isn't in its right place). ...
I just installed sql server 2005 express and everything seemed to go well. However I only see the configuration tools under program files in the start menu. Any suggestions would be appreciated. Thanks!
2620 byte By
TonyN at 2008-2-20
I know allot of folks are having this problem and I tried lots of things but nothing works. I understand the problem is coping the SQL Express on another server is the problem - I just not sure what to do? Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET ...
Hi,I have install Microsoft Visual C# Express Editon 2005 from MSDN site. I have follow this step. Uninstall beta versions Before installing, you must uninstall any previous versions of SQL Server 2005, Visual Studio 2005, and the .NET Framework 2.0. 2. Download and install Download and ...
i have been working for a small time in VC#.Net application development... for the first time it was so that the database interaction was successfull when i sepcified the location to the attachdbfile name field... as "c:\temp\database1.mdf".but this cannot help as we move the application t...
894 byte By
Bkl at 2008-2-19
0) I've build on my pc a file MDF...i've used it and it's all right. Then I've decided to use it in LAN on pc-server to share it with my team. 1) The sqlexpress is installad on pc with XP sp2 (as server) 2) Tcp Ip is enabled. 3) Firewall is not running 4) The folder where is located the ...
I use Delphi 2006 to connect MS SQL Express 2005. When I save record, it shows the following error message: Database Server Error : Cannot create new transaction because capacity was exceeded. Does anyone know what happen and how to solve? Thanks!
425 byte By
AKazi at 2008-2-17
I am using Veritas backup exec 10.d with sql agent. I am able to see the sql express studio 2005 database files but there is difference in file size between original database file and the one shows in sql agent backup selection. The backup performs 100% successful but the original database file ...
Hi I have installed a single instance of SQLserver2005Express on a stand alone PC running WinXP Pro. Do you always have to be logged in as a Windows [XP] administrator to work with SQL Server databases? Because when I'm not it SQLserver Management Studio won't allow me to open any database. ...
Want a chance to show off a cool way you’re using Visual Studio Express or SQL Server Express?We’re looking for your stories!Tell us about something that makes your life easier or is just plain fun and if we like it enough to include in a feature article, we’ll give you a $100 gift certificate ...
Is it possible to stop the server from going to sleep when it is idle to improve responsiveness to new connections?
When trying to connect to sqlexpress, I get the rather uninformative error message: Error No. -2147217887Multiple-step OLE DB operation generated errors. Check each OLD DB status value, if available. No work was done. Here's the connection string I'm using: strDbConn = "Data ...
Because of numerous problems trying to get sqlexpress working, I uninstalled it with the intention of reinstalling (via Add or Remove Programs). However, now when I try to reinstall it, I get a message that the I am not making a changes so it won't let me install it. I do have sql server 2005 ...
173 byte By
JMicke at 2008-2-15
Is there a limit on how many <strong>concurrent </strong>users that can use SQL Server 2005 Express Edition? I haven't been able to find any facts about that
how can i change the view in sqlcmd? such as changing the font or the window size so that a command such as sp_tables will list on one row rather than several. Also I would only like to see 10 records or so at the same time. Currently in default setting, if i run sp_tables I can really only ...
Welcome to the SQL Express Forum Hello everyone and welcome to the SQL Express forum. One of the primary goals of the SQL Express MSDN Forum is to offer a gathering place for SQL Express users to share experiences, discuss issues related to SQL Express, ask questions and interact with the folks ...
Hello, We are building a smart client that ships with it an offline db - Sql Express. I wanted to check if there is a preferred/recommended approach to deploy the database ? I'm essentially asking between 1. Copying a database file and 2. Creating the database file by connecting to Master ...
Found out the hard way. Data does not get upsized from Access 2000 to Sql express 05. Just an FYI for anyone out there who might need to upsize Access 2000 Dbs.
354 byte By
DbHd at 2008-2-12
I must release a new Db on 4/1 into an isolated small network (pier workgroup) and my choices are MSDE or Express. I'm new to both (MSDE yesterday, Express today). I am familiar with SQL Server and prefer using the tools with Express, but is it stable enough to use in this type of production ...
Well I am not sure if I am doing something wrong but after having created a stored procedure I did the following. I hit the parse script button to check the script, it came back fine. I then executed the script which completed fine. But to my amazement the procedure did not show. I hit the ...
Is there a way in SQL 2005 Express Edition to import/export data from another MSSQL Server? Something similar to the right click/ import table functionality of MSSQL2000. I've read similar threads which all recommend using MS Access but there has to be a better way, right? regards,dj ...
Normally I'd go and write a bunch of code for doing it manually... But instead of that, maybe there is a smarter way? What I know is that you can get some kind of dump out of MySQL but I would be very surprised if that could be directly read into SQL Express ? So if you have a few step guide ...
I was looking for an import tool that will import text, excel and access files into sql server express? Does anyone have any suggestions? Thanks Tom
Hello, I would like to know whether is it possible to administer a database on a hosted site - i.e inserting some lines, executing a query. I normally access the files via ftp connection. And so far the only way I figured I can mess around with the database is to download it and change it on my ...
764 byte By
carlos at 2008-2-7
I have a computer_1 with sql 2005 express with app working fine, from another computer I want to connect to sql 2005 express in computer_1 using tcp/ip or named pipes, in computer_1 is enabled tcp/ip and named pipes, but when I connect using microsoft sql server management studio express I get ...
215 byte By
Meyyur at 2008-2-7
Question:</P> Can the SQL 2005 express edition can be installed on a machine that has more than 1 GB memory?</P> If so, is the SQL 2005 express edition will be using memory upto 1 GB?</P> </P> </P>
Is there any documentation on using full-text search with user instances? Is it even supported?
I am trying to attach a database as part of my overall application distribution. After installing Express when my .NET app first starts it atempts to attach the database using EXEC sp_attach_db etc... This used to work fine with MSDE 2000 but now the database is being attached as read-only. If ...
2617 byte By
Peter at 2008-2-6
When attempting to use VWD Express' built-in web server I recieve the following error in browser window: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server ...
Do MS SQL Express support Asian character set? If I want to input Traditional Chinese character, what collation I should use? Is there any limitation on the no of connect to MS SQL Express?
I just installed SQL Express in my workstation but when I try to create and ODBC connection, the new server does not show in the drop down. Do you have any tips...? Thanks.
Hi I am currently working on my final year project for uni using vs 2005, sql server express and xp pro sp2. Basically I created a website in asp.net and created a database in the app_data directory. Everything was working fine up until last week until I downloaded sql server management ...
Since SQL Express only runs on one CPU, is there a way to bind SQL Express to a particular CPU, or SQL Express only runs on CPU0? And in case of CPU hyperthreading, I assume that the CPU SQL Express running on will be a logical CPU, not a physical CPU, am I right? ...
1188 byte By
InteXX at 2008-2-4
I'm right-clicking on Data Connections in Server Explorer, and selecting Create New SQL Server Database. I've turned on the SQL Browser, so I'm able to select the instance from the combo box. I select Use Windows Authentication, type the database name to create, and click OK. I'm getting ...
I’m happy to announce the release to public CTP of the following SQL Express Family products: SQL Server 2005 Express Editions SP1SQL Server 2005 Express Edition with Advanced ServicesSQL Server 2005 Express Edition ToolkitSQL Server 2005 Management Studio Express (included as part of Express ...
I can't seem to open my SQL Server Management Studio Express CTP anymore. I need help figuring this out. I was able to open it before. I went to the Control Panel>Add/Remove Programs and tried to "repair" the program but nothing changes. Anytime I double-click on ssmsee.exe, the hour-glass ...
94 byte By
KBC at 2008-2-3
how I make to import some tables of a data base in Access to SQL server 2005 express edition?