Viewing 15 posts - 346 through 360 (of 2,917 total)
Your powershell is wrong for that. Your convert to HTML call is happening outside of your loop. You will need your convert to HTML to be inside the loop 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.
February 15, 2024 at 6:31 pm
The only thing I can think of is user permissions. Likely something with permission chaining or delegating permissions (not sure if those terms are correct, but I think so). 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.
February 14, 2024 at 10:14 pm
Possibly a dumb question but is your new laptop domain joined and on the corporate network (VPN or on site)?
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.
February 12, 2024 at 10:14 pm
xp_cmdshell runs server side so you would need to be able to browse the directory from the server side not your local dos command line.
My opinion though - 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.
February 12, 2024 at 10:09 pm
I did a quick google on that wait type as I had never seen it and was curious and it sounds like it is not exactly related to memory, but...
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.
February 9, 2024 at 8:56 pm
Just want to point out that requesting a teams meeting with complete strangers on a forum because you are having trouble with a report is a very uncommon thing 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.
February 2, 2024 at 4:50 pm
SQL jobs run as the SQL agent service account. It does NOT run as "sa". That is why you are getting the error. You will notice the error does 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.
January 29, 2024 at 5:18 pm
Sorry for the double post, but I just wanted to add it was a good article. I enjoyed reading it and my reply wasn't saying "don't use ORM's", it was...
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, 2024 at 8:14 pm
What about joining on sys.objects? You could join on the OBJECT_ID(msarticles.name) = objects.object_id from objects and you should be good to go, right?
That would allow to filter out the object...
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, 2024 at 5:34 pm
If you want to exclude something that is a row, you would need to update the WHERE clause to exclude the data you don't need. If you are 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.
January 26, 2024 at 5:14 pm
Login failed means that the account that it is running as doesn't have access to that database. In the error it lists who it is running as (LCDOM100\LCISQL##) and what...
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, 2024 at 5:13 pm
My opinion is a bit biased as I am a DBA as well as a DB Developer (and other roles), but I have not found an ORM that works well...
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, 2024 at 2:33 pm
The service has no access to the network share. The ONLY solutions are to switch it to an account that has access OR store the backup files locally and manually...
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, 2024 at 5:58 pm
My opinion - data cleansing is important to most, if not all, databases. Ideally you have the DB structures set up to prevent garbage from going in, but if garbage...
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, 2024 at 9:19 pm
I am thinking Jeff is probably right - some app is opening a connection and not terminating it when it is done. So you are getting TONS of connections 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 23, 2024 at 6:52 pm
Viewing 15 posts - 346 through 360 (of 2,917 total)