| Author |
Topic |
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-26 : 16:02:22
|
| Yep. I've got both on my laptop, and not just the tools but the whole shabang.Tara Kizer |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-10-26 : 16:04:24
|
| Sure, done it several times.The box has a default installation of SQL2000 (like the good old days),and then just install a SQL2005 instance. I usually call it SERVERNAME\SQL2K5.It's no problem, you can keep on using both EM + QA and the new SQL Server Managment Studio.All client tools can connect to both 2000 and 2005 except EM which doesn't do SQL2005.rockmoose |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-10-27 : 02:12:49
|
| Same here.I have 2005 and a named instance of 2000 running on my dev box, haven't encountered any problems.SqlSpec - a fast, cheap, and comprehensive data dictionary generator forSQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-27 : 02:19:57
|
Some here. Have not encounter any problems.Anybody tried installing SQL2000 client tools (QA) on a SQL2005 box ? Only need the QA as SSMS sucks. Currently do not have a clean box to try now. All boxs have SQL2000 installed.
KH |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-10-27 : 09:12:22
|
| >> Anybody tried installing SQL2000 client tools (QA) on a SQL2005 box ?No, not that way round. One of the devs has tried it like that, but did not succeed.It complained about a prior installation running or such.But seems Jez did it this way, since he has 2005 and a named 2000 instance?rockmoose |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2006-10-27 : 09:24:24
|
| You think SSMS sucks? I like it much more than QA ... what don't you like?Jay White |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-27 : 09:37:47
|
It takes less than 1 secs to start up QA. SSMS takes ages to startup and connect to a server.In QA, once i am connected to a database, i can just drag .sql files to the QA window and it just automatically open up a window (connections) for each .sql file. In SSMS, it will prompt me to connect for each file  In what aspect SSMS is better than QA ? Maybe i have not explore that feature yet.
KH |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2006-10-27 : 09:44:21
|
| I love the solutions/project piece.Jay White |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-10-27 : 09:48:58
|
| I am still trying to figure out how to keep that blasted "Do you want to save this query?" pop up box from coming up after I run sp_who2. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-10-27 : 10:54:27
|
SSMS is slower to startup because it's managed. QA was 100% native code. Also it's just a fatter app. more bloat.You can tell SSMS not to connect to a server on startup though, then it won't throw the connection dialogs at you, etc, and will start a little faster. setting in tools/options/environment/general. See the "on startup" part of the dialog.
SqlSpec - a fast, cheap, and comprehensive data dictionary generator forSQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-10-27 : 10:55:17
|
quote:
Originally posted by rockmoose
>> Anybody tried installing SQL2000 client tools (QA) on a SQL2005 box ?No, not that way round. One of the devs has tried it like that, but did not succeed.It complained about a prior installation running or such.But seems Jez did it this way, since he has 2005 and a named 2000 instance?rockmoose
I installed 2005 first, then a 2000 named instance (server only, no 2000 client tools). There's not much point to installing the 2000 client tools since they aren't fully compatible with 2005 (QA works I think, but EM doesn't is my recollection). On the other hand SSMS will manage the 2000 instance just fine.
SqlSpec - a fast, cheap, and comprehensive data dictionary generator forSQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-27 : 11:08:49
|
" I love the solutions/project piece."Haven't really explore the SSMS yet. So far did most of my work from QA (from my Notebook) connecting to the SQL2005. Maybe feeling a bit sentimental with QA having using it for past few years 
KH |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-10-27 : 12:20:42
|
another reason SSMS is slow is because it uses SMO under the covers, and SMO is a fairly chatty api. You don't notice it so much if you are connected to your server on a fat pipe (or if it's local), but if you are on a slower connection you might find clicking around in SSMS more painful that EM was.Try turning on the profiler and opening up and clickign around in a few mgmt dialogs, you'll see what I mean.
SqlSpec - a fast, cheap, and comprehensive data dictionary generator forSQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org |
|
|
|
|
Install SQL 2k5 on the same box as 2k?