benvegiard
Programmer
Hi All...
I am writing a DTS package using the Import Data wizard to copy data from our Production server to our Test server (both SQL 2k(sp 3a) on W2k os).
About 95% of the database moves over fine. However, a handful of tables/views are reporting "[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'vwTxTotalHrsByEmpAP'" Other views not coming over are named very similar. All objects are owned by DBO.
Are the names too long? I haven't found any documentation regarding object name lengths. Anything else you can think of?
Thanks,
Ben
I am writing a DTS package using the Import Data wizard to copy data from our Production server to our Test server (both SQL 2k(sp 3a) on W2k os).
About 95% of the database moves over fine. However, a handful of tables/views are reporting "[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'vwTxTotalHrsByEmpAP'" Other views not coming over are named very similar. All objects are owned by DBO.
Are the names too long? I haven't found any documentation regarding object name lengths. Anything else you can think of?
Thanks,
Ben