Use some common sense, and post the vbscript if you actually expect any response to this issue.  And, if I sound like I am being a a$$hole, it was intended...

Make sure you read the entry from olavho in the above link.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=139297

Don't install it on "too many people"'s machines. 

DBCC MEMORYSTATUS is the only helpful thing I found for this.

I downloaded the trial version.  Used it for about 5 minutes, before I realized it was worthless due to the lack of quality.  Without going into a ton of details,...

Have you checked out RedGate SQLCompare software?  It compares databases, and generates the approiate scripts to "sync" the databases. 

We actually have log shipping in place for the failover location.  The complicated part of this is, that LocationB also serves as a "live" datacenter in parallel with LocationA.  This...

Well, obviously if locationB is a failover for locationA, then the data in each location would need to be the same.  This is "all" data, user-entered, and otherwise.

Now, to address...

Stored Procedures will run fractionally slower if they start with a prefix of sp_   This is because SQL Server will look for a system stored proc first.

Ideally you do not want to create stored procedures in the master database.  I would recommend creating a "admin" database and creating the proc there.  Also, you never want to...

You can fully qualify the name of the table in the insert statement.  For example:

You got:  Insert into dbo.tablename

Change it to:  Insert into databasename.dbo.tablename

rather than..  exec sp_changeobjectowner 'view_name', 'dbo'

try...  exec sp_changeobjectowner 'user.view_name', 'dbo'

sp_changeobjectowner

I would be $$ that someone restarted it and is not telling you.  SQL does not restart itself