Viewing 15 posts - 2,656 through 2,670 (of 2,917 total)
This could be a dumb question as I don't know a lot about oracle, but isn't there an ODBC connection for oracle? If so, couldn't you run the whole thing...
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.
April 13, 2017 at 8:43 am
badOedipus - Wednesday, April 12, 2017 10:53 PMA dbcc freesessioncache command should clear the plain text password from the logs.
That should clear...
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.
April 13, 2017 at 8:22 am
I betcha windows saw the app get changed when you did windows updates so it thought it was a different app (the hash of the file didn't match up). 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.
April 13, 2017 at 8:10 am
Glad I could help. I knew you could add programs through too, I just personally like having the port instead of the whole program as it feels like I have...
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.
April 12, 2017 at 4:12 pm
How slow is the query if you run it directly on the server instead of through openquery?
and what if you use a linked server connection and just use 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.
April 12, 2017 at 3:37 pm
Any reason not to set up a file share on a network drive with restricted permissions (IT department and SSRS account for example) that could store the reports and then...
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.
April 12, 2017 at 3:31 pm
The easy way is to use add/remove programs. But if that isn't working, I'd download a copy of SQL Express (it is free), and use that to remove the instance. 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.
April 12, 2017 at 3:21 pm
As a thought - does connecting as hdcvs-lims-sql\ss2016, 49559 work? I expect that it will.
If so, then it is likely your firewall is blocking connection on port 1434...
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.
April 12, 2017 at 3:17 pm
When you say the original media files are not present, do you mean the installation files or do you mean the "c:\program files" folder for SQL express got deleted?
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.
April 12, 2017 at 3:05 pm
I agree with Sue that MS will likely be your best bet. But I know from talking with their licensing experts that they use the term "expert" loosly. I talked...
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.
April 12, 2017 at 1:47 pm
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.
April 11, 2017 at 4:23 pm
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.
April 11, 2017 at 8:24 am
As an alternate to using a cursor for each DB, could you use:EXEC sp_Msforeachdb 'INSERT INTO #nonexistent (IndexName,TableName,DB)
SELECT ic.IndexName,ic.TableName,DB_NAME() AS DB
FROM MONITORING.dbo.IDXCHECK ic
LEFT OUTER...
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.
April 10, 2017 at 4:26 pm
$ admin shares can only be accessed by...
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.
April 7, 2017 at 9:12 am
I still think the most likely culprit is that you have 13K files to write to. How many physical disks are you writing to? I'd be willing to bet 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.
April 6, 2017 at 9:00 am
Viewing 15 posts - 2,656 through 2,670 (of 2,917 total)