Viewing 15 posts - 2,716 through 2,730 (of 5,109 total)
As I said before, permissions are cumulative.
If the Group NT\TestUsers has a User on another database, such as msdb, then NT\tuser will have those permissions; they are a...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 8:04 am
No, there is no SQL Login for NT\Thom.
So, as a quick test, I logged into our Sandbox server and ran the following (some details obscured):CREATE LOGIN [NT\TestUsers]...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 6:56 am
Dear Thom
My apologies for the incomplete information and yes i tried using CTEs and it...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 5:35 am
AD and group permissions are cumulative; which is why this works.
So, you have a User, which is part of the AD Group SQLUsers. That Group has permission to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 5:24 am
OK, now I see your problem. Your initial post was misleading, as it made it seem that the name of the columns in your table were terminal and Direction; they...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 5:08 am
SELECT distinct
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 4:55 am
Yes i updated the query but the issue isnt there its with this
Msg 207,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 4:48 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 4:47 am
Use a WHERE clause and filter to rows WHERE Direction IS NOT NULL.
Also, if you don't want your CASE expression to return a NULL, use...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 4:28 am
What is your question?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 3:32 am
Ok, well I've created the DDL and DLM for you, but you should really do this yourself.
Now, I've kind of guessed what you mean still, but I've assumed...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 3:30 am
What do you mean by "value = search criteria I will give"? Could Could you be providing a varying different number of parameters to search for?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 1, 2017 at 3:15 am
Aclustered index on the base tables is going to be a huge improvement. I'd suggest following Scott's advice.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2017 at 12:22 pm
I used to see these errors a lot with SQL Search from RedGate. If you have all the databases ticked, it would try to search the offline databases, generating the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2017 at 12:20 pm
600M records is a LOT of records. Even if your disc speed (both read and write) is great, upi have loads of RAM, etc, it is going to take a...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2017 at 9:56 am
Viewing 15 posts - 2,716 through 2,730 (of 5,109 total)