Forum Replies Created
Viewing 15 posts - 31 through 45 (of 1,189 total)
-
Reply To: Error: 18456, Severity: 14, State: 149, no matter what I try
Thanks to everyone for their help. The issue was resolved by another colleague who discovered that there was a custom endpoint set up. Once the permission to that custom connection...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
Reply To: Error: 18456, Severity: 14, State: 149, no matter what I try
Great question, sorry I didn't provide this info earlier.
So far, I can log in locally and remotely using my AD login. The colleague who reported the issue can also log...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
Reply To: Error: 18456, Severity: 14, State: 149, no matter what I try
Hi Andy, Jonathan,
Thanks so much for your help. Sorry, just to clarify - I have not tested the AD login locally. That user doesn't have (i.e., is not allowed to...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
Reply To: Error: 18456, Severity: 14, State: 149, no matter what I try
One more thing I found: The SQL login works when I remote to the SQL host and log in locally. So it is something that happens for external connections.
Thanks again...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
Reply To: SQL blocking caused by running ALTER VIEW script
PS A little more info:
- I was able to create a view with the same code but a slightly different name. Worked instantly.
- Even trying to drop the original view...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
Reply To: SQL blocking caused by running ALTER VIEW script
Hi Phil,
I checked, and the view definition does not include 'WITH SCHEMABINDING'. But thanks for this info - it will come in handy.
Next I am going to review the SQL...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
Reply To: Some but not all databases in Availability Group are inaccessible
Hi Jeffrey,
Great, thanks for your help. I'll check the logs to see what is different between the two subsets of databases that could be causing this issue.
-- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
Reply To: Troubleshooting TCP Provider: Error code 0x274C
Hi Jo,
Thanks. To be honest, I have not tried much yet, as the connection is not making it to the SQL Server when this issue happens, so nothing is logged...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
Reply To: SSIS - Error: Failed to acquire connection
Note that packages are neither 32- nor 64-bit. But they can be run in 32- or 64-bit mode. A bit like Word really - a .docx is a .docx.
Thanks, I...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
Reply To: Job History says running, but Job Activity says idle
Thanks again, all.
I actually ended up doing nothing, and the next day the job history showed that the job succeeded at that scheduled time. And the previous, "In progress," entry...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
Reply To: Job History says running, but Job Activity says idle
Hi Ed,
The Job Activity Monitor says idle / succeeded.
I'll try your suggestions. Thanks!
-- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
Reply To: Job History says running, but Job Activity says idle
Hi Scott,
This is what I see:
-- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
Reply To: Job History says running, but Job Activity says idle
Thanks Ed,
I tried Refresh, and I even restarted SQL Server Agent. Still the same discrepancy.
-- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
Reply To: Job History says running, but Job Activity says idle
ScottPletcher wrote:What do you mean "the job history says the job is running." The jobhistory never shows that, it only show the past history.
Be sure to verify the instance_id. If...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
Reply To: Can log backups cause Operating system error 32?
Hi Scott, thanks. I'll need to work with our systems team to track down any scanning that might be causing this issue.
Thanks again.
-- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Viewing 15 posts - 31 through 45 (of 1,189 total)