Make that you are connected to a database after you open the file. That is an error when there is no database connection associated with the open file. HTH Thanks.

Not for me across servers. I still get the error:

[Transfer SQL Server Objects Task] Error: Table "ACHInvestDetails" does not exist at the source.

Exec sp_changepublication

@publication = 'yourpublication'

,@property = 'allow_anonymous'

,@value = 1

,@force_invalidate_snapshot = 1

,@force_reinit_subscription = 1

The key is to look at the @Property parameter...

There is no hard and fast rule that states that a table must have a PK. However it is recommended that they do. Now what type of PK should the...

This is an age old question. There is no reason not to per se, it is more important to determine the use of the table and consider issues like replication...

I had to re-read the thread to see where it was. I have a question about those of us that work on two or more platforms/DBMS. In my case, I...

The market has definitely slowed down. There is work but you have to be willing to compromise becuase it is an employers market. Those DBAs that have other collateral skills...