Viewing 15 posts - 1,036 through 1,050 (of 2,917 total)
I agree with you there about SSIS. It can run and work happily without much help, but boy does it hate change or inconsistencies. Metadata changes and the package fails. ...
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.
July 14, 2021 at 6:52 pm
Where are you seeing that?
The install instructions state:
Installation for the Existing Users
If you have an existing installation of Express with Tools, SQL Server Management Studio Express, or Express with Advanced...
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.
July 14, 2021 at 3:51 pm
I am not sure if or how SSIS would natively handle working with SharePoint Online, but I know there are addons to SSIS (such as ones from CDATA) that can...
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.
July 14, 2021 at 2:45 pm
My company uses SSIS entirely for our ETL.
Our process is the support request comes in for a report to be made. Next, a data person will determine where that data...
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.
July 14, 2021 at 2:36 pm
Quick google brought me to this:
https://www.microsoft.com/en-us/download/details.aspx?id=57473
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.
July 13, 2021 at 6:59 pm
Sounds like you need to register your SPN's. Chances are the SQL Server service account doesn't have permission to register SPN's so you will need to use an account 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.
July 13, 2021 at 5:04 pm
To add to what Steve said, DBMail cannot write to a file on a local folder. If you are looking to write results from a SQL query to file, 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.
July 13, 2021 at 4:02 pm
Since you are seeing the version as 12.0.2000.8, you are not on SP3.
Doing a quick google, I am fairly confident the problem is you downloaded the installer for SQL Server...
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.
July 13, 2021 at 3:53 pm
My 2 complaints about amazon (from a shopping user experience) are the push for prime and the items that qualify for free shipping. Push for prime seems to come at...
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.
July 13, 2021 at 2:36 pm
I read your question a little differently than Grant and Jeff, so I just wanted to confirm what you were looking to do.
If I understand your question correctly, you want...
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.
July 12, 2021 at 7:38 pm
If I remember right, the certificate is bound then for all new connections.
This is easy to test by connecting to the database instance with SSMS with and without the "Encrypt...
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.
July 12, 2021 at 5:47 pm
A repair install doesn't hurt though - it could be something with an update or if your computers were built from a WSUS image (for example) with VS2019 pre-installed, 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.
July 12, 2021 at 3:44 pm
Screenshot is a little hard to read, but I would guess the problem is that the SQL Server Agent user doesn't exist on the database. Looking at the user, 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.
July 9, 2021 at 10:13 pm
They should just need EXECUTE permissions as far as I am aware.
I would double check that you granted permissions on the correct object in the correct database on the correct...
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.
July 9, 2021 at 9:48 pm
I created a script that replicates this behavior but I do not have a good "reason" why this behavior exists, just a theory. Sample script:
DROP TABLE IF...
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.
July 9, 2021 at 9:33 pm
Viewing 15 posts - 1,036 through 1,050 (of 2,917 total)