Showing posts with label pubs. Show all posts
Showing posts with label pubs. Show all posts

Sunday, March 25, 2012

can't attach 2 sample files can attach other files

I got SQL Server 2007 Express configured and I ran a few queries. It
appears to be configured correctly. I am trying to attach the
Northwind and Pubs example files from SQL Server 2000. I have tried
more than several times to attach them. I have them in the data file
of SQL Server 2007 express. The files are not read only. I looked
in the permissions and they were but I changed it to writeable and
checked the other files the log file and such.
When I try to attach the files I get the error message "Database
Northwind cannot be upgraded because it is read only or has read only
files. Make the files writeable and re-run recovery".
What is recovery? Do the files have to be upgraded from SQL SErver
2000?
thanks,Hi Janis,
Is that SQL Server 2005? (There is no SQL Server 2007). Have you changed the
permissions of both data and log files?
You could also try this
Northwind and pubs Sample Databases for SQL Server 2000
http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en
Hope this helps,
Ben Nevarez
"Janis Rough" wrote:
> I got SQL Server 2007 Express configured and I ran a few queries. It
> appears to be configured correctly. I am trying to attach the
> Northwind and Pubs example files from SQL Server 2000. I have tried
> more than several times to attach them. I have them in the data file
> of SQL Server 2007 express. The files are not read only. I looked
> in the permissions and they were but I changed it to writeable and
> checked the other files the log file and such.
> When I try to attach the files I get the error message "Database
> Northwind cannot be upgraded because it is read only or has read only
> files. Make the files writeable and re-run recovery".
> What is recovery? Do the files have to be upgraded from SQL SErver
> 2000?
> thanks,
>|||On Jan 30, 7:10 pm, Ben Nevarez
<bneva...@.no.spam.please.sunamerica.com> wrote:
> Hi Janis,
> Is that SQL Server 2005? (There is no SQL Server 2007). Have you changed the
> permissions of both data and log files?
> You could also try this
> Northwind and pubs Sample Databases for SQL Server 2000http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-035...
> Hope this helps,
> Ben Nevarez
> "Janis Rough" wrote:
> > I got SQL Server 2007 Express configured and I ran a few queries. It
> > appears to be configured correctly. I am trying to attach the
> > Northwind and Pubs example files from SQL Server 2000. I have tried
> > more than several times to attach them. I have them in the data file
> > of SQL Server 2007 express. The files are not read only. I looked
> > in the permissions and they were but I changed it to writeable and
> > checked the other files the log file and such.
> > When I try to attach the files I get the error message "Database
> > Northwind cannot be upgraded because it is read only or has read only
> > files. Make the files writeable and re-run recovery".
> > What is recovery? Do the files have to be upgraded from SQL SErver
> > 2000?
> > thanks,
sorry, it didn't help, I got the Northwind 2000 sample file. I didn't
know the latest version was 2005, so that was helpful, however, I did
change the permissions for all the files, the log file and the mdf
files. They still won't attach.|||On Jan 31, 8:16=A0am, Janis Rough <jlro...@.yahoo.com> wrote:
> On Jan 30, 7:10 pm, Ben Nevarez
>
>
> <bneva...@.no.spam.please.sunamerica.com> wrote:
> > Hi Janis,
> > Is that SQL Server 2005? (There is no SQL Server 2007). Have you changed= the
> > permissions of both data and log files?
> > You could also try this
> > Northwind and pubs Sample Databases for SQL Server 2000http://www.micros=
oft.com/downloads/details.aspx?FamilyID=3D06616212-035...
> > Hope this helps,
> > Ben Nevarez
> > "Janis Rough" wrote:
> > > I got SQL Server 2007 Express configured and I ran a few queries. It
> > > appears to be configured correctly. =A0 I am trying to attach the
> > > Northwind and Pubs example files from SQL Server 2000. =A0 I have trie=d
> > > more than several times to attach them. =A0I have them in the data fil=e
> > > of SQL Server 2007 express. =A0 The files are not read only. =A0I look=ed
> > > in the permissions and they were but I changed it to writeable and
> > > checked the other files the log file and such.
> > > When I try to attach the files I get the error message "Database
> > > Northwind cannot be upgraded because it is read only or has read only
> > > files. Make the files writeable and re-run recovery".
> > > What is recovery? =A0Do the files have to be upgraded from SQL SErver
> > > 2000?
> > > thanks,
> sorry, it didn't help, I got the Northwind 2000 sample file. =A0I didn't
> know the latest version was 2005, so that was helpful, however, I did
> change the permissions for all the files, the log file and the mdf
> files. =A0They still won't attach.- Hide quoted text -
> - Show quoted text -
Hi Janis,
There is no need to attach the northwind or pubs dbs . There are
scripts like instnwnd.sql which will configure the northwind db for
you . Just execute the script.
and don't try to attach the db from higher version to lower
version...!
Thanks
Ajay|||On Jan 30, 11:10 pm, Ajay Rengunthwar <aju...@.gmail.com> wrote:
> On Jan 31, 8:16 am, Janis Rough <jlro...@.yahoo.com> wrote:
>
> > On Jan 30, 7:10 pm, Ben Nevarez
> > <bneva...@.no.spam.please.sunamerica.com> wrote:
> > > Hi Janis,
> > > Is that SQL Server 2005? (There is no SQL Server 2007). Have you changed the
> > > permissions of both data and log files?
> > > You could also try this
> > > Northwind and pubs Sample Databases for SQL Server 2000http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-035...
> > > Hope this helps,
> > > Ben Nevarez
> > > "Janis Rough" wrote:
> > > > I got SQL Server 2007 Express configured and I ran a few queries. It
> > > > appears to be configured correctly. I am trying to attach the
> > > > Northwind and Pubs example files from SQL Server 2000. I have tried
> > > > more than several times to attach them. I have them in the data file
> > > > of SQL Server 2007 express. The files are not read only. I looked
> > > > in the permissions and they were but I changed it to writeable and
> > > > checked the other files the log file and such.
> > > > When I try to attach the files I get the error message "Database
> > > > Northwind cannot be upgraded because it is read only or has read only
> > > > files. Make the files writeable and re-run recovery".
> > > > What is recovery? Do the files have to be upgraded from SQL SErver
> > > > 2000?
> > > > thanks,
> > sorry, it didn't help, I got the Northwind 2000 sample file. I didn't
> > know the latest version was 2005, so that was helpful, however, I did
> > change the permissions for all the files, the log file and the mdf
> > files. They still won't attach.- Hide quoted text -
> > - Show quoted text -
> Hi Janis,
> There is no need to attach the northwind or pubs dbs . There are
> scripts like instnwnd.sql which will configure the northwind db for
> you . Just execute the script.
> and don't try to attach the db from higher version to lower
> version...!
> Thanks
> Ajay
Thanks,|||On Jan 30, 11:10 pm, Ajay Rengunthwar <aju...@.gmail.com> wrote:
> On Jan 31, 8:16 am, Janis Rough <jlro...@.yahoo.com> wrote:
>
> > On Jan 30, 7:10 pm, Ben Nevarez
> > <bneva...@.no.spam.please.sunamerica.com> wrote:
> > > Hi Janis,
> > > Is that SQL Server 2005? (There is no SQL Server 2007). Have you changed the
> > > permissions of both data and log files?
> > > You could also try this
> > > Northwind and pubs Sample Databases for SQL Server 2000http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-035...
> > > Hope this helps,
> > > Ben Nevarez
> > > "Janis Rough" wrote:
> > > > I got SQL Server 2007 Express configured and I ran a few queries. It
> > > > appears to be configured correctly. I am trying to attach the
> > > > Northwind and Pubs example files from SQL Server 2000. I have tried
> > > > more than several times to attach them. I have them in the data file
> > > > of SQL Server 2007 express. The files are not read only. I looked
> > > > in the permissions and they were but I changed it to writeable and
> > > > checked the other files the log file and such.
> > > > When I try to attach the files I get the error message "Database
> > > > Northwind cannot be upgraded because it is read only or has read only
> > > > files. Make the files writeable and re-run recovery".
> > > > What is recovery? Do the files have to be upgraded from SQL SErver
> > > > 2000?
> > > > thanks,
> > sorry, it didn't help, I got the Northwind 2000 sample file. I didn't
> > know the latest version was 2005, so that was helpful, however, I did
> > change the permissions for all the files, the log file and the mdf
> > files. They still won't attach.- Hide quoted text -
> > - Show quoted text -
> Hi Janis,
> There is no need to attach the northwind or pubs dbs . There are
> scripts like instnwnd.sql which will configure the northwind db for
> you . Just execute the script.
> and don't try to attach the db from higher version to lower
> version...!
> Thanks
> Ajay
It worked I created Northwind and Pubs successfully. I have one
question if you happen to see this. Why don't the two databases now
show up in the Object Explorer?|||> It worked I created Northwind and Pubs successfully. I have one
> question if you happen to see this. Why don't the two databases now
> show up in the Object Explorer?
Did you refresh? Or even disconnect and re-connect?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Janis Rough" <jlrough@.yahoo.com> wrote in message
news:f4fc0c53-e93a-47ff-8a94-561e04fb773a@.h11g2000prf.googlegroups.com...
> On Jan 30, 11:10 pm, Ajay Rengunthwar <aju...@.gmail.com> wrote:
>> On Jan 31, 8:16 am, Janis Rough <jlro...@.yahoo.com> wrote:
>>
>> > On Jan 30, 7:10 pm, Ben Nevarez
>> > <bneva...@.no.spam.please.sunamerica.com> wrote:
>> > > Hi Janis,
>> > > Is that SQL Server 2005? (There is no SQL Server 2007). Have you changed the
>> > > permissions of both data and log files?
>> > > You could also try this
>> > > Northwind and pubs Sample Databases for SQL Server
>> > > 2000http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-035...
>> > > Hope this helps,
>> > > Ben Nevarez
>> > > "Janis Rough" wrote:
>> > > > I got SQL Server 2007 Express configured and I ran a few queries. It
>> > > > appears to be configured correctly. I am trying to attach the
>> > > > Northwind and Pubs example files from SQL Server 2000. I have tried
>> > > > more than several times to attach them. I have them in the data file
>> > > > of SQL Server 2007 express. The files are not read only. I looked
>> > > > in the permissions and they were but I changed it to writeable and
>> > > > checked the other files the log file and such.
>> > > > When I try to attach the files I get the error message "Database
>> > > > Northwind cannot be upgraded because it is read only or has read only
>> > > > files. Make the files writeable and re-run recovery".
>> > > > What is recovery? Do the files have to be upgraded from SQL SErver
>> > > > 2000?
>> > > > thanks,
>> > sorry, it didn't help, I got the Northwind 2000 sample file. I didn't
>> > know the latest version was 2005, so that was helpful, however, I did
>> > change the permissions for all the files, the log file and the mdf
>> > files. They still won't attach.- Hide quoted text -
>> > - Show quoted text -
>> Hi Janis,
>> There is no need to attach the northwind or pubs dbs . There are
>> scripts like instnwnd.sql which will configure the northwind db for
>> you . Just execute the script.
>> and don't try to attach the db from higher version to lower
>> version...!
>> Thanks
>> Ajay
> It worked I created Northwind and Pubs successfully. I have one
> question if you happen to see this. Why don't the two databases now
> show up in the Object Explorer?sql

Tuesday, February 14, 2012

cannot see database

i have installed MS SQL Server 2000, and in the manager i see all the defaults dbs like : master, model, msdb, northwind, pubs and tempdb
i copyed a data base of my own (a .mdf and a .ldf) in Data folder and i cannot see it
what is the problem? how can i see it?/?You must attach it first (make it known to the SQLServer).

Use EM, klick the server node, right-klick the "Databases" (Folder-like) node, point to "All tasks", point+click "attach database" + put the other stuff in. ...

Or RTFM the section about "sp_attach_db" if you would like to do it via SQL ...|||ill try that when i get home
thx mate :)|||You need to attach the database and when the file open window pop-up, choose the file you have copied.