Red Gate forums :: View topic - making to work with sql server 2000
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Search 1
SQL Search 1 forum

making to work with sql server 2000

Search in SQL Search 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
ramkumar123



Joined: 03 Mar 2011
Posts: 2

PostPosted: Thu Mar 03, 2011 5:41 am    Post subject: making to work with sql server 2000 Reply with quote

I am connecting sql server 200 using sql server management studio 2005.

I have installed sql search in studio management & how can I enabled Sql Search for sql server 2000 also?
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 662
Location: Cambridge

PostPosted: Thu Mar 03, 2011 12:02 pm    Post subject: Reply with quote

Many thanks for your post.

SQL Search's supported database versions are SQL 2005 and SQL 2008.

I am afraid it does not support SQL 2000.

Kindly let us know if you have any other issues or questions regarding the product,I'll like to help.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Robert



Joined: 30 Oct 2006
Posts: 428
Location: Cambridge, UK

PostPosted: Thu Mar 03, 2011 1:17 pm    Post subject: Reply with quote

Just to follow up on that a bit further: the reason SQL Search doesn't support SQL Server 2000 is that the way metadata is stored changed significantly between 2000 and 2005.

SQL Server 2000 used real tables dbo.sysobjects, dbo.syscolumns and friends, whereas 2005 and later uses the views sys.objects, sys.columns (and many others) which have a rather different schema.

It'd therefore be a significant amount of work to populate SQL Search's internal object model from the 2000-style tables.

Many thanks,
Rob
_________________
Robert Chipperfield
Developer, Red Gate Software Ltd
Back to top
View user's profile Send private message MSN Messenger
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group