Home > Archive > MS SQL Server > March 2006 > Re: SQL Server 2005: Collation Conflict Error when selecting Database Properties









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: SQL Server 2005: Collation Conflict Error when selecting Database Properties
Peter Nurse

2006-03-28, 3:23 am

Erland,

In my 1st response to your post, I overlooked the fact that there was
an error calling GetDBVersion.

This is interesting because migration of a DTS package (to the SS 2005
version presumably) fails with the following error:-

"
The SaveToSQLServer method has encountered OLE DB error code
0x80040E14
(Could not find stored procedure 'msdb.dbo.sp_dts_putpackage'.).
The SQL statement that was issued has failed.
"

The trace has a number of occurences of "Could not find stored
procedure 'GetDBVersion'.". I could send you the trace if it would
help.

Spooky, huh? Could it be a problem with msdb (which BTW still has
Collate = SQL_Latin1_General_C
P1_CI_AS)?

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com