Viewing 15 posts - 18,901 through 18,915 (of 19,564 total)
Please post your attempts. If you post what you have tried, we can better help you. Along with queries, it will be helpful to post table structures. ...
December 7, 2009 at 10:29 am
Something that would be helpful in answering this would be to know page counts for your tables. It would also be helpful to see what kinds of indexes you...
December 7, 2009 at 10:20 am
GSquared (12/7/2009)
The reason I use cursors for this kind of thing, instead of "quirky update" string building, is that I can wrap each command in error handling much more easily.
This...
December 7, 2009 at 10:05 am
rambilla4 (12/7/2009)
There is an integral piece of information. Knowing that the server is clustered is essential information for the answer.
Using net stop net start for the services will cause...
December 7, 2009 at 10:01 am
GilaMonster (12/7/2009)
Steve Jones - Editor (12/7/2009)
OK, I couldn't resist: http://www.sqlservercentral.com/Forums/Topic829828-338-1.aspxBeautiful.
Yes, indeed. Most excellent.
December 7, 2009 at 9:47 am
GilaMonster (12/7/2009)
Grant Fritchey (12/7/2009)
Nah, I'm just peeved because of... well, read for yourself.
Oh man. Bob, I LOVE your reply to that thread. What I was thinking, but too polite to...
December 7, 2009 at 9:39 am
Grant Fritchey (12/7/2009)
Alvin Ramard (12/7/2009)
Grant Fritchey (12/7/2009)
Alvin Ramard (12/7/2009)
Lynn Pettis (12/7/2009)
Bob Hovious 24601 (12/7/2009)
December 7, 2009 at 9:29 am
Alvin Ramard (12/7/2009)
Lynn Pettis (12/7/2009)
Bob Hovious 24601 (12/7/2009)
Now if they had said "Help me with this, please, Expert." that would have been another matter entirely. 😉
Maybe just a extra...
December 7, 2009 at 9:21 am
GilaMonster (12/7/2009)
Hmmm. Just got email from random SSC member. Starts "Help me with this" then goes on for 2 pages. Looked like homework too.Shift-Delete
LOL
December 7, 2009 at 9:18 am
There is an integral piece of information. Knowing that the server is clustered is essential information for the answer.
Using net stop net start for the services will cause the...
December 7, 2009 at 8:31 am
The article referenced is speaking of starting SQLSERVER.EXE from the command prompt, not stopping and starting services using net commands.
In the article, it discusses stopping the services using net commands...
December 6, 2009 at 5:04 pm
Should the line:
AND b.HC_STAFFID = isnull(@HC_STAFFID, b.HC_STAFFID)
be as is, or should it be the following?
AND b.HC_STAFFID = isnull(@STAFFID, b.HC_STAFFID)
I don't see a variable declared for @HC_StaffID.
December 6, 2009 at 4:55 pm
Nice catch Steve.
You will need to replace 'sa' with the Role for which you wish to grant access. As Steve stated, you should grant permissions to a...
December 5, 2009 at 8:32 pm
Viewing 15 posts - 18,901 through 18,915 (of 19,564 total)