Viewing 15 posts - 2,056 through 2,070 (of 2,883 total)
Hello Jeff,
Any update on that code? I am curious to look at it.
February 21, 2020 at 5:35 pm
Drew, I think that both single and double quotes are valid according to the XML standard (or at least my interpretation of it).
Microsoft's interpretation in the .NET framework allows for...
February 21, 2020 at 4:15 pm
I believe your issue here is that code is not being provided a string literal which is required by the XML 1.0 standards.
Similar issue to yours, but slightly different:
His issue...
February 20, 2020 at 9:57 pm
Hello Jeff,
Not sure if it is useful for the OP, but it does look like an interesting report to me.
I would like to have a copy of that if you...
February 19, 2020 at 7:32 pm
Jeff - that script sounds useful. Any chance you could post it on here or link to it on github or something?
Currently, we are using RedGate for our monitoring of...
February 19, 2020 at 3:07 pm
Have a look at this webpage:
https://regex101.com/r/cO8lqs/2
It lets you test out RegEx and it provides an explanation of what the regex is doing.
Your understanding of that part is correct. (.) is...
February 18, 2020 at 9:57 pm
A failed ping also doesn't mean the server is "up". Firewall, for example, could block a ping but the server could still be up.
That being said, if you want fewer...
February 18, 2020 at 9:13 pm
Another thing to check is - is it actually SQL Server using the CPU?
If you have predictable times that the CPU is high, check things out in task manager as...
February 18, 2020 at 8:14 pm
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:
-[\s\S]*?-[\s\S]*?(?=-...
February 11, 2020 at 9:16 pm
Viewing 15 posts - 2,056 through 2,070 (of 2,883 total)