Hi all. The purpose is to handle the user's data (you can call them project, document, file, or whatever) in a brand new SQL Server 2008 Express database. The data are expected to occupy much less space than the 4GB available with the express edition (which is also free to distribute). E.g., each time the user selects File->New command...
Bunch of Inserts (transaction) is quicker than each insert separatelly, i think so, maybe not, tell me who check, is there a difference, maybe if many indexes on a table. ...
i want to practice connecting from asp.net to a sql server database. i have it in mdf file. please help me. what is the next step? i got the sample mdf database from here: http://msftdbprodsamples.codeplex.com/releases/view/37109 ...
When using SQL Server Express 2005's User Instance feature with a connection string like this: <add name="Default" connectionString="Data Source=.\SQLExpress; AttachDbFilename=C:\My App\Data\MyApp.mdf; Initial Catalog=MyApp; User Instance=True; MultipleActiveResultSets=true; Trusted_Connection=Yes;" /> We find that we can't ...
I'm building an application to import data into a sql server 2008 Express db. This database is being used by an application that is currently in production. The data that needs to be imported comes from various sources, mostly excel sheets and xml files. The database has the following tables: tools powertools strikingtools owners Ea...
I'm playing with the Output keyword in SQL Serer 2005 Express. I've written the following query: Declare @tempTable as Table(masterLotDB datetime) Insert into dbo.tblMasterLot (RecordCreation) Values ('2009-10-02') OUTPUT INSERTED.RecordCreation into @tempTable I get a syntax error of Msg 102, Level 15, State 1, Line 6 Incorrect syn...
Hey, I can`t connect SQL Server Express 2008,I downloaded and installed SQL Server 2008 Express 64Bit, Microsoft SQL Server Management Studio. And I can`t connect to the SQL Server, I tried those options 1.Disable the firewall 2.Restart the SQL Server Service at Sql Server Configuration Service , I have two services that dosen`t worki...
Hi, I'm using VB 2008 Express for our College Project. I'm also running SQL Server 2008 Express and have installed SQL Server Management Studio and used it to create my database. Both software have been installed and running locally. I'm trying to connect to the database from VB 2008 Express. Database connection wizard have 3 options: ...
I'm working on a C# windows program with Visual Studio 2008. Usually, I work from school, directly on my usb drive. But when I copy the folder on my hard drive at home, an sql exception is unhandled whenever I try to write to the database. it is unhandled at the conn.Open(); line. here's the exception unhandled Database 'L:\system\pr...
I'm having a terrible time exporting SQL Server Management Studio Express tables to the Go Daddy webserver. Go Daddy support can't help either. I started by using Microsoft Database Publishing Wizard for SQL Server thinking it would be 'easy'....not! I ran into user/password errors even though I was using the user and password that wa...
I would like to create the ASP.NET User database template on a database of my own, because I'd like to fully untegrate the user system with the rest of my DB. As I've read, i needed to use the aspnet_regsql tool. I put all the options (because my database is running on SQLEXPRESS and is in an mdf file in my project's folder). the program...
I have just downloaded SQL Server 2005 express edition from here: To be used as a database for a vb.net program. But I'm confused in using sql server. I do not know where to start from here: http://screencast.com/t/ZTdiMDU5 Do I have to create the database in vb.net?--> http://screencast.com/t/ZjRlYjkx If not, where could I create...
I want to restore a database backup existing beside the application in setup time. I have custom action and in the install method need to restore the database with the backup file. When I use SQL Server 2008 Express edition I got error. please help me. ...
Can I create a table without any columns in SQL Server by t-sql? ...
The question is probably extremely easy to resolve, but I need to resolve it because I need to carry on with my project. I am using SQL Server Express 2008 at home, and I've been working on an ASP.NET MVC app that stores my DB in an mdf file in the project's folder. The problem is that the SQL Server in the Uni labs is SQL Server 2005, a...
Can I deploy SQL Server Express with my desktop application just like builtin database? Because I don't want my client to set up separately SQL Server Express! Is it easy to integrate SQL Server Express into my desktop application ? ...
Is the max limit of 4 GB on sql server 2005 express .mdf + .ldf or for .mdf only ? Kindly clarify. Thanks. ...
I'm putting together a simple test database to learn MVC with. I want to add a DateTime field to show when the record was CREATED. ID = int Name = Char DateCreated = (dateTime, DateTime2..?) I have a feeling that this type of DateTime capture can be done automatically - but that's all I have, a feeling. Can it be done? And if so how?...
I'm bundling an application for distribution and SQL Server is a prequisite so we're including SQL Server Express. What's the easiest way to include SQL server in a point and click installer? In the past I've used NSIS, but it was always flaky when installing the .NET Framework, so .NET, SQL Server and our app seems like an impossible ta...
I am using SQL Server 2008 express and i want to import .mdf and i get this error: .mdf version is 661, your db supports the version 655 Which version is 661 and how to import it in sql Server 2008. ...