Solved

compare 2 views from 2 different servers

Posted on 2007-03-20
5
305 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
5 Comments
 
LVL 42

Expert Comment

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

Author Comment

by:wala_lang
Comment Utility
coding
0
 

Accepted Solution

by:
wala_lang earned 0 total points
Comment Utility
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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now