Viewing 15 posts - 18,376 through 18,390 (of 39,961 total)
Somebody should post dbcc timewarp on Connect 😉
September 10, 2010 at 9:04 am
First, don't grant rights to a user. If there's one, he/she will be replaced, or you'll add someone else. Take 10sec and write
Create role MyDenyRole
Then I'd do a GRANT on...
September 10, 2010 at 8:45 am
I wrote about this for a 2008 exam book and found very few references at the time. Here's a few I did find
http://www.mssqltips.com/tip.asp?tip=1320
http://msdn.microsoft.com/en-us/library/ee819082%28SQL.100%29.aspx
http://www.simple-talk.com/sql/database-administration/sql-server-consolidation/
September 10, 2010 at 8:42 am
Run
Starting a new year today (http://stevejonesssc.blogspot.com/2010/09/goal-update-misc-accomplishments.html)
September 10, 2010 at 8:38 am
You can set permissions by schema, or you could assign permissions by object (using a role).
Ultimately, if you have people with DDL_Admin and they are dropping table they shouldn't be,...
September 10, 2010 at 8:29 am
Or make sure that this page is using Windows Auth and only you, or other DBAs, can execute stuff.
What you can do as well is just create a stored proc...
September 10, 2010 at 8:27 am
You could offer to call MS and get support, but my guess is that they would tell you what Gail has listed here.
September 10, 2010 at 8:21 am
I just read Containment (http://www.amazon.com/Containment-ebook/dp/B0039PT4BO/ref=sr_1_3?ie=UTF8&m=AG56TWVU5XWC2&s=digital-text&qid=1284128240&sr=8-3), $0.99 on Kindle, and got my son started. Really enjoyed it. Life on Venus for a closed colony.
You can read on computer, Android/iPhone if you...
September 10, 2010 at 8:18 am
Paul White NZ (9/10/2010)
Steve Jones - Editor (9/10/2010)
I always find time to read. Keeps me sane (...):laugh: Sane?
Sane is relative for ex-rugby players
September 10, 2010 at 8:06 am
I just started Tribes myself. Also reading The Art of Community while I'm reading a couple novels at the same time.
September 10, 2010 at 7:47 am
September 10, 2010 at 7:43 am
Never read about Collosus. I'm assuming this is the Xmen guy?
I always find time to read. Keeps me sane with a break from this world.
September 10, 2010 at 7:30 am
Perhaps that's the way of the world. I'd like to think that people get some choice, but perhaps not. 90% (thereabouts) of people in the US are employed. There are...
September 9, 2010 at 8:45 pm
Good question. I would assume that you run some data through, see what it mines it as, and then you backtrack through the data to see if the results are...
September 9, 2010 at 8:43 pm
What are you looking for? There are some application testing tools. There's also SQLIO for hardware testing. There's a few options if you narrow down what types of testing you...
September 9, 2010 at 8:40 pm
Viewing 15 posts - 18,376 through 18,390 (of 39,961 total)