Hello All,

I am trying to perform the following bcp command but keep getting
"invalid object name error".  Please help.

C:\Documents and Settings\radhikari>bcp lp_risk.dbo.risk_hourly_var out
test.xls
/Ubcp_user -c
Password:
SQLState = 42S02, NativeError = 208
Error = [Microsoft][SQL Native Client][SQL Server]Invalid object name
'lp_risk.d
bo.risk_hourly_var'.

Raja (raja_adhik***@hotmail.com) writes:
Apparently there is no table by that name in the server you are connecting
to.

Maybe the database is not called lp_risk? Maybe the table is not called
risk_hourly_var? (Keep in mind that depending on collation, object names
may be case-sensitive.)

Maybe the table is not in the dbo schema?

Maybe you are connecting to the wrong server? Judging from the command line
above, you are connecting to the default instance of the local machine.
Maybe the database is in a name instance on the same machine? Or on a remote
server?

Error 0x80041010 WinMgmt when launching SQL SERVER MANAGEMENT STUD
How do you insert a carriage return in Management Studio?
SQL Agent keeps failing
SQLCMD error -100
Can't use Profiler to get execution plan for a particular query