473,480 Members | 2,271 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Cannot attach mdf file named master

15 New Member
Hi,

I have some mdf files from a legacy system that I am trying to access. I have done this before by attaching them to an instance of SQL Server in MS SQL Server Management Studio. This new set of mdf files happens to have the same naming scheme as the system databases that are standard templates in SQL Server Management Studio (master, model, etc.)

When I try and attach the legacy mdf file named master I receive an error saying that a database with that name already exists. If I rename the file on microsoft explorer and then try to attach the 'original file name' of master is displayed in the attach database dialouge box and I still receive the same error.

All of the things I can find online about this refer to using a query in SQL Server Management Studio to update the name of an attached database, but I cannot attach this to update the name.

Any suggestions would be greatly appreciated.

Thanks!

Joe
May 18 '12 #1
0 1394

Sign in to post your reply or Sign up for a free account.

Similar topics

9
715
by: Paul | last post by:
Hi, VB.NET is saying the file I am creating is in use by another process and won't complete its task of moving the file to the specified destination folder. Here is my code (the main bit...
1
1831
by: ohb | last post by:
Hello, is someone have a example of c# source of a service which is reading a attach file of an email.? Thank you. OHB.
2
1752
by: ohb | last post by:
Hello, Is it possible to parse a attach file in a email ? ohb
4
1730
by: donall | last post by:
i have a DLL which implements a HTTP handler, written in C#, and have deployed it on IIS 5.0, on XP service pack 2. six months ago, i was able to debug it by attaching CLR to the process...
2
1289
by: Ponnurangam | last post by:
Hi, I need to check whether a file named flower exists with different extensions. I know only file name. I don't the the extension(may be .bmp, .ipg, or ..gif). And if there are files with...
0
5716
by: mohammadkashif | last post by:
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately. ...
0
1664
by: KingKong07 | last post by:
Hi! I have a problem with publishing my solution. I use “Use fixed naming and single page assemblies” to publish. So I just can update one and one file, this works fine, but today I had to update...
7
2719
by: RRsonawane11 | last post by:
Hello, Can anyone know how to write asp code to attach one file and email it to a specified email address. The attach file is the client choose from their Local Harddisk, just like we ...
12
6856
by: Anna Smidt | last post by:
Hello again, I am trying to convert a VC6 project to VC9, and the linker tells me that it cannot open file 'LIBC.lib'. But I didn't find this lib referenced or added anywhere. I used the linker...
1
1594
by: JOHNSHELL08 | last post by:
A file named Index.dat is always present in cookies when user write cookies in run dialog box. so i want to know which kind of file is it. & why its is created by default & it's not deleted .
0
7050
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,...
0
7091
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...
0
6966
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5344
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,...
1
4787
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...
0
4488
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...
0
2999
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
2988
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
185
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.