Viewing 15 posts - 2,716 through 2,730 (of 5,111 total)
Without DDL and consumable Sample Data, this is untested, and I have assumed that the First, Middle, and Last names will be the same in both copies, but this might...
November 1, 2017 at 8:20 am
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...
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]...
November 1, 2017 at 6:56 am
Dear Thom
My apologies for the incomplete information and yes i tried using CTEs and it...
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...
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...
November 1, 2017 at 5:08 am
SELECT distinct
November 1, 2017 at 4:55 am
Yes i updated the query but the issue isnt there its with this
Msg 207,...
November 1, 2017 at 4:48 am
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...
November 1, 2017 at 4:28 am
What is your question?
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...
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?
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.
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...
October 31, 2017 at 12:20 pm
Viewing 15 posts - 2,716 through 2,730 (of 5,111 total)