I have a legacy VB6 application that was built using MSDE. As many client's database grow towards the MSDE 2 GB limit they are upgraded to SQL 2005 Express. This has proven very successful until today. I have spent the entire day troubleshooting a client's network on which our application runs unacceptably slowly, when connecting the ...
Looking for a way to programatically, or otherwise, add a new instance of SQL 2005 Express Edition to a system that already has an instance installed. Traditionally, you run Micrsoft's installer like I am in the command line below and it does the trick. Executing the command in my installer is not the issue, it's more a matter of dragg...
I am developing a website using SQL Server Express on my development machine. My web hosting company is providing me with SQL Server 2005. At the moment all I have is a database that I develop with and a database that is on the live server. I do not have the original scripts to generate the schema but I can auto generate the create scri...
I'm having the problems described in KB937745 - very high CPU usage and the Application Log is reporting something like this: The client was unable to reuse a session with SPID SPID, which had been reset for connection pooling. I've downloaded the hotfixes and I can't run them - I suspect it is because SQL Server 2005 Express Edition ...
I'm attempting to help our network engineers troubleshoot a situation for one of our clients. This client purchased a point-of-sale system from quite literally a "mom-and-pop" vendor, and said vendor recommended SQL Server Express 2005 as the back-end database to save the client from having to incur extra licensing fees. (Please don't ge...
Is there anyway to change the ASPNETDB and also using SQLExpress (2005) user instance ? I have changed my web.config's connectin string to <remove name="LocalSqlServer"/> <add name="LocalSqlServer" connectionString="Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDirectory|\Kooft.mdf; User Instance=true; Integrated...
I have a 64bit Vista laptop. Initally, I tried to Install a 64bit version SQL Server Express 2005 on my computer, but no matter what I tried, only the 32bit version seemed to work...so that is what got installed. The 32bit SQL Server Express 2005 was working fine, but recently I installed a 64bit version of SQL Server Express 2008 - wi...
I'm trying to install SQL Server 2005 Express SP3 on two of my machines. When I try to do this I get this error message: "None of the selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine. To continue, click Back and then select features to install." And of course it w...
I have this code, running parallel in two separate threads. It works fine for a few times, but at some random point it throws InvalidOperationException: The transaction is either not associated with the current connection or has been completed. At the point of exception, I am looking inside the transaction with visual studio and verify...
I've got a problem on an SQL Server 2005 Express instance, and I need to see exactly what is being run, since what I believe is being run works fine when I run it from Management Studio. It appears that Profiler is not available for SQL Server 2005 Express. When I attempt to run SQL Server 2000 Profiler against the 2005 Express edition...
Hi All, I have this problem which I am trying to debug for a lot of time. The setup is like this: i. The application is a Windows application developed using VS2005, .net 2.0. ii. I use the Cyrstal reports component Crystal Report Viewer and dynamically display various reports in the same form. iii. The db is SQLSERVER Express 2005 ...
Does anybody know of a free utility that I can use to view the contents of fields containing binary data in an MS SQL Server 2005 database? ...
Hellow , I am Ma'moun , Please I Need Help in this Web Site I attach it in this Mail , I use(ASP.Net 3, SQLSERVREQPRESS) I develop a Web Site For a school , The Web Site has a page (Exams.aspx) wehen that page load the dataGrid will fill all student mark from table(dbo.Marks) The table (dbo.Marks) get its own Mark from (dbo.Exams) , ...
I have the following scenario: Our system is running a SQL Server Express 2005 database locally (on each users desktop, if you will). The system is storing a lot of production data from a machine. There are high demands on the safety of the data, and doing a backup each night, or even each hour is not enough. We need a backup strategy t...
Is there any way to install SQL Express 2005 silently while configuring to allow remote access, or must the configuration be done with the SQL Server Management Studio UI? ...
Hi We have a asp.net 3.5 web application running on a hosting company's web server that's got a very strict firewall setup. The web application communicates with our sql server express 2005 which is on a completely different network. The problem is that the web applications sends our sql server a random port number to connect to when ...
Hello gurus, In MS SQL Server Management Studio Express, is there a way to set the default author name to my name when I create a stored procedure by right clicking on the "Stored Procedures" folder under "Programmability" folder? It would save me a lot of time if I don't have to keeping updating it whenever I create a new stored proce...
I'm looking for a simple tool, preferably one that I can redistribute with my application, that non-technical end-users can use to add users (and logins if necessary) to a particular SQL Server (Express) database. Obviously SSME will do the job, but I don't want to require users to install something so heavy-weight. I have a good idea...
Hi, i want to use profiles and was able to use aspent_regsql -A p to install the tables. I can see them throught SQL management studio. Im actually using SQLExpress 2005, and my dbo.aspnet_SchemaVersions is populated. Does anybody know what could be going wrong? By the way, im preety sure my connection string and app code are allright...
I've got a trio of Windows servers (data1, data2 and datawitness) that aren't part of any domain and don't use AD. I'm trying to set up mirroring based on the instructions at http://alan328.com/SQL2005_Database_Mirroring_Tutorial.aspx. I've had success right up until the final set of instructions where I tell data1 to use datawitness as ...