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 |
|
maranbe
Starting Member
28 Posts |
 Posted - 2007-01-23 : 00:18:45
|
| Hi Folks,I would like to use t-sql in 2005 to manipulate my data in sql 2000 instead of the usual query analyzer (well kinda like the rich features in MSSMS). Would I be concerned with any data integrity issue if I run my old scripts (sql 2000) in 2005 assuming all functions used are compatible with the current version? What are the pitfalls, if there's any?Kindest regard,SQL Server 2K (Clustered)/2K5_________________________Our life is frittered away by detail ... Simplify, simplify. |
|
|
PSamsig
Constraint Violating Yak Guru
384 Posts |
Posted - 2007-01-23 : 00:56:14
|
| Not any problems I know of, I use SSMS on a daily basis against several flavors of 2000 and 2005, I only use EM/QA when I have to manage a 7.0 (sic). It is fully aware of the 'limitations' on a 2000 vs. 2005.-- If you give someone a program, you will frustrate them for a day; if you teach them how to program, you will frustrate them for a lifetime. |
 |
|
|
maranbe
Starting Member
28 Posts |
Posted - 2007-01-23 : 22:03:07
|
| Thanks, PSAMsiq.Kindest regard,SQL Server 2K (Clustered)/2K5_________________________Our life is frittered away by detail ... Simplify, simplify. |
|
|
|
|
|
|
SQL 2K data manipulaton using T-SQL 2005