Why are there INFOMATION_SCHEMA and catalog views in SQL Server that do very similar things? For example, to retrieve a list of tables in a database, I can ...

So lets say I have 5 databases, all with the same schema, but different data. I want to be able to build reports based on the data in all of those databases. How could I construct a view which ...

In SQL Server 2000, if Fred created a table called “Mytable” in the “Pubs” database on the “Usaserver”, the fully qualified name would be Usaserver.Pubs.Fred.Mytable.

Idera, a provider of management and administration solutions for Microsoft SQL Server, has announced SQL comparison toolset v1.1, a solution that is aimed at helping DBAs save time in comparing and ...