I'm trying to port a database from SQL Server Express over to my MySQL database. I've made sure the SQL Express is running on port 1433 and all, and the MySQL Migration toolkit is even able to see the different databases/schemas I have in my SQL Server Express DB. The problem is that MySql Migration toolkit won't let me press "next" un...
I cant create a new db because there are only 2 logins: sa BuiltIn\Users I get permission denied when trying to create the db even though I am the admin. How can I add a user with permissions at this point or must I reinstall? ...
i just installed the full sql server 2008 express on my machine and i can't find any link to run enterprise manager: i went to here and installed the full package: http://www.microsoft.com/express/sql/download/ any clue or any suggestions to check what i may have missed? ...
It's my understanding that SQL Server 2005 does some sort of result or index caching. I'm currently profiling complex select statements which take several seconds to several minutes to complete. My problem is that a second run of a query never takes more than a second to run even if I don't alter it. I'm currently using SQL Server Manage...
Consider a SQL script designed to copy rows from one table to another in a SQL 2000 database. The transfer involves 750,000 rows in a simple: INSERT INTO TableB([ColA],[ColB]....[ColG]) SELECT [ColA],[ColB]....[ColG] FROM TableA This is a long running query, perhaps in part because ColB is of type ntext. There are a handful of CONVER...
I cannot get this to work. I have opened a SQL Server Express table in SQL Server Management Studio 2005. When I try to paste a multiline text snippet into an NTEXT field it gets truncated to only include the first line. In Access these kind of things works, what should i do? ...
I have a VPS with Windows Server 2008 R2, 1 GB RAM with Dual Processor Quad Core 2 CORES. My sample application is running slower than my current website on shared hosting, when I asked the reason the says following reason. "SQL Server Express tends to be slower compared to SQL Server Web edition. This is due to the limitations imposed...
I have already a website and moving that to the new VPS. I have option either to go with MySql database or Sql Server Express 2008 edition database (I do not want to pay for SQL Server as I can't afford as I have other expenses also). I have around 10K hits per day for my knowledge based website. My questions are If I go with ASP.NET ...
I want to be able to see all the queries that has been executed on the server last 2 days etc. see the script, date of execution, sender etc. is there any way? I am using SQL X 2005. ...
Hello, I'm experiencing a problem while working with all my projects. I don't get Intellisense with Linq2Sql and, when I write partial classes in the model folder, properties created by the Linq2Sql designer are not recognized by the partial classes. So, I'm trying to rule out all the possible sources of the problem. I have 2 cases: ...
Some days ago I posted a question on which component to use to make a MultiDatabaseWithJustOneComponent and i follow the general advice to use dbexpress. FirebirdSQL has date field, SQL Server 2008 has date fields too. But for some reason date fields are converted to TWideStringField, and when I'm trully confident that I've seen all e...
I have built a SQL Server Express database that is going to be housed on an external hd. I need to be able to add/update data on the database that is on my system, as well as other systems and then only backup or transfer data that has been added or edited to the external hard drive. What is the best way to accomplish this? ...
By default, when you create a local database cache using the wizard provided by Visual Studio 2008, it will create a SQL Server Compact edition database for you, and provide you synchronization capability between the cache and remote SQL Server using Sync Framework (1.0). This allow us to provide the offline capability in our client ser...
When I make a setup project in VS 2008, and select <Setup Project>, Properties, PreRequisites then i can select SqlExpress2005 to be automatically included. What I am looking for is a walkthrough of how to get SqlExpress2008 included in the same manner. Second choice would be how to get (or make) a MergeModule (MSM) file to do the sa...
Hey Guys, I'm trying to create a connection inside Oracle SQL Developer to a SQLExpress database I have Everything I have resides on the same machine so there isn't any network issues I should have to deal with but everytime I follow the instructions and I try to connect I get the following message "Failure - Unable to get informatio...
I am just back in the field after 5 years and am very rustly so please be patient. I am working on sql server express and I need to capture new/updated records(only parts of them actually) from a single table in order to insert into another table. (I will be using this other table as my data source for a crystal report.) I have no test...
Can I use SQL Server Express edition for commercial use? Can our clients redistribute SQL Server Express edition with their application? ...
I have a web app that I am working with on a separate server. I didn't originally create it, but I have to maintain it. I had to to do some manual editing of one of the database tables, which I did through Visual Studio 2008 installed on the same machine. Now I get SQL exceptions regarding Network Service not having the right privileges....
The MSDN documentation for SQLEXPRESS says: When an application first establishes a connection from a running instance of SQL Server Express, SQL Server Express will automatically attach an .mdf file. When the user closes the application, SQL Server Express detaches the .mdf file from the instance. This does not appear to be happe...
This seems like a silly question, but it has me stumped. When setting up a new Database in SQL Server Management Studio Express (for a SQL Server 2005 Express DB) you pick a default owner. When you create a new Login in it, you pick a default database. Wouldn't the owner of the DB also be a 'login'? Or am I confusing those two concep...