Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bobz_0585
Yak Posting Veteran
55 Posts |
 Posted - 2009-05-08 : 17:34:16
|
hello all i created a database on sql server 2005 which have tables stored procedures views and functions...now i imported the tables and copied the functions and the view and everything is working perfectly.... but stored procedures when i copy some of them i get this eror....the text ,ntext , and image data types cannot be compared or sorted except when using is null or like operator. i need the stored procedures how can i overcome this problem |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-05-08 : 22:08:03
|
How do you "copy" the stored procedure ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
bobz_0585
Yak Posting Veteran
55 Posts |
Posted - 2009-05-09 : 03:00:27
|
| i created a new stored procedure and copied the code directly into it |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-09 : 05:33:10
|
| Are fields of same datatype b/w the SQL 2005 & sql 2000 db? i suspect some of fields with deprecated datatypes have been changed in sql 2005 db from which you copied the stored procedure |
|
|
|
bobz_0585
Yak Posting Veteran
55 Posts |
Posted - 2009-05-09 : 05:42:13
|
| yes ...i just noticed it..i will fix it thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-09 : 05:49:55
|
| welcome |
|
|
|
|
|
|
copying stored procedure from sql server 2005