Viewing 15 posts - 1 through 15 (of 819 total)
That error is strange. It should be executing the stored procedure xp_logininfo against only Windows AD Groups. If it got an error, I'm guessing you don't have permission to look...
February 18, 2020 at 6:48 pm
Did you run profiler/extended events to see which account your query was being run as?
Also, is this a cross database query OR does the view contain cross-database objects?
What I mean...
February 18, 2020 at 3:47 pm
As a thought, what about creating a temporary table (or table variable), with all of the columns you want and populating that table by running both queries. As both queries...
February 14, 2020 at 8:15 pm
EDIT - disregard this post. Your first image showed up and appears to be answered by scdecade.
Your first image is missing so I am not sure what value you are...
February 14, 2020 at 7:54 pm
Granting db_datareader should be all that is needed to have permissions on the view unless you have explicit DENY permissions on the view for a group that user is a...
February 14, 2020 at 3:02 pm
First, did you try what was suggested in the error:
navigate to the report server on the local server machine
Based on what you have tried, my thought on this is it...
February 13, 2020 at 8:26 pm
My regex is extremely rusty, but I think this should do what you are wanting as long as your paragraph and note don't contain a "-" character:
February 11, 2020 at 9:16 pm
With a cursor that should be pretty easy to do.
Something along these lines:
DECLARE @dynamicCount VARCHAR(MAX)DECLARE @dynamicDelete VARCHAR(MAX)DECLARE @tblResult TABLE (ID INT IDENTITY(1,1), [Query] VARCHAR(MAX) )DECLARE cur CURSOR...
February 10, 2020 at 10:02 pm
I think cursors will be your friend here.
Do a cursor with your select from above and store both into variables then loop through the cursor to execute both SQL statements...
February 10, 2020 at 9:09 pm
First step would be to check the execution plans for both of these.
Make sure you are getting the same plan in both cases. If you are getting different plans, this...
February 7, 2020 at 9:48 pm
I think there is a typo in the answer as it describes query number 2 in the answer but mentions a WHERE clause which only exists in Query number 3. ...
February 7, 2020 at 3:54 pm
Can you post the entire result of "summary.txt" file (C:\program files\microsoft sql server\130\setup bootstrap\log\summary.txt)? That usually has the best information about why an install failed.
The messages you psoted there do...
February 4, 2020 at 8:44 pm
does the query COMPLETE in 0 seconds OR does it show you the execution plan in 0 seconds?
February 4, 2020 at 5:42 pm
This is a big "it depends" answer. When you say you are running 15-20 packages daily as "a lot of packages", it makes me wonder how bad my setup is...
February 3, 2020 at 9:05 pm
Just to throw my 2 cents in this, I have a quick and dirty little script template that I did up ages back to help with sp_who2:
January 29, 2020 at 4:19 pm