Viewing 15 posts - 16,171 through 16,185 (of 19,564 total)
Otherwise, you could use the GUI and open the role in the desired database to view it's properties. Then select "securables."
This should display permissions for specific objects for the...
March 19, 2010 at 4:28 pm
I just uploaded a script to my blog that can help you with this.
Check it out at http://jasonbrimhall.info/?p=391
March 19, 2010 at 4:27 pm
GilaMonster (3/19/2010)
GSquared (3/19/2010)
March 19, 2010 at 4:21 pm
Please refer to this document for info on how to add or remove a node from clustering.
http://msdn.microsoft.com/en-us/library/ms191545(SQL.90).aspx
March 19, 2010 at 3:55 pm
Lynn Pettis (3/19/2010)
As for me, nope. First, I'm salaried, and second I am also a year-round employee; I don't get summers off.
All the better for a snow-day.
March 19, 2010 at 3:45 pm
john.arnott (3/19/2010)
Tom.Thomson (3/19/2010)
March 19, 2010 at 3:44 pm
GilaMonster (3/19/2010)
Lynn Pettis (3/19/2010)
Anybody have some good links to why you should NOT use the NOLOCK hint? Seems everyone writing SELECT queries these days uses that everywhere.
This is the...
March 19, 2010 at 3:39 pm
Dave Ballantyne (3/19/2010)
Lynn Pettis (3/19/2010)
Anybody have some good links to why you should NOT use the NOLOCK hint? Seems everyone writing SELECT queries these days uses that everywhere.
I like...
March 19, 2010 at 3:38 pm
I am going to post a blog on what I did with this script.
I made a bunch of changes to suit my needs. Some of which include the output...
March 19, 2010 at 2:49 pm
Lynn Pettis (3/19/2010)
crookj (3/19/2010)
Lynn Pettis (3/19/2010)
[font="Comic Sans MS"]Snow Day![/font]Lucky!
We still had to work - Guess D11 is scared of a few (million) snow flakes.
Joe
Explaination I got from my Executive Director...
March 19, 2010 at 2:41 pm
2005 also has a migration wizard.
Here is an article that may serve some usefulness.
March 19, 2010 at 2:19 pm
Lynn Pettis (3/19/2010)
CirquedeSQLeil (3/19/2010)
Found it faster than I expected.This one has a few other links on the same topic.
http://blogs.msdn.com/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
I ask for a link, you provide it, and where do I...
March 19, 2010 at 1:59 pm
Lynn Pettis (3/19/2010)
And, you really should consider dropping the use of the NOLOCK hint everywhere. You may want to start by reading this: http://blogs.msdn.com/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx.
Agreed - nolock can cause problems...
March 19, 2010 at 1:57 pm
Take a look at this article and see if it helps.
http://msftdbprodsamples.codeplex.com/wikipage?title=Installing%20Databases
March 19, 2010 at 12:40 pm
john.arnott (3/19/2010)
I don't know that I should be embarrassed by having "missed" my own question, though.
Now I don't feel so bad:cool:
The point of it was to point out...
March 19, 2010 at 12:33 pm
Viewing 15 posts - 16,171 through 16,185 (of 19,564 total)