Viewing 15 posts - 2,881 through 2,895 (of 2,917 total)
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.
January 23, 2017 at 11:38 am
Customer RowNum SalesOrder Customer
(100915) (2) (100915-2) (ARORA)
(100915) (1) (100915-1) (ARORA)
(100576) (1)...
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.
January 23, 2017 at 11:10 am
I liked that question. It was a fun one.
The only reason I can think to do an "EXECUTE AS SELF" thing would be if there was a table 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.
January 18, 2017 at 8:38 am
Yeah, I am thinking it is the system databases that are causing my headache.
Scripting out the logins would have been a huge pain in the behind which is why we...
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.
January 10, 2017 at 12:48 pm
Thanks for the quick reply.
I ran the commands you suggested and got results that I was not expecting:
3 for the first one (FilestreamConfiguredLevel) and 0 for thes second (FilestreamEffectiveLevel). ...
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.
January 10, 2017 at 12:42 pm
First half of that works, but the second half fails.
the "Enable Filestream in Configuration Manager and select all options (IO, remote)" step is already done (also tried cycling the options...
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.
January 10, 2017 at 11:58 am
Sounds to me like the password is incorrect. The database master key is not the same thing as the sa password or anything like that normally unless you changed...
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.
January 10, 2017 at 11:27 am
sbostic (9/30/2016)
Thanks for the information!
Have you gone for your MTA yet? If so, how'd 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.
December 16, 2016 at 9:21 am
Geeze there is a lot I want to do but realistically:
Rogue one
get my new turntable set up properly and listen to a few records
likely some video games (play but not...
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 16, 2016 at 8:13 am
Hello richlion2,
I did not think of the case where disabling the index wasn't an option. I suppose for old SQL versions, that does make more sense then.
With respect 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.
December 9, 2016 at 7:32 am
richlion2 (12/8/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.
December 8, 2016 at 8:20 am
Not a problem. Everybody has days like that.
Plus it is much nicer to find out you missed something simple than to find out that your query really needs 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.
December 6, 2016 at 12:08 pm
Possibly a dumb question but are you using the database as the schema?
That is, in the UPDATE command it should be:
UPDATE <database>.<schema>.<table>
SET dest.[project_id] = stage.[project_id]
...
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 28, 2016 at 3:04 pm
If I understand your question correctly, you are wondering why you would want to specify a listener IP.
Lets say for example, your SQL instance had 2 network cards; one inside...
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 28, 2016 at 2:57 pm
As a thought, could you ask your domain controller manager to check their logs if the account got locked at the time the job failed?
Is it always the "backup" job...
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 17, 2016 at 7:21 am
Viewing 15 posts - 2,881 through 2,895 (of 2,917 total)