2005 Replication error.
This was a little strange one we got in our Dev environment today. I was changing the default for a column to not allow nulls and I got this message back from S2k5
Skipping replication schema version logging since systranschemas table is not present in database 10.
This database was previously replicated but we got rid of all replication on it way before we moved it to 2005. So I was curious to find that it was talking about replication when it showed it was not replicated? I was even more surprised since the next script I had to run was removing the primary key and adding a new one with some changes. It wouldn’t allow me to do this since it said the table was replicated. After trying sp_helppublication and various other replication sprocs and looking Mgnmt studio there was nothing that said replication was there. So one of the other dba’s here tried sp_removeDBreplication on that db and that worked and then I was able to drop it. Not really sure why or what kept this replication hanging around but it was good that he was able to do that so we could get the primary key added.
Pat