Viewing 15 posts - 2,131 through 2,145 (of 2,917 total)
I think it may depend on the purpose. If the table is going to be used to store vehicle information to be used by an external system, then Joe's method...
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.
December 3, 2019 at 2:51 pm
Not meaning to hijack the thread from Phil, but the error is clearly stated in the last bit of errors you posted:
Description: "The Microsoft Jet database engine cannot open 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.
December 2, 2019 at 9:42 pm
I would not recommend using VSS for a backup strategy personally. SQL has a built in backup tool; I would use that.
As for the legality of using the tool 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.
November 26, 2019 at 4:16 pm
I am pretty sure that that would violate the license terms for any tool that is out there.
I highly doubt you will find anyone willing to do this for you...
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.
November 26, 2019 at 3:12 pm
My go-to steps for those types of errors are to try ping-ing the server you are connecting to from the machine that cannot connect to make sure it can even...
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.
November 22, 2019 at 9:28 pm
Are you using a SQL Alias to connect? If so, do you get the same error when you connect with the full name? What about if you connect with 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.
November 22, 2019 at 9:18 pm
Anything interesting in the windows event logs?
Might not hurt to look there around the time it crashed to see if there is any other events happening at the same time...
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.
November 22, 2019 at 3:02 pm
I think what you are trying to do using the method you are trying is not possible. You cannot store more than 1 value in a variable except a 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.
November 22, 2019 at 2:03 pm
To insert it into a temp table, just insert it into a temp table instead of into dbo.details. once that is done, to put the values from the temp 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.
November 20, 2019 at 10:02 pm
My job description was a "programmer analyst" and had a lot of stuff about VB6 and C# development. Then as the needs of the department changed, my job title 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.
November 15, 2019 at 2:44 pm
I am chiming in just to say I like the artificial keys when it is being used for a foreign key. As The Dixie Flatline says, client #10006 will be...
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.
November 14, 2019 at 6:31 pm
I got it wrong, but it was because I expected the stored procedure to fail to get created. I am a bit surprised that the stored procedure would get created...
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.
November 7, 2019 at 8:32 pm
I love those "nothing changed" comments. SOMETHING changed or the code wouldn't be slower. Well, most of the time.
When I get those types of things coming to my desk, I...
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.
November 1, 2019 at 8:58 pm
Overall, I like what you did. The code snippets are small and manageable. The only downside to it is when it comes time to debug it.
What I've seen where I...
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.
November 1, 2019 at 2:22 pm
Thanks for the update! And I am glad to hear it went off smoothly!
Some post-upgrade steps (on 2014) that you may want to check are:
1 - update statistics
2 - check...
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.
October 31, 2019 at 6:55 pm
Viewing 15 posts - 2,131 through 2,145 (of 2,917 total)