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 |
|
shekhar_dba
Starting Member
39 Posts |
 Posted - 2007-02-16 : 09:24:32
|
| Hi gurusi have a assignment on hands to transfer store procedures of 2005 to 2000. I have tryed by scripting SPs and then runing them in 2000 QA, but it gives me error every time ....... so please help me to resolve this problem.thanksshekhar |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-16 : 09:37:05
|
All the Stored Procedure gives you error ? What are the error messages ?Do note that as you are transferring Stored Procedure from 2005 to 2000, the SP might be using some feature that available in 2005 but not in 2000.
KH |
 |
|
|
shekhar_dba
Starting Member
39 Posts |
Posted - 2007-02-16 : 09:52:59
|
hithey all give error of invalid system objectthanks shekharquote:
Originally posted by khtan
All the Stored Procedure gives you error ? What are the error messages ?Do note that as you are transferring Stored Procedure from 2005 to 2000, the SP might be using some feature that available in 2005 but not in 2000.
KH
|
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-16 : 10:06:32
|
can you post the section of the stored procedure that gives this error ?
KH |
|
|
|
|
|
|
How to transfer stored procedures to 2005 to 2000