Joining table of two different database with different SQL collation

Generally when we join two table belongs to different databases having different SQL collations gives you below error. Msg 468, Level 16, State 9, Line 3 Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation. To handle this situation we only need to put “COLLATE DATABASE_DEFAULT” keyword against each attribute […]

Read More

SQL Query to get logfile size, datafile size, recovery model, collations

Below is the SQL query to get information about the database properties like, its DBname, DBCollation, Recovery model, UserAccess, LogFiles size and DataFile Size.  

Read More