Viewing 15 posts - 2,101 through 2,115 (of 2,917 total)
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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]*?(?=-...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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. ...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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?
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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:
DECLARE...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
January 29, 2020 at 4:19 pm
Was working with a different forum member (Sue_H) and she pointed me in the right direction and pointed me to a process I did that is likely the culprit -...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
January 27, 2020 at 9:50 pm
Hello Jeff,
Thanks for the reply. As for the reboot, I had to do some maintenance on our servers on the 18th and at that time we rebooted them. Unfortunately, rebooting...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
January 27, 2020 at 2:03 pm
My advice - test everything that you want to be certain works after the upgrade. I would test a backup, a restore, dbcc checkdb, update statistics, reorganize indexes, all features...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
January 21, 2020 at 7:16 pm
Viewing 15 posts - 2,101 through 2,115 (of 2,917 total)