Viewing 15 posts - 1,621 through 1,635 (of 2,008 total)
GilaMonster (11/14/2011)
Dev (11/14/2011)
That's why the join was not throwing a syntax error
So you are saying it's runtime / logical error...
No, it's a binding error.
I heard it first time....
November 14, 2011 at 5:52 am
Ninja's_RGR'us (11/14/2011)
Dev (11/14/2011)
That's why the join was not throwing a syntax error
So you are saying it's runtime / logical error...
No his problem is that he didn't reference BOTH...
November 14, 2011 at 5:42 am
but that is not standard SQL, support for that construct may be removed in future (not any time soon, though)
I was unaware of this fact. Are you sure on it?
It...
November 14, 2011 at 5:36 am
That's why the join was not throwing a syntax error
So you are saying it's runtime / logical error...
November 14, 2011 at 5:31 am
Please post dependent Tables (& Index) DDLs & Execution Plan for analysis.
November 14, 2011 at 5:23 am
You don't have the 2nd table in the FROM
In fact there is no FROM clause in OP's query... 😉
November 14, 2011 at 5:17 am
anthony.green (11/14/2011)
Dev (11/14/2011)
Safe Mode will automatically enable it again (temporarily, for that
Safe Mode session).
Disclaimer: NOT TESTED....
November 14, 2011 at 5:14 am
Shouldn't it be like this?
FROM Addresses
INNER JOIN dbo.Addresses addressescapscan on dbo.Addresses.dqid = dbo.addresscapscan.dqid
November 14, 2011 at 5:07 am
If you have disabled the built-in Administrator account, booting into
Safe Mode will automatically enable it again (temporarily, for that
Safe Mode session).
Disclaimer: NOT TESTED. Post by an ‘MS-MVP...
November 14, 2011 at 4:39 am
Same (or almost same) discussion & weird (and risky) solutions here. Try them at your own risk.
SA account Locked out
November 14, 2011 at 4:17 am
I accidently disabled login for my windows account named "Administartor".
And this is my question... If you have rights to Disable it, it means you have to rights to Enable it...
November 14, 2011 at 4:01 am
Basically I want to say if there is a division by 0 error then NA or something similar
Check it before you Divide By Zero (0).
Something like this:
CASE
...
November 14, 2011 at 3:50 am
memymasta (11/14/2011)
Is it not enabled? Or you are not SA?
I dont remember the password for sa, but i am dba, running the server on local machine.
I don't understand it. How...
November 14, 2011 at 3:41 am
dont have access to sa...
Is it not enabled? Or you are not SA?
If second, Let your SQL Server DBA handle it.
November 14, 2011 at 3:34 am
I accidently disabled admin acc,
Then enable it (yourself ot with help of IT Support).
November 14, 2011 at 3:30 am
Viewing 15 posts - 1,621 through 1,635 (of 2,008 total)