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 |
|
fattony
Starting Member
6 Posts |
 Posted - 2002-05-28 : 22:25:26
|
| I am running MSDE SQL 7. When running dbcc checkdb against my user defined database I get Operation is not allowed when the object is closed. Internal 3704. I can run this query agains the same database however, on a SQL 2000 server. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-05-29 : 01:23:16
|
| How are you issuing the command? Osql? VB via ado?-Chad |
 |
|
|
fattony
Starting Member
6 Posts |
Posted - 2002-05-29 : 19:37:08
|
| Good point...it turns out the problem is specific to queries run throug a GUI interface specific to my database application. I can successfully run the same queries through osql. However that raises a new issue. How do I make the osql query output readable if the columns are being truncated. I tried the osql -w switch but no value seems to make a difference. For example output for odbcc checkdb with tableresults produces unreadable output on screen or to a text file. |
|
|
|
fattony
Starting Member
6 Posts |
Posted - 2002-05-29 : 19:37:26
|
| Good point...it turns out the problem is specific to queries run throug a GUI interface specific to my database application. I can successfully run the same queries through osql. However that raises a new issue. How do I make the osql query output readable if the columns are being truncated. I tried the osql -w switch but no value seems to make a difference. For example output for odbcc checkdb with tableresults produces unreadable output on screen or to a text file. |
|
|
|
fattony
Starting Member
6 Posts |
Posted - 2002-05-29 : 19:37:37
|
| Good point...it turns out the problem is specific to queries run throug a GUI interface specific to my database application. I can successfully run the same queries through osql. However that raises a new issue. How do I make the osql query output readable if the columns are being truncated. I tried the osql -w switch but no value seems to make a difference. For example output for odbcc checkdb with tableresults produces unreadable output on screen or to a text file. |
|
|
|
|
|
|
Operation is not allowed when object closed