Viewing 15 posts - 1,936 through 1,950 (of 2,917 total)
I have not seen that exact error, but my guess is that the error isn't being thrown by the SQL Server installer,but being thrown by Windows. My GUESS is that...
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.
May 15, 2020 at 4:30 pm
That is how a firewall is designed though. There are no "shortcuts" with security.
The ONLY other way you can set that up is to allow applications through the firewall instead...
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.
May 15, 2020 at 3:29 pm
CASE statement. I'm not entirely sure where you are running the query, but basically do a check if SYSDATETIMEOFFSET() > Daylight savings start date AND if SYSDATETIMEOFFSET() < Daylight savings...
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.
May 15, 2020 at 2:31 pm
Did you restore the encryption keys using the SSRS configuration tool? Without that, it won't be able to decrypt any encrypted data.
I would recommend checking out this post:
https://stackoverflow.com/questions/46876442/ssrs-migration-from-2008-to-2016/46879292#46879292
and make sure...
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.
May 15, 2020 at 2:22 pm
The post is very confusing. Did you do an inplace upgrade or did you do a migration? I am not sure what an "inplace migration" is. I am also confused...
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.
May 14, 2020 at 9:42 pm
I think if you are stuck on SQL Server 2012, you are going to need to use a CASE statement to handle daylight savings time.
If you can upgrade to 2016,...
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.
May 14, 2020 at 8:48 pm
To add to Frederico_fonseca's response - when I hit snags like that, my first step is to take the innermost portion of the troublesome query section and break it out. ...
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.
May 14, 2020 at 8:37 pm
For something like that, you will need to use dynamic SQL.
Be careful using it though as if it is not designed carefully and with proper safeguards, it is easy to...
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.
May 14, 2020 at 8:25 pm
That is weird that running it in series causes the block as well...
even stranger that running package 1 to call 1 copy of package 2 makes things run successfully.
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.
May 14, 2020 at 4:48 pm
I would capture as much data as I can that makes sense. A timestamp of the import is something I try to capture in the staging and historical tables because...
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.
May 14, 2020 at 4:40 pm
That is a big "it depends" question. OLAP is used for reporting and analytics. OLTP is used for transactional data.
If you have a bunch of data used for application purposes,...
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.
May 14, 2020 at 3:32 pm
SPID -2 is an orphaned DTC transaction:
https://www.sqlskills.com/blogs/paul/disaster-recovery-101-dealing-with-negative-spids-2-and-3/
Another good read on SPID -2:
http://www.eraofdata.com/sql-server/troubleshooting-sql-server/orphaned-msdtc-transactions-2-spids/
So something is starting a distributed transaction and SQL is uncertain on the state of that distributed transaction.
Also, how...
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.
May 14, 2020 at 3:15 pm
My opinion (others may disagree), I try not to denormalize reporting data unless some of the data is going to be used by multiple reports. I try to reduce 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.
May 14, 2020 at 2:47 pm
So it isn't the client then... I am wondering if it could be the mail server.
If it was consistent it would be easier to figure out. If it showed up...
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.
May 14, 2020 at 2:25 pm
As you have Outlook, I'm thinking you likely have Exchange as the back end mail server. Do you have OWA (outlook web access) on the exchange server? I have 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.
May 13, 2020 at 9:16 pm
Viewing 15 posts - 1,936 through 1,950 (of 2,917 total)