How about:

"Don't criticize someone until you've walked a mile in their shoes. Then, when you criticize them, you'll be a mile away and have their shoes "

Could you be a bit more specific about what you want to do ?

You don't necessarily need the collate on both sides of the =

If TableA is CollationA, and TableB is CollationB, you only need to set the collation for one table to...

I found this discussion about problems with SP4.  Seems to affect large queries running on servers with multiple processors.  I've installed SP4 on a test server, and a low usage...

Sounds as though you're using "Append to Media" instead of "Overwrite Media".  Perhaps you can post your actual backup statement.

As many have said in the past, posting some actual code examples goes a long way towards helping people understand your question.

Data and DDL are good too when appropriate.

Assuming you backup your databases daily (or at least regularly), then the database size history is stored in the backup tables.  Here's a script I wrote to look at backup statistics,...

I'm not sure why just copying data would give you a problem, but if you're comparing data in 2 tables with different collation, then you need something like:

select * from TableA ...

Sushila,  This may not apply to your problem of missing depenancies in views because I don't think you can create a view "View1" that references another view ("view2") if "view2" doesn't already exist...

Yup.  Linked Servers is probably what you want.  Then you can reference tables on other servers quite easily in your query.

You can also use OPENROWSET, but it's much more...

Correct.   The same thing happens with SPs.  It's a big pain.

Not that I know of.

SQL Server is pretty skimpy when it comes to this kind of info.  When we migrated from the AS/400, the lack of information about object usage...

It used to be a real pain to change the structure of files ("tables") on the AS/400. Then it got a bit easier, and if you needed to add a...

Assuming that DB2 is another name for the native AS/400 environment, then you can't just change data types of files. What I would try first is use DTS to dump...

Talking about me again !?