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 |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2011-05-08 : 00:41:33
|
| Hi Team,Is there any T-SQL script which can i have DENY permission at OS level.The reason behind this is, am a sysadmin at SQL level. eventhen i was not able import data from flatfile to sql table.Later came to know that i had DENY permission at Windows level. E:\Flatfiles.Like we have syspermissions in sql and we can check for 'D' if have any DENY permission, do we have any script which would report us that i have these all permissions at windows level on a given folder "E:\Flatfiles" ???Any help would be greatly appreciated.Thanks in Advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
script to find folder level permissions at OS leve