Hello, i have an instance of SQL server 2008 and an instance of SQL server 2008 Express. i have been mainly using the SQL server 2008 instance with the following connection string... <add name="Local-DB-connection" connectionString="Data Source=JONATHAN-PC; Database=dbname; User ID=uname; Password=pword;" providerName="System.Data.Sql...
How to create new database with SQL Server Express 2008 without using Management Studio? Do i need to download sp1? ...
using :- sql servr 05 and vs08 c# website asp.net Okay, I have always used SQL Server 2005 Express and its Management Studio as a host and a design interface to create tables from design view only. All the queries, transaction, retrieval and anything needed during run time of the website is done using Visual Studio 2008 sql "connection ...
Hello, I have a virtual windows server with SQL Server 2008 R2 Express. for the last couple of days When I get up in the morning and check my site, its down, as the SQLEXPRESS service is stopped. I have never had this problem before and its very concerning. I have looked in the SQL server logs, under management but they offer no inform...
Hi all, I'm struggling to connect to my MS SQL Express 2008 edition from my PHP files, but it seems virtually impossible. I've found several guides/notes on teh intarweb solving the issues, but none of these have helped me any further. I've taken a script from another site and entered my database information, but I still get errors: ...
Hey, i want insert .bak in my asp.net project, how to use .bak file? I use ms sql 2008 express. ...
My connection string is like the following. It shows 'Timeout Exception' first time I run the application. But, for the subsequent run, it's ok. I think, it might take some time to attach the DB to the SQLExpress Server. Is there anyway to increase Timeout period? Thanks I am using SQLServer 2005 Express and VS 2008 and .Net 3.5. ...
Hello, I have developed a desktop application to be used on Windows Server 2003. It is using SQL Express for the database. I am using the following connection string: "Data Source=.\SQLEXPRESS;" + "AttachDbFilename=" + DBPath + ";" + "Integrated Security=True;" + "Connect Timeout=30;" + "User Instance=True" Here are the results I...
hi there it seems I can't find the option or the file with the setting to remove the Icon for the ATOM FEED export of the Report. I am using the SSRS version included in the MSSQL Express Advanced download. Is this the problem? Or do i have to configure this somewhere directly in the database? I read in another post that I should be a...
I am developing sample web application which use C#, and LINQ to SQL. The application is very very slow and it takes about 2 secs to navigate between pages. I have already used SQL Profiler and monitor the calls to the SQL server. All SQLs looks normal to me and their execution time is always about 1 or 2 millisecs. I tried the same ...
Hi, I'm trying to set up a CMS locally, using a MSSQL database. Ordinarily I do this on a live web server via a test domain, but I'd like to start developing locally rather than having to FTP things all the time. I have IIS running locally, which is fine, but am struggling big-time to get a SQL database running locally (more specifica...
I'm just starting out with SQL Server 2008 Express and spent the last hour or so trying out some basic queries. How does SQL scripting (correct term?) compare to general computer programming? Is writing SQL queries as involved, lengthy to learn, needs as much practice, etc. as software development? Is writing advanced SQL queries compara...
Hello, I'm new to C# with MSSQL, so I was wondering, what is the most reliable vs Easy method to connect my C# App to MSSQL to do the usual read/add/edit/update/delete ..... which path I should take? I just want a reliable way to do the work note: using VS2010 cheers ...
I have a lot of "cachestore flush" events on my production server of my web application. SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations. Its bound trees and 2 other things that are coming up on the event log....
I've written an app which bootstraps SQL Express 2008 with a Wix 3.5 installer, then attempts to CREATE DATABASE on first run of the app. The install of SQL Express is thus totally unattended. This all works fine when the account installing the app is an Administrator on the machine. However, somewhat unsurprisingly, problems arise whe...
Hi, Can someone please explain what is the main difference between SQL Server Compact Edition and SQL Server Express Edition? For what purpose I should use this or that one? Thanks ...
I installed SQL Server Express 2005 a few years ago. Since then I've installed Visual Studio 2008/2010 Express, which installed SOME SSE 2008 components on my machine (Management Objects). Now, I want to go back and install the SQL Server Reporting Server component (part of 2005 Express Edition Toolkit) into my 2005 installation. The ins...
I created a new login using Express Management Studio and SQL Server authentication. On create, the password changes to some long format automatically and I am not able to connect using the newly created user with the password I have set. What do I have to do to let it use the same password that I set and not tamper with it ? ...
I have messed up my asp.net membership authentication in SL4 Business applications by upgrading my development computer from sqlexpress to sql-standard. Here's how I did it: Installed win 7/64 bit, installed VS2010, installed Ria services on a new development computer. Upgraded SQL express to SQL standard (I invited problems by doing...
Oracle SQL Developer Version 2.1.1.64 Database created in MS SQL Server management studio 2008. computer name: server instance: sqlexpress DB name: equipment No security, or windows security I guess. what do I enter in the following sql developer fields: hostname, port, SID/service name. ...