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 |
|
Kurmanc
Yak Posting Veteran
92 Posts |
 Posted - 2008-04-10 : 05:53:11
|
| Hi,I am using SQL Server 2005, trying to drag and drop a sql-query but it is not possible. This was possible before, what might be the cause?Now, I have to open file, browse to the query and then it works but that is very time consuming. Would appreciate any suggestion. |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-04-10 : 06:16:15
|
| not helpful i know but... works for meEm |
 |
|
|
Kurmanc
Yak Posting Veteran
92 Posts |
Posted - 2008-04-10 : 06:23:54
|
| Could it be lack of user rights? This is so strange, I have never had this problem before. Again, any ideas would be appreciated. |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-04-10 : 06:25:25
|
| what about service pack level?Em |
|
|
|
Kurmanc
Yak Posting Veteran
92 Posts |
Posted - 2008-04-10 : 06:26:58
|
| SP2.I can drag and drop the file into firefox without any problem, so why should it be impossible to drag it into the SQL query window? |
|
|
|
Kurmanc
Yak Posting Veteran
92 Posts |
Posted - 2008-04-10 : 06:43:45
|
| Ok problem solved,hehe.Solution:- Right click sql server management studio- proporties- compatability- uncheck "Run this program as an administrator"If you can't run on windows authentication mode (if you don't run program as an administrator) the problem is then that privileges are not granted to the user. To fix this:- Open SQL Server 2005 Surface Area Configuration, - Choose "Add New Administrator"- Move the user from the left pane to the right pane.Problem fixed. |
|
|
|
|
|
|
drag and drop