Viewing 5 posts - 1 through 6 (of 6 total)
I usually do it just like you posted, and I reviewed myself. Sorry for the misdirection, but I think I was getting confused with creating/editing a view.
Jason
June 6, 2011 at 9:17 am
Hi Feb,
One quick thing you may try is to put your query into Query Designer. When you click ok from there, it should put the schema in front of...
June 2, 2011 at 11:04 am
Welsh, I found my issue. Really a bonehead mistake, but a problem nonetheless...
When I created the user on the db, I had a typo in there:
CREATE USER [DOMAIN\AGroup] FOR...
March 8, 2010 at 4:16 pm
I haven't tried that yet, just hesitant to try it again. However I did manually try to add the same group via the GUI, and it completed successfully, with...
March 5, 2010 at 5:44 pm
Certainly. I started out creating the login:
CREATE LOGIN [DOMAIN\UserGroup] FROM WINDOWS WITH DEFAULT_DATABASE=[MyDB]
GO
There are 8 other groups being added to LOGINS this way. I'm updating multiple DBs, so...
March 5, 2010 at 5:27 pm
Viewing 5 posts - 1 through 6 (of 6 total)