Registrer Database på sql server

faroe>This is unders Access, can you give us some more information as to what it is you rtrying to do?

nor jeg installerer en sql server på en maskine og så har en database fil som jeg skal regestrere på sql serveren, jeg ved vordan man ger det manuelt, men vårdan kan man lave det med vb kode eller bat filerdet er

dette er den lille udgav af sql serveren so jeg har ikke verktøjerne med i installationen.

Strange, I was sure I placed a comment yesterday!
Do you mean MSDE when you say "den lille udgav af sql serveren"?
Are we talking about the mdf + ldf files?

yes.MSDE & mdf + ldf files?

Well it isnt anything I have tried myslef but I would think that it is possible. I found a link which MAY help though.
This is using SQL-DMO!

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q253435

det er kun til at kopiere en database ikke til at registrere.

BUT if you study the code you will see attach + detach and THIS is what you need to look at I would think.

This is the bit you need to look at
'Re-attach original database
  sql.AttachDB strDatabase, strMDFfileName & "," & strLOGfile
  sql.AttachDB strNewName, strMDFfilePath & strNewName & _
  ".mdf" & "," & strMDFfilePath & strNewName & "_log.ldf"

SQL-DMO is what you need to us eto do this so I would suggest taht you take a look at these links>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ad_34kp.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_con02_5mem.asp

In the last link you will need to look through the methods and properties.

Lige det jeg skal bruge :) jeg skal bare studere det mærmere.
Tak for hjælpen.

Thanks for the points :o)
You should palce an answer here and accept it so that you can get your points back.

http://www.eksperten.dk/spm/268978