Viewing 15 posts - 1,006 through 1,020 (of 2,917 total)
I am pretty sure that SSMS doesn't include dtexec, but your coworker could confirm this by running dtexec outside of excel. You listed the command that excel is trying 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.
July 23, 2021 at 9:59 pm
My preference is option 1 because then the command will write all the output PLUS the errors to the log file. It also allows you to have 2 logs -...
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 23, 2021 at 9:08 pm
What 3rd party database backup tool are you using and where is it writing the backups to?
I personally like having my backups available for me to restore to test systems...
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 23, 2021 at 9:02 pm
NOTE - I do not use AG's nor have I configured them before. I am just replying based on my interpretation of the errors you have.
If memory serves, the logins...
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 23, 2021 at 7:56 pm
Does your coworker have dtexec installed? If not, he can't run something doesn't exist on his system.
I would start out by looking at the error messages. If it works for...
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 23, 2021 at 7:51 pm
This is one of those "it depends" situations. According to the Microsoft documentation (found here https://docs.microsoft.com/en-us/previous-versions/dotnet/framework/data/adonet/sql/managing-permissions-with-stored-procedures-in-sql-server), it states:
Stored procedures take advantage of ownership chaining to provide access to data so...
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 22, 2021 at 5:33 pm
Personally, I don't like that security model as I like working with a "least privilege" model. I generally apply permissions as part of my object creation scripts.
Now, if you DO...
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 22, 2021 at 5:01 pm
Step 1 - check the logs.
I would probably reach out to the server admins (and check the logs) to determine why starting the service as a user other than 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 22, 2021 at 3:02 pm
As a random guess - I would say that in the presentation, entityID was an INT IDENTITY(1,1) and in your code, it doesn't seem to be an IDENTITY type. So...
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 21, 2021 at 9:05 pm
Possibly a dumb question but do you need those WHERE clauses? If the data is the same, setting the value "10" to "10" is not going to hurt too badly...
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 21, 2021 at 4:03 pm
I think I would approach this by using endnum+1 = LEAD(begnum,1). This will help you determine if it is a gap or not; lets call this bitGAP. You can use...
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 20, 2021 at 9:30 pm
To confirm - it only happens on 1 of the 2 read-only secondary systems, correct?
If so, may not hurt to investigate any differences between the 2 systems.
Probably a shot in...
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 20, 2021 at 8:22 pm
I was just reviewing what you had on your site and noticed a few mildly concerning things that may just need more clarification to me.
First, you say "Below is an...
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 20, 2021 at 8:03 pm
To make the post a bit more clear, These are the links to the articles about the ebooks:
https://www.sqlservercentral.com/books/best-of-sqlservercentral-volumes-1-4
https://www.sqlservercentral.com/books/best-of-sqlservercentral-volume-5
https://www.sqlservercentral.com/books/best-of-sqlservercentral-volume-6
https://www.sqlservercentral.com/articles/the-best-of-sqlservercentral-vol-7
All of these bring up articles about the ebooks, but appear to bring...
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 20, 2021 at 5:20 pm
First, I should clarify I don't use AG's so my advice may be way out to left field, but I do not think it is bad advice.
Have you checked 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 20, 2021 at 5:12 pm
Viewing 15 posts - 1,006 through 1,020 (of 2,917 total)