Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sp_attach_db
Message
From
04/07/2001 10:16:28
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Recovery
Title:
Sp_attach_db
Miscellaneous
Thread ID:
00526672
Message ID:
00526672
Views:
56
Hello, All

I'm not sure if this is the correct section, but it seems a recovery to me:

I've created a database using MSDE. I didn't know at that time how to set the collating sequence and index order in osql.exe (this is the tool I've used) and now I have some errors about this. At that time, the local computer was running Romanian CodePage and now I have English codepage.

I have some questions:

1. How to attach a database to a SQL server, if the database was not detached from the MSDE? I have only the files .MDF and .LDF.
2. How to retrieve the collating sequence and index order from a database and how to change them, supposing I cannot attach the database to a SQL Server?

Please, help me, I'm in hurry. Tomorrow I must have the database attached.

Thank you very much
Grigore Dolghin
Class Software.
Next
Reply
Map
View

Click here to load this message in the networking platform