in
All Tags » 2005 » SQL Server 2005 » SQL Server (RSS)

Browse by Tags

  • Collation conflict

    Hi there, Our client have setup a brand new sql server 2005 instance and have started getting this error since then. The error message is as follows : Select error: Cannot resolve the collation conflict between 'Latin1_General_CI_AI' and 'SQL_Latin1_General_CP1_CI_AS' in the equal to...
    Posted to SQL Server 2005 (Forum) by microsoft on 06-15-2009

  • Problem: Linked Server can't read/write MS Access Tables (Error Msg 7303)

    I'm attempting to use this to access MS Access 2003 from SQL Server 2005. I cannot use DTS/SSIS because I need to access data in real-time from a web page. EXEC sp_addlinkedserver @server = 'MyAccessDB', @provider = 'Microsoft.Jet.OLEDB.4.0', @srvproduct = 'OLE DB Provider for...
    Posted to SQL Server 2005 (Forum) by microsoft on 06-02-2009
Page 1 of 1 (2 items)