July 2, 2007 at 3:58 am
Firstly, thanks for taking the time to read my post.
On a SQL Server 2000 db which I have started to work on, a number of unusual Views are present. No-one here seems to have any idea how they were created but they seem to be automated or part of some system functionality from their naming. Each of them runs a simple SELECT * on a single table in the database.
The are all names
_hypmv_2_1345
or
syncobj_0x3037415532424145
But obviously that digits differ for each one.
July 2, 2007 at 4:08 am
Need to check how they get created.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 2, 2007 at 5:40 am
The syncobj_0x1566... views are created by SQL Server for replication when a snapshot gets created. Are you still using replication ? I know that sometimes not all replication objects are removed when replication is removed from the system. You might also find a lot of stored procedures relating to replication.
About the others (_hypmv) check this link http://lvildosola.blogspot.com/2007/02/sudden-sql-error-during-insertupdate.html
hope this helps
Markus
[font="Verdana"]Markus Bohse[/font]
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply