Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
drydev
Starting Member
1 Post |
 Posted - 2004-11-25 : 07:23:30
|
 Hi folks,Would u pls advice me how to open the existing database files by tracing through windows Explorer. Or is it impossible to open the files thru any other path other than the enterprise manager window and getting into ur databases?. Cheerio,dev |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-29 : 13:23:57
|
| SQL Server is not a flat file based database system. You can't browse the files. You need Enterprise Manager, Query Analyzer, osql.exe or any other capable tool.Tara |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-11-29 : 14:33:59
|
| Actually you need sql server to access them.Well you can probably use a hex editor to look at the files and maybe decipher them.I started an article on the structure of the files but decided that I might not be able to do it because I didn't know enough about the ijitial pionters and that it probably wasn't a worthwhile excercise.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-11-29 : 14:40:34
|
| Doesn't Kalen discuss that...damn I gotta get that book....Brett8-) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-29 : 14:50:04
|
quote:
Originally posted by nr
Actually you need sql server to access them.
Well yes...I assumed, probably incorrectly, that the files were attached to SQL Server already.Tara |
|
|
|
|
|
|
opening a DBfile