December 4, 2001 at 9:51 am
We have a database that says we have 3000 views. Upon inspection 2100 of those are syncobj_.... What exactly is this?
Thanks in advance.
Be great!
Michael
December 4, 2001 at 10:36 am
Is this a user database? Which version of SQL? How are you getting the information that where are 3000 views? Did you create 900 views in this db?
Some more information will help us help you.
Steve Jones
December 4, 2001 at 10:57 am
You'll get those if you've set up replication for the database.
Andy
December 4, 2001 at 11:01 am
December 4, 2001 at 11:32 am
Yes it is a user database.
SELECT name FROM sysobjects WHERE type = 'V' ORDER BY name
That would make sense, sort of, if replication is creating those. This database is the publisher for our transactional replication. Of the 904 user tables, we are replicating 611 of them. Not sure how the number keeps growing, unless it is cumulative.
"The pain you feel now is nothing compared to the pain you will feel if you quit!"
Be great!
Michael
December 4, 2001 at 11:33 am
I think its one per article. Might have some left over from other replication attempts maybe? Lots of different publications?
Andy
December 4, 2001 at 11:44 am
We have had to rebuild replication so many times. That would seem logical.
Thanks for the insight.
P.S. We "discovered" this while running a query for a CAST product. They needed to know how many objects we would be monitoring - for pricing purposes.
"The pain you feel now is nothing compared to the pain you will feel if you quit!"
Be great!
Michael
December 4, 2001 at 11:50 am
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply