Viewing 15 posts - 2,641 through 2,655 (of 2,903 total)
A difference between the OP and Phil Parkin's post that I noticed is that the OP used the code page 65001, and Phil used 1252.
I am wondering a...
April 13, 2017 at 10:34 am
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...
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...
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).
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...
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...
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...
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.
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...
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...
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...
April 12, 2017 at 1:47 pm
April 11, 2017 at 4:23 pm
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...
April 10, 2017 at 4:26 pm
$ admin shares can only be accessed by...
April 7, 2017 at 9:12 am
Viewing 15 posts - 2,641 through 2,655 (of 2,903 total)