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

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

frank.svs
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.

russell
Pyro-ma-ni-yak

USA
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  
 New 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.06 seconds. Powered By: Snitz Forums 2000