Viewing 15 posts - 181 through 195 (of 2,917 total)
Quick google brought me this:
The master key is used to encrypt and decrypt sensitive data, such as credentials, that are stored in the database. If the master key is missing...
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.
September 9, 2024 at 7:24 pm
Linked server I think is the only option, but personally, I'd refrain from doing something like this. My style is to keep my stored procedures contained to the system they...
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.
September 9, 2024 at 7:19 pm
SQL won't associate the view with the linked server. You will need to update the code to tell it to use the linked server. IF you break the single system...
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.
September 9, 2024 at 7:13 pm
My GUESS is since you have implicit transactions turned on, the delete is happening in batches and the "sync" is only happening AFTER the transaction completes. So if 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.
September 9, 2024 at 5:34 pm
I'm not sure about your response. Did you configure the SPN's or not? If you didn't, I would configure the SPN's. If you have configured the SPN's, then my next...
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.
September 4, 2024 at 8:26 pm
Sounds like an SPN issue. Did you configure the SPN'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.
September 4, 2024 at 5:47 pm
As a guess - I would say you have no explicit transactions, right? If so, then the commit will happen as soon as the command completes. What I mean 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.
September 4, 2024 at 5:45 pm
My opinion - don't use activity monitor. It is a performance suck on the server and long term runs can cause issues in SSMS too. Plus, some of the metrics...
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.
September 3, 2024 at 2:55 pm
main thing is not to use native SSMS to deploy - either use VS deploy or T-SQL
The risk with a VS deploy though is if you have multiple SSIS...
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.
August 30, 2024 at 4:16 pm
There might be some fair overhead to getting the current length of a text column. If you really have to have that, add a column 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.
August 30, 2024 at 3:34 pm
There might be some fair overhead to getting the current length of a text column. If you really have to have that, add a column to 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.
August 30, 2024 at 3:27 pm
I just wanted to point out that it also depends on how you deploy.
If you deploy using SSMS, the SSMS version MUST be the same as the SSIS version. I've...
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.
August 30, 2024 at 3:20 pm
Just my 2 cents but it feels like you are trying to treat the symptoms and not the problem. What is causing the network hiccups? I would work on addressing...
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.
August 30, 2024 at 3:15 pm
yeah, that's what I'd expect... why'd you use the grater than operator on a string?
Because I told him to. 😉 It works just fine on MAX datatypes. 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.
August 29, 2024 at 7:46 pm
yeah, that's what I'd expect... why'd you use the grater than operator on a string?
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.
August 29, 2024 at 5:13 pm
Viewing 15 posts - 181 through 195 (of 2,917 total)