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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 problem while dragging a new script file

Author  Topic 

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-01-01 : 23:56:07
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.



Vinod
Even you learn 1%, Learn it with 100% confidence.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-09-26 : 08:54:54
Moved from script library.

i don't think you can.



_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!
Go to Top of Page
   

- Advertisement -