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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 TSQL query problem

Author  Topic 

coastal1
Starting Member

1 Post

Posted - 2010-05-04 : 17:20:11
I'm having a problem using TSQL to gain access to a table, and using Domain Local Groups when the specified user is a member of that group.

If I specify the user directly, the query runs with no problem.

I know there were issues with this back in the NT / 2000 world, but I'm not aware of an issue now.

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-04 : 17:36:44
Granting access to a user or a group should work. I've done it numerous times without any problems.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -