?
Solved

compare 2 views from 2 different servers

Posted on 2007-03-20
5
Medium Priority
?
317 Views
Last Modified: 2010-03-19
is there an easy way to compare two views with the same name from 2 different servers?
0
Comment
Question by:wala_lang
  • 2
3 Comments
 
LVL 42

Expert Comment

by:dqmq
ID: 18762167
Do you mean compare the views' coding or the compare the data returned by the views?
0
 

Author Comment

by:wala_lang
ID: 18762285
coding
0
 

Accepted Solution

by:
wala_lang earned 0 total points
ID: 18769232
found a solution, if anyone is interested here's the script that i used:

select sysobjects.name, syscomments.text as Prod, b.text as Centauri,
CASE WHEN syscomments.text = b.text THEN 'the same'
    else 'different' END [Compare]
from sysobjects
inner join syscomments on sysobjects.id = syscomments.id
inner join [centauri].EducationQueensland.dbo.sysobjects a on sysobjects.name = a.name
inner join [centauri].EducationQueensland.dbo.syscomments b on a.id = b.id
where sysobjects.xtype = 'V' and sysobjects.category = 0
order by sysobjects.name
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

599 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question