I am running MS SQL 2005 with several development databases. Somehow the collation between tempdb and one of my db's got messed up. Now I'm getting this error all over the place:
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
I tried changing tempdb's collation but ms sql wouldn't alllow it on a system db. There's too many tables involved to slap collate statements everywhere. Short of dropping the data, is there anyway to get the 2 back in synch? This problem is driving me nuts..
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.