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 |
|
mrtweaver
Yak Posting Veteran
67 Posts |
 Posted - 2009-08-26 : 07:35:59
|
| I hope this is the correct place to post this problem. In studio manager when you go to open it up it pops up with a login box. at the bottom there is a checkbox where you can select to save the login credentials. Now here is the problem:1. If I go into studio manager and I view, edit, alter, or select any table and/or view, then I exit out of studio manager. When I open it back up the password and check box are still properly filled in and it will log me back in.2. If I follow the same process as in 1 above but this time I go into one of my stored proceedures. If I exit out of studio manager, when I open it back up the check mark box is cleared and so is the password.Is there a reason for this? I think during one of my searches for information I came across something about this but for the life of me I can not find the article again. FYI we are running MS SQL 2005.Thanks and have a great day. |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2009-08-26 : 07:45:26
|
| http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/e40a3a81-748c-4a26-9fa3-9945b7a98be0http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspxHow to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
 |
|
|
mrtweaver
Yak Posting Veteran
67 Posts |
Posted - 2009-08-26 : 08:12:29
|
Your post makes it sound like MS has been notified about the issue but that there is no fix from MS yet. Would I be correct in that statement?It does appear that for some users this has happened in regular queries and such. For me that part has not happened it only happens when I work on stored proceedures.After reading the information on these links it made me think that what I read somewhere else had to do with putting the authentication credentials in the stored proceedure. is this possible to do?I ask because I have only just begun my journey to understand SQL and do not have a full grasp on its abilities and such as of right now.Thanks again and have a great day.quote:
Originally posted by DonAtWork
http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/e40a3a81-748c-4a26-9fa3-9945b7a98be0http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspxHow to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp
|
|
|
|
|
|
|
MS SQL Studio Manager Password Issue