473,804 Members | 3,074 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL Server Express, manager and production ....

Hello,

I created a SQL server 2005 (express) database from the VS2005.
I can create table and so one.

To manager the database, it's easier use "SQL Server Manager Studio" but
it's impossible to attach because the path is :
C:\Documents and Settings\MeMy Documents\Visua l Studio
2005\WebSites\W ebSiteTest\App_ Data

Then I make a copy to C:\ but impossible to attach because the DB is
readonly.

If I can attach the right way it's make the change and copy to
C:\Documents and Settings\MeMy Documents\Visua l Studio
2005\WebSites\W ebSiteTest\App_ Data

Last question, to put the web site in production the database have to be in
/App_data or in the SQL Server data folder ?

Best Regards,
Mar 12 '07 #1
0 932

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

48
3734
by: ik | last post by:
ERROR after uninstalling SQL Server 2005 Express I get this message, SQLDMO has not been registered. Please re-run your setupand contact your system administrator. GREAT!!! ReInstalled SQL SERVER 2000 after playing around with SQL Server 2005...
5
1658
by: RDV | last post by:
I have 2 SQL Server Express questions: 1) Can you manage a SQL Server Express installation from the regular SQL Server Enterprise Manager? I am getting a message that says "SQL Server does not exist or access is denied" when I try to register the SQL Server Express instance via Enterprise Manager. If this is possible, what kind of things should I be looking for to make this work?
3
2603
by: yoda | last post by:
Hi Guys, I've been used to deploying code to the production server by checking out of subversion and manually sorting out any kinks. (yes, I know, it sounds primitive) I realize I'm losing so much time I could spend more productively. I'd therefore like to know the different approaches you guys employ to deploy builds from your staging servers (or laptops:) to the production server in an automated repeatable safe manner.
0
4548
by: Zorba.GR | last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 , other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM , other IBM WebSphere Business CDs...
32
2535
by: dreadnought8 | last post by:
I have a client who wishes to upsize an A97 system from Jet backend to SQL Server 2000. They have up to 4 users. Will they need to buy the minimal 5-seat SQL Server product, or would it be cheaper to upsize the front end to A2K, A2K2 or A2K3 and use the version of SQL Server provided with that? The system uses local tables extensively and I would not want to disturb this. Enterprise manager would be a requirement. TIA
3
491
by: Marc | last post by:
Here is a new error I am getting. I have a development computer (Server 2000, SQL2000, .NET 1.1) I have a production computer (Server 2003, SQL2000, .NET 1.1) When I run my solution on the development box pointing to the database on the development box - no problem. When I run my solution on the production box pointing to the database on the production box - no problem. When I run my solution on the production box pointing to the...
2
9013
by: hfk0 | last post by:
Hello, I'm a newbie here and was wondering anyone could help me with this. I have a simple ASP.NET 2 web application running perfectly fine with IIS and SQLServerExpress installed locally on my WinXP as a testing server (I created the app in Visual Studio.NET 2005). When deploying this app on the production server (running Win2000 Server, IIS and SQLServerExpress 2005), I'm getting the following
2
10875
by: thersitz | last post by:
Hi, I have VStudio2005, SQLServer 2005 dev edition loaded on a windowsXP Pro machine. I installed it ok. I just attempted to load the Personal Web Site Starter Kit (I downloaded off Microsoft's site) to use with VStudio 2005 -- Installing it from the MS site failed without any error messages. When I used VSTudio to open, it loaded ok, but when I went to view the default.aspx page I got this error:
2
2851
by: Robert | last post by:
I'm a newbie trying to find the SQL Server Enterprise Manager so I can create a database. I have installed SQL Server 2005 Express and SQL Server Management Studio Express. On the SQL Server menu I see (1) Configuration Tools and (2) SQL Server Management Studio Express. The SQL Server Management Studio Express menu has 3 items on it. Where do I find the Enterprise Manager? Robert
0
9704
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9569
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10558
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10318
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10302
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9130
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7608
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6844
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4277
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.