Re: beware: SQL2005 management studio not 2000 compatible
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 18 Jan 2007 00:22:03 -0800
Leon McCalla (leonmccalla@xxxxxxxxxxxxxxxxxxxxxx) writes:
using 2005 management studio i made changes to an 8 step job on SQL 2000
server. I inserted a new step into position 8 and then tried to save it.
SQL2005 management told me that some feature was not supported on SQL 2000
so i pressed cancel. at this point both SQL 2005 management studio and SQL
200) enterprise management both report a 4 step job.
It is going to take me hours to restore the 8 step job from a backup so
that it can be re-inserted into the live DB.
That's bad. That would indicate that there is no transaction handling. I
think this is quite a serious bug. Please go to http://connect.microsoft.com
and file a bug for this. Try to be as specific as possible. Best if you
can give a complete scenario which reproduces the problem. (A two-step job
should be sufficient, I guess.) I know that this will take even more time,
but if Microsoft does not get to know about the problem, they can't mend
their ways.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- beware: SQL2005 management studio not 2000 compatible
- From: Leon McCalla
- beware: SQL2005 management studio not 2000 compatible
- Prev by Date: beware: SQL2005 management studio not 2000 compatible
- Next by Date: Re: Management Studio scripts for SQL 2000
- Previous by thread: beware: SQL2005 management studio not 2000 compatible
- Next by thread: Re: Migrate from Sybase SQLAnywhere
- Index(es):
Relevant Pages
|
