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:39:12
|
| 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. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-05-08 : 14:46:34
|
| Best thing I can think of is to use xp_fileexist. |
 |
|
|
|
|
|
Permissions at OS level folder