sql server 2005 doubt - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

sql server 2005 doubt

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2007-05-21 : 06:44:38

Dear Folks,
I'm verymuch new to sql server2005, while I'm trying to open a file from particular location, it is opening and asking again to connect, after that it is directly going to default database msdb.

is there any chance like directly to open any number of new query windows?

thank you very much

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

nr
SQLTeam MVY

12543 Posts

Posted - 2007-05-21 : 07:31:26

When you load a query from a new file in management studio it will creaet a new window and connection. I often add a use statement at the top of the file.

==========================================
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.

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-05-21 : 07:51:40

You can also open disconnected query windows, although you will have to connect to the database for executing code.

As far as default database is concerned, you can either use nr's suggestion or map default database for the login through which you are connecting.

You can use following command to do this:

EXEC sp_defaultdb 'loginname1', 'db1'

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2007-05-22 : 02:25:08

this is good in one point, but everytime when i tried to open a new window,it is asking for connect
is there any other way to overcome this?

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

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-05-22 : 02:27:21

apply sp2, that fixes this issue.

-ec

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2007-05-22 : 02:42:26

is there any downloadable link for this eyechart?

thank you for the time given for me

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

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-05-22 : 02:54:29

Do you have Google blocked on your box?

[url]http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx[/url]

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2007-05-22 : 03:02:55

sorry harsh.............
I didnt checked......
download was finished

thank you

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

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2007-05-22 : 04:41:11

it is saying hotfix.exe is not a win32 application.....
while i'm trying ti install the sp2
i'm using windows 2000 professional and my system is intel(R) pentium 4 cpu 3.06 GHz

which SP2 i've to download?
I have tried with the first two .....in the given link
now i'm downloading the third(last) one....

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

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-22 : 09:57:06

Did you download x86 (the third in the list) one? File name is SQLServer2005SP2-KB921896-x86-ENU.exe, not hotfix.exe.

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-05-22 : 09:58:39

Also go through the Readme file first before downloading any pack to know which one is useful/applicable for your configuration. This would have saved a lot of hassle.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2007-09-03 : 00:37:22

Dear All,
i'm still getting the same problem, i've installed SP2, even now, when ever i'm dragging and dropping a query file, it is again asking the user name and password.so i've click on the connect button everytime.
is there any other way? it is sure sp2 not solved the problem.

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

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-03 : 12:47:17

I believe it's by design for security reason.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-03 : 13:21:41

I had his behaviour before. I remedied this by installing SP2 for SQL Server 2005 (not SP2 for Windows XP).
Now I can open any number of query windows! It seems to inherit last security context between opened windows.

E 12°55'05.25"
N 56°04'39.16"

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-09-03 : 16:08:37

quote:
Originally posted by sunsanvin

Dear All,
i'm still getting the same problem, i've installed SP2, even now, when ever i'm dragging and dropping a query file, it is again asking the user name and password.so i've click on the connect button everytime.
is there any other way? it is sure sp2 not solved the problem.

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

you need to apply the service pack to your workstation also. this will update the sql client tools to the sp2 level.

and as Peso stated, we are referring to SP2 for Sql 2005, not winxp.

-ec

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-03 : 21:39:23

Yes, it's changed in sql2k5 sp2.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2007-09-04 : 01:22:22

yes as you all mentioned, i've installed even then, i'm not remidied from this problem.....

installed the file : SQLServer2005SP2-KB921896-x86-ENU

is that the correct one?

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

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-04 : 02:42:31

On BOTH server AND client?

E 12°55'05.25"
N 56°04'39.16"

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2007-09-04 : 06:17:39

this is the server and client

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources