Could not find stored procedure

• Viv123

  SSC Veteran

  Points: 292

  More actions

  February 14, 2003 at 5:35 am

  #63256

  Hi All,I am using SQL server 2000.i recently moved my databases from one server to another server.Since then i am getting error while running reports 1) Could not find stored procedure.( Stored procedure exist;i check using sp_helptext.Stored procedures are created using dbo login. 2)i get Database Error

  2: Error generated by the connected data source ...

  446: [SQL State] 37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot resolve collation conflict for equal to operation.

  Error.Plzzzz help its very urgent.

  Roshan

  
  Roshan

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  February 14, 2003 at 7:49 am

  #448975

  It looks the collation of SQL Server 2000 and the database are different.

• zach_john

  SSCertifiable

  Points: 5922

  More actions

  February 14, 2003 at 8:28 am

  #448989

  In other words when you installed SQL 2K you didn't set Unicode collation to be the same as you did under SQL 7. If you want to be educated on collation read

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_7ory.asp

  Otherwise determine what your SQL 7 collation was default is (General, case-insensitive) dettach your database rerun setup picking the correct collation and then reattach your database.

  I'm not sure how you determine what collation was used if the SQL 7 version is

  gone, you might have to do trial and error, but it should be quick enough.

  John Zacharkan

  
  John Zacharkan