Unanswered: ERROR: Cannot use empty object or column names
have a server, and a DR
we're migrating the prod server over to a different one. We can copy the db fine (imported it) and can move the store proceedures over by hand too. But when i try and set up a dts package or replication, it errors out on me.
Message: Cannot use empty object or column names. Use a single space if necessary.
Someone recommended turning off quoted identifiers and make sure quoted identifier is OFF at the server level and the database level. Then, execute the procedure again.
But i have other db's on this and don't want to mess anything up in those DB's. Can anyone explain to me what htis might do, cause i'm not sure i even know what a quoted identifier is. And secondly, anyone know why i'm getting this error