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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-28 : 07:59:21
|
| Krista writes "I have created a batch file to use the following osql statment:osql /U xx /P xx /d dealerprofile /S 00.000.000.00 /Q "Select * from dealer" -o d:\dealer.csvThe connection seems to be working but then I get the following error:Msg 208, Level 16, State 1, Server xxxx, Line 1Invalid Object Name 'dealer'I've tried including the dbname in the sql statement and some other things but no luck.Any ideas?Thanks." |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-09-28 : 08:01:26
|
| It seems that the table name dealer is invalid. Try to use dbo.dealerMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
OSQL: Storing result of a Stored Procedure in a file