making to work with sql server 2000

A free Management Studio add-in to search for SQL in your databases

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, Adam, justin.caldicott

making to work with sql server 2000

Postby ramkumar123 » Thu Mar 03, 2011 5:41 am

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?
ramkumar123
 
Posts: 2
Joined: Thu Mar 03, 2011 5:32 am

Postby Anu Deshpande » Thu Mar 03, 2011 12:02 pm

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
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby Robert » Thu Mar 03, 2011 1:17 pm

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
Red Gate
Robert
 
Posts: 410
Joined: Mon Oct 30, 2006 11:15 am
Location: Cambridge, UK


Return to SQL Search 1

Who is online

Users browsing this forum: No registered users and 0 guests