Viewing 15 posts - 1,261 through 1,275 (of 2,917 total)
Alternately to Ant-Green's suggestion, if you go to the SSRS webpage, there is a download button in the top right corner (if you didn't disable it) where you can download...
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.
April 22, 2021 at 6:05 pm
To add to what Grant said, it could also be that there isn't much "new" to add. I forget the version, but I think it was 2014 where a lot...
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.
April 22, 2021 at 6:03 pm
I've not set up a linked server to Access before, but my general checklist for things related to linked servers AND files on disk/network is:
1 - who is it connecting...
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.
April 22, 2021 at 4:15 pm
Having then log out and back in would probably make sense as I expect it would refresh their permissions.
As for what they are doing in SQL, I would be mildly...
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.
April 21, 2021 at 4:18 pm
I think probably what will help you the most is something like this:
https://aka.ms/sql-permissions-poster
It is a rather large poster, but it gives you all SQL related permissions, what they mean and...
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.
April 16, 2021 at 5:43 pm
Granting connect is safe and required if you want a user to be able to connect to the SQL instance.
Granting read is again, something I try not to give away...
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.
April 16, 2021 at 5:37 pm
The only issue I see is if developers don't need to see the definition of an object or the name of a database due to proprietary knowledge in or about...
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.
April 16, 2021 at 3:51 pm
It depends. The favorite DBA answer.
From BOL - https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/snapshot-isolation-in-sql-server
Basically, if you have a lot of updates on the table, you will have a lot of tempdb growth. If the table...
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.
April 16, 2021 at 12:49 pm
My next step then would be to check the error that popped up.
The error message is:
Unable to start the Transact-SQL debugger, could not connect to the Database Engine instance '<instance...
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.
April 15, 2021 at 9:05 pm
With debugging SQL Server code, I do not use the debugger. I've never found it to be that useful with respect to TSQL. Maybe my code is not interesting enough...
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.
April 15, 2021 at 7:01 pm
My opinion - it sounds like strategy one is the way to go. This lets you log all changes and you can select the changes you need to see. What...
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.
April 15, 2021 at 6:10 pm
My next thought is that you removed something that is normally installed on a system (such as a C# redistributable package).
Might not hurt to do a repair install of the...
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.
April 14, 2021 at 2:03 pm
Personally, this sounds like a good fit for an in-place upgrade then. You get to skip over the overhead needed for a migration install and you sound like you have...
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.
April 13, 2021 at 7:59 pm
The log tells you what to do next:
Next step for SQLEngine: Use the following information to resolve the error, uninstall the feature, and then run the installation process again.
Next step...
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.
April 13, 2021 at 7:21 pm
One big reason to do a migration method is that you have a quick and easy rollback method.
One big reason to do an in-place upgrade is no duplication of data.
There...
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.
April 13, 2021 at 6:06 pm
Viewing 15 posts - 1,261 through 1,275 (of 2,917 total)