Viewing 15 posts - 676 through 690 (of 2,917 total)
Something to note - installing an unsupported application (SQL 2000) on an unsupported OS (any that would support SQL 2000) will result in an unsupported scenario.
That being said, a quick...
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 31, 2022 at 3:01 pm
My opinion - check the logs. The message "the login failed" makes me think that the account was locked out or otherwise disabled. If it is an AD account, 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.
January 31, 2022 at 2:49 pm
Is it always failing on the same file? If so, then it is likely something with that file and the restore. If it is sometimes failing on that file 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.
January 28, 2022 at 10:17 pm
My approach is to design the database with restrictions in place to begin with. Use roles to restrict what data a user is allowed to access. I expect (ie hope)...
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 28, 2022 at 10:12 pm
Might not hurt to check out the Exchange error logs and see what those say. Could be something that is easily corrected by reviewing the logs on the other side...
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 28, 2022 at 10:00 pm
SSRS Standard, as far as I am aware, doesn't support clustering and only allows you to host it on 1 server.
I believe you would need to upgrade to Enterprise 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.
January 28, 2022 at 9:47 pm
You could use ISNUMERIC.
Personally, if I COULD I would be changing the application that puts the data into the system to validate it and refuse to store invalid data.
Failing 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 28, 2022 at 9:43 pm
I've been noticing this too. Hopefully it gets fixed soon.
I DO get notifications to new private messages, but not to replies to forum posts...
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 28, 2022 at 9:36 pm
Alternately, if you don't have a VS subscription, you could reach out to the company you purchased SQL Server 2012 from and they should be able to provide you with...
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 28, 2022 at 9:36 pm
My opinion - I would do whatever works best for the tool you are using. BUT I would also be careful about using a tool to monitor SQL error 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.
January 27, 2022 at 2:25 pm
My advice - review the error and check the logs.
The error should tell you what is wrong, and in the event it doesn't, the logs should tell you what 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.
January 26, 2022 at 7:26 pm
Things that I would check are:
1 - does the service account have permissions to the folder AND file?
2 - does any other application or service have the file open 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.
January 26, 2022 at 3:44 pm
With our system, we had turned on successful login logging on one of our systems and had a HUGE performance hit to the database. The problem was caused by how...
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 25, 2022 at 7:10 pm
Without seeing an execution plan or ddl, I the below are just guesses.
Depending on the number of rows returned by your nested select, you may get better performance by changing...
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 24, 2022 at 5:55 pm
Have you tried opening the master key by password and adding encryption by service master key?
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 21, 2022 at 7:44 pm
Viewing 15 posts - 676 through 690 (of 2,917 total)