Yes, the datatypes are exactly the same. According to the Metadata viewer, both "Col1" columns are DT_STR, length 3, Code Page 1252. Both RowNumber columns are DT_I4.

I haven't reported it myself, but I remember seeing it on Microsoft Connect, where MS stated that they were addressing it in SQL 2008 only.

Disclaimer: this is all theory, as I don't have a 500GB table to try this on. It seems reasonable to me.

- Make sure your recovery level is set to...

Another handy way to export diagrams from any version of SQL Server is to "print" to a PDF, using a tool such as PDFCreator (http://sourceforge.net/projects/pdfcreator/).

A closely related issue exists with the sp_rename stored proc in SQL 2000. If you use sp_rename to rename a view (which Enterprise Manager and Management Studio seem to...

Can you get the Toyota Yaris in the U.S.? I have an Echo hatchback, only available in Canada, which is pretty much the same car as the Yaris. ...