SQL Server 2000 Drive selection




 I have a software package (Pinnacle Studio 10) that installed a SQL Server 2000 database. When I first loaded the SQL software on the C drive it created a database on the D drive. I now need to create a database (or move the database) to a new H drive. How can I do this? Can I change the swap the drive designation D to H and H to D?

I am running Windows XP home.
Open SQL Enterprise Manager and expand the Databases tree. Right click on the database name and select All Tasks, then select Detach Database. Move the physical files from the D drive to the H drive. Right click on databases and select All Tasks > Attach Database. Browse to the new location and select the mdf file. Click OK, then OK again (you may need to correct the path to the log file).
you might be able to use synchronize. if you have more than 2 tables, you will need to use it multiple times. hi there floriann software,

first of all, i would say that it is always a better idea to open up a new thread, instead of engaging in an old one.

apart from that, as the drive is recognized on other systems except for the xp one, then it comes to drivers. make sure you go to the mobo's website and update the drivers.
is the drive initialized as mbr. in case it is initialized as gpt, i would advise you to back up all the data and initialize it as mbr. win xp has some limitations on that: https://support.microsoft.com/en-us/kb/2581408

cheers,
d\_know\_wd :) If you're unsure of writing joins in SQL use an SQL builder.


Top of my list is still SQLeo which is java based. If you make a small donation you get the full thing, you only need to donate a dollar.


Others are navicat but they have a trial not sure if it is only available to windows either. Try to xcopy the data over to the external drive.



start>run>type "cmd">hit ok  

In dos window type "xcopy /?" this will show you all of the parameters or switchs used in xcopy.



If you are not famaliar with dos you may want to seek out a friend who is. You can provide an optional parameter to the scaffolding command to update only the table you target.



```
Scaffold-DbContext "Server=(localdb)\mssqllocaldb;Database=DatabaseName;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir DirectoryNameOfYourModels -Tables employee -f

```

If you are using .net core cli then use.



```
dotnet ef dbcontext scaffold "Server=(localdb)\mssqllocaldb;Database=DatabaseName;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -o DirectoryNameOfYourModels -t employee -f

``` yes you add second as a slave drive, boot from one that has os, second has data. access thru my computer for second one. well, transferring your data and transferring that and your settings are different. data, such as music, letters, video, pictures can burn to disk or copy/move to external drive. installed applications won't go, you'll have to reinstall from disk or download. on the other hand, you can transfer settings, favorites etc. use files and settings transfer wizard. or laplink software and cable. Hi  

This is simple. First check whether you are able to connect Sql Server through SSMS or not.If you are able to connect through SSMS, then there may be a problem in connection string. If you are not able to connect through SSMS, then you had some problem with SQL Environment. hi, @ricky007 
create table bill\_stag
(
s\_categry varchar2(20),
s\_billnum varchar2(20)
);

insert into bill values('1111','5647859541785');
watch out! you're using two different table names there.
you don't care which m\_billnum\_seq gets assigned to which new row, do you? (you shouldn't.) in that case, you can simplify the cross join approach that cormaco suggested like this:
insert into bill\_mast (m\_bill\_seqnum, m\_billnum, channel) -- always name the columns
with  all\_channels  as
(
 select 'mob' as channel  from dual  union all
 select 'atm'      from dual
)
select  seq\_num.nextval
, s.s\_billnum
, c.channel
from     bill\_stag    s
cross join all\_channels c
;
you don't need order by, so you don't need the ord column and you don't need so an extra sub-query. Hello Nanda, Basically you need to include the network drivers and the storage drivers.

+ You can find the drivers from Manufacturer site where you can filter the Category and download –

Like this – <https://snipboard.io/bQt5ER.jpg>