Drag and Drop .sql scripts into SQL Management Studio 2008 does NOT work?
In SQL 2000 / Query Analyser, i used to be able to drag-n-drop T-SQL script files from Windows Explorer onto Query Analyser.
Cannot do the same in SQL 2008 / Management Studio ?
I can obviously do: File / Open / File... Navigate to the file Then Open it.
But someone please tel开发者_如何转开发l me there is an easier way just like in 2000 !
EDIT 16/7/10: Finally got to try on home PC, works as expected. Workplace has some restrictions (NT user policies) on a/c login. With Query Analyser, i 'Run As' another a/c and drag-drop works under logged-in user; With Management Studio, i 'Run As' another a/c and drag-drop does not work under logged-in user.
This works fine for me?
It's possible that this is some sort of permissions issue - if you are running Management Studio under any sort of elevated permissions then I believe Windows will prevent drag and drop operations.
精彩评论