I received following email from Mike Bikkins.
“How can I connect to SQL Server 2005 or SQL Server 2008 using SQL Server 2000’s Enterprise Manager?”
No. You can not connect with SQL Server 2005 and higher version using Enterprise Manager. You will need SQL Server Management Studio available with SQL Server 2005 and higher version.
Reference : Pinal Dave (http://blog.SQLAuthority.com)
pinaldave
I don’t understand why people ask such dumb questions … whats the use of these things….
When sql server 2005 / 2008 servers are installed… you would have 2005 / 2008 client tools…I dont see any reason to access sql server 2005/2008 using sql server 2000 client tools. whats is the advantage ?
You can download ssms client tools for sql server 2005/2008 for free.
check this link:
http://www.microsoft.com/downloads/details.aspx?FamilyID=7522a683-4cb2-454e-b908-e805e9bd4e28&DisplayLang=en
Regards
IM
Hi pinal,
Can we connect to sqlserver2008 using sqlserver05 ssms??
i am unable to connect to sqlserver2008 using 05 ssms
i am getting an error
This version of ssms can only be connect to sql 00 and 05
I am having 05 express edition and 08 express edition
@santosh – you can’t. The reason you can’t connect to a newer version of the server with an older tool is because the newer server has different properties that the older tool isn’t aware of.
I can think of one reason you might want to – if you are working on a computer that only has an older version of the client tools but need to connect to a newer server, and don’t have RDP access (for example). However the real solution is to simply install newer client tools. For a while I had both SQL2000 and 2005 client tools – they coexist very well together.
hi @John
i now what you told but the thing is if there is any possible solution exists
thanks for ur reply
There is no solution other than install newer tools, or use command line tools such as osql.
Hi Dave
How do you do. well can u help me in my problem that how can i find tables related to each other using primary key & foreign keys as their are no of other tables in the database
i am new to sql Database’s as for my first chance to the sql as a database deceloper and i need to combine all the tables as for my requirements as i need to update users for their reports for which i need to check the table name as per requirements via command
select * from information_schema.tables
where table_name like ‘%employee%’
please help me with my query to find all the tables that are interrelated to each other
Ziyad Mehmood
DBD Pakistan
Hi
my i am having a doubt . my server maintenance is done every week. this time my server was restarted by network team without my information. I was about to run rebuild index job on one of the database. could u tell me what if the server is restarted during rebuilding index.
thanks
raghu