Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
neridaj
Starting Member
1 Post |
 Posted - 2006-08-28 : 13:53:05
|
| I need to connect to a pre-existing SQL 2000 database with the ablitiy to have admin control over the tables. From my understanding, this used to be "Enterprise Manager" which was included in SQL Server 2000. I downloaded Enterprise Manager from Sourceforge and I am not sure how to imlement it i.e., there's no interface that launches or anything, is there something included with VS 2005 that is the equivelent, or do I need to purchase SQL Server 2005?Thanks,J |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-28 : 14:29:29
|
| You can do everything with query analyser in v2000 - enterprise manager gives you a gui.The equivalent in v2005 is management studio which combines enterprise manager and query analyser. You can use this on v2000 too.You can install enterprise manager from the v2000 installation cd by selecting client tools.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-08-28 : 17:46:03
|
| neridaj, you asked whether there is something similar (to Enterprise Manager) in VS 2005 - the answer is yes, and it is pretty good - you can use it to create tables, stored procedures and functions and so on. You'll find it in the Server Explorer.You can also use Microsoft SQL Server Management Studio Express (SSMSE) with SQL Server 2000 - it is a free tool from Microsoft.There are various Enterprise Manager type tools on SourceForge, many of which have nothing to do with SQL Server, but none of them are the Microsoft one - you only get that with SQL Server 2000. |
|
|
|
|
|
|
SQL Server + VS 2005