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 |
|
rale
Starting Member
1 Post |
 Posted - 2014-08-13 : 00:35:58
|
| Hi,I am running sql svr2005 management studio on windows svr 2003. I once received error 4064, found out that db (SENT_be)was offline. I used 'master' to access login with windows authentication. i am desperate to reattach the database, this step "obj.explorer>SENT_be>tasks>bring online" does not work. can someone help please?thanks.RaLeX |
|
|
Lincolnburrows
Yak Posting Veteran
52 Posts |
Posted - 2014-08-13 : 06:59:06
|
| You can resolve this by specifying another database you want to connect to; master, for example. Then you can reset the login's default database. With sqlcmd, you can do the following:sqlcmd -d master -U sa -P mypasswordand then:alter login sa with default_database = master |
 |
|
|
|
|
|
SQL SERVER DB ERROR 4064