|
|
|
SSC Veteran
 
Group: General Forum Members
Last Login: Thursday, March 18, 2010 2:25 PM
Points: 284,
Visits: 985
|
|
I'm running SSMS , SQL Server 2005. Was running this query on a DB which has a backend on SQL Server 2000. Could that be it?
--
|
|
|
|
|
Hall of Fame
Group: General Forum Members
Last Login: Monday, March 15, 2010 2:57 PM
Points: 3,427,
Visits: 501
|
|
Yes it is.
Management Studio is just a client tool. Your queries are going towards the actual server which in your case is of version 2000
Regards,
Yelena Varshal
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Thursday, March 18, 2010 2:25 PM
Points: 284,
Visits: 985
|
|
Cool.. so then.. how can I pull of this same trick while having SQL Server 2000 as the backend DB ? I know sys.objects does not exist...but can't think of a work-around..hmm..
--
|
|
|
|
|
Hall of Fame
Group: General Forum Members
Last Login: Monday, March 15, 2010 2:57 PM
Points: 3,427,
Visits: 501
|
|
In 2000 all objects are in sysobjects and the definitions are in syscomments in the text column
Regards,
Yelena Varshal
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Thursday, March 18, 2010 2:25 PM
Points: 284,
Visits: 985
|
|
Great, Thanks! Will try it out..:D
--
|
|
|
|
