Re: unable to replicate a view or function

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks for the feedback. I did some digging and on
http://support.microsoft.com/default.aspx?scid=kb;en-us;810185
and
http://support.microsoft.com/common/canned.aspx?r=d&h=microsoft%20sql%20server%202000%20post-sp3%20hotfixes&ll=&sz=kbsqlserv2000presp4fix&fr=&du=&sd=gn&ln=en-us&cnd=1&vr=&cat=&vrl=&sg=&maxresults=200
there's no mention of dependency algorithms being updated, so I suspect this
is a coincidence, but who knows - it may be a side-effect of some other
unrelated hotfix.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)


.

Relevant Pages

  • Re: SQL 2005 - forcing a database to go suspect
    ... in order to finally arrive with a suspect database. ... SQL Server has increasingly over time considered this a "soft" suspect ... I stopped SQL Services and tried renaming log files, data files. ...
    (microsoft.public.sqlserver.server)
  • Re: Database : I/O error (torn page) detected
    ... Status still suspect. ... >> inherent in your database. ... Microsoft SQL Server Storage Engine ... >>>> use dbcc checkdb to fix torn pages. ...
    (microsoft.public.sqlserver.server)
  • Re: Database Suspect
    ... You need to determine why the database is suspect before trying to fix it. ... The most likely cause is one or more data files are missing. ... I tried to restart sql server service, dbcc checkdb repair_rebuild, alter db ...
    (microsoft.public.sqlserver.server)
  • Re: Creating a Report via VBA
    ... I suspect there is not a way to do so, just considering that you need to ... so even outside Access, a user could "do damage" to data in that folder, ... with a 2nd ID where Access is the back end rather than SQL Server. ... (in my backend .mdb) ...
    (comp.databases.ms-access)
  • Re: Problem with MSDE database
    ... Can you check the SQL Server error log file for more informations for the ... > When he makes a backup of my database with Veritas Backup Execute, ... > database is marked as suspect,. ... > there a tip to avoid to flag the database as suspect? ...
    (microsoft.public.sqlserver.msde)