Viewing 15 posts - 631 through 645 (of 823 total)
Wow...duh! Thanks GS. Forgot my set theory for a second.
Is a join the only way to do this?
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
February 7, 2011 at 2:51 pm
Interestingly enough, when I read this I felt a twinge of guilt. Not that I lied on my interview nor did I embellish, but I had just passed my...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
February 7, 2011 at 11:16 am
I've always wanted to buy some land on the moon on the slight chance that it's legit. I could see my descendants saying something like: "great great great grandpa...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
February 4, 2011 at 9:13 am
The moon.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
February 4, 2011 at 8:06 am
Don't handle things twice. If you pick something up, open an e-mail, etc., handle it then. The single largest source of double-work and lost time you will ever encounter is...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
February 3, 2011 at 9:27 am
Try this:
select * from sys.database_principals
where type = 'A'
Reference:
http://msdn.microsoft.com/en-us/library/ms187328(v=SQL.90).aspx
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
February 1, 2011 at 5:27 pm
I'm still a DBA, but have been offered a position on our data warehouse team, writing reports with the potential for some direct interaction with our nightly ETL. My...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
February 1, 2011 at 5:15 pm
umm, don't want to argue, but GRANT/DENY/REVOKE are all mutually exclusive. The permission that gets revoked is what was GRANTed or DENYed. It took me a few reads...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
January 27, 2011 at 2:43 pm
I can only find the SQL Server 2000 page also, but I think what you want to do here is instead of:
GRANT SELECT
you should
REVOKE SELECT
If I'm reading correctly, the...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
January 27, 2011 at 2:35 pm
I remember when Sierra OnLine came to be, Oakhurst was so much smaller then...we used to think it was a video game shop.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
January 24, 2011 at 8:45 am
kevlray, I bet I'm the only one on the thread to know where Oakhurst and Coarsegold Ca. are. My relatives have lived up there for 35+ years. I...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
January 19, 2011 at 9:08 am
Personally, I hope it's only Blyleven.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
January 5, 2011 at 8:16 am
Good times, good times. Thanks for the prizes, Steve.
See you all next year, I'll make sure I schedule the draft to accomodate my schedule and not any of yours...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
January 4, 2011 at 8:32 am
You'll get no sympathy from me!!!!! Down with PPP, he's a green haired monster (without the bulging muscles)...I'll get you next year!
All joking aside, it's been a fun league....
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
December 20, 2010 at 5:10 pm
Sheesh, Lynn's gonna hang 150 on me...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
December 19, 2010 at 7:29 pm
Viewing 15 posts - 631 through 645 (of 823 total)