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 |
|
mgoss
Starting Member
1 Post |
 Posted - 2002-02-18 : 10:09:37
|
| I have sql server 7 installed on a windows 2000 prof machinei have a number of user profiles setup in win 2000when I try to open external files for editing in query analyser - under one of the profiles it hangs !!anyone come across this ? or know what the problem is |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-18 : 10:41:33
|
| My first guess is that the profile doesn't have certain rights that it needs. Does it happen with only one profile, or several? Does it happen only on certain files or directories? This should determine if it's the profile at fault, or just the file/directory permissions. |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-02-18 : 15:51:18
|
| One possible sticking point is that profiles that are part of the Administrators group on the SQL machine automatically have sysadmin privileges (unless specifically changed). If you see differences between profiles, that is one area to check. Don't know why it would hang rather than just error out, though.------------------------GENERAL-ly speaking... |
|
|
|
|
|
|
Query Analyser - Hanging