Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Permissions at OS level folder
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Constraint Violating Yak Guru

368 Posts

Posted - 05/08/2011 :  00:39:12  Show Profile  Reply with Quote
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.


5072 Posts

Posted - 05/08/2011 :  14:46:34  Show Profile  Visit russell's Homepage  Reply with Quote
Best thing I can think of is to use xp_fileexist.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000