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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-18 : 09:22:29
|
| admin001 writes "Hello Everybody ..I am trying to detach and attach a database on SQL 7.0 Server with SP 2 through Enterprise manager . However if i right click o the Database and go to all task , i see the ' detach database' greyed out .The same thing is seen for ' attach Database 'when i try to attach the database . Although it can done through T-SQL commands also , does any body know the reason why this field is greyed out ? Does it depend on the SQL 7.0 Service pack or any kind of special permissions ? The same is visible on SQL 2000 Server Enterprise Manager . Has anybody come across this problem ?Many thanks in advanceYatin." |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-18 : 11:01:26
|
| Are you using the SQL 2000 client tools?I don't think this option is available in 7.0. It can only be performed through T-SQL.-Chad |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-02-18 : 11:06:11
|
| Didin't even know there was an option to do this through enterprise manager - but then I don't use it much.In fact on my system there isn't. Could be because I've only got a laptop here with desktop version..Are you registering as sa in enterprise manager?==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
|
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-02-19 : 06:48:12
|
| We're running SQL7 SP3 on one of our servers and i can't see this option anywhere in Enterprise manager. |
|
|
|
MuadDBA
628 Posts |
Posted - 2002-02-19 : 17:54:13
|
| I suspect you are using SQL2K client tooks because you manage multiple SQLServer versions, like I do, and for reasons only Microsoft understands, SQL2K EM overwrites SQL70 EM, and so all the options you would get for a SQL2K server show up in the menus, even if the server you connect to is SQL 7.0You will probably also see Open DTS Package under the DTS package menus, and this isn't available in SQL7 either.In SQL 7.0, you MUST use T-SQL to detach and attach databases, it can't be done via the front-end.Hope this helps!Joe |
|
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2002-02-20 : 08:37:54
|
| I also wanted to add that even if SQL 7 Enterprise Manager offered the option of attaching and detaching, I wouldn't use it. I would use TSQL instead, because it is really very easy and simple.HTH*************************Just trying to get things done |
|
|
|
|
|
|
|
|
Detach and Attach Database