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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-01-02 : 02:25:12
|
| Dear All,i'm using Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 4) the above version. when ever i'm dragging a new window to the SSMS, it is always asking to connect and then goes to default database master. in sql server 2000, this is not a problem.can you please suggest me some thing for this?i've tried with sp_defaultdb 'mydb'but soon after testing the scripts on an empty database, i've to dropt the database. if i for got to change the default db to master, then i'm getting problem to connect again.please tell me how can i avoid the connect window at everytime when i drag a script file...thanks in advance.VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-03 : 23:28:08
|
| You can click on the db like to use in object browser in ssms before dragging script. |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-01-04 : 07:30:32
|
| no rmiao it is not workedVinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
problem while dragging a new script file