Viewing 15 posts - 5,341 through 5,355 (of 6,678 total)
Did you add a BEGIN TRANSACTION somewhere?
April 20, 2009 at 10:52 am
Maybe a group policy for that server is causing the problem?
April 20, 2009 at 10:39 am
Verify the settings on the AD account - make sure the password is not getting reset or the account is not getting locked out.
The account could be getting locked if...
April 20, 2009 at 10:26 am
Bob Hovious (4/20/2009)
April 20, 2009 at 9:46 am
WebTechie38 (4/17/2009)
I am learning so much from this forum! I like to research and investigate and come up with a strategy or a thought. Then I bounce...
April 19, 2009 at 7:52 pm
Yes - all it will take is a single weekend where you don't get the notifications of the job failures and you will no longer have any backups available online.
April 19, 2009 at 10:38 am
Yes - I have a suggestion. Read the article I link to in my signature.
I can guarantee that you do NOT want to loop through the tables. Whatever...
April 18, 2009 at 9:22 am
Phil Parkin (4/17/2009)
Jeffrey Williams (4/17/2009)
...
The permissions on the services appear to be correct - and shouldn't need to be changed. ...
April 17, 2009 at 8:21 pm
I see - you are using the query builder, which does stupid things like that. What you should do is just open a new query window and write the...
April 17, 2009 at 8:15 pm
As Lynn pointed out - change your join to an outer join. Also, get rid of the TOP 100 PERCENT - it is doing nothing at all for you...
April 17, 2009 at 5:25 pm
The error message is telling you what the problem is:
The process exit code was "1" while the expected was "0". End Error
Most likely, the utility/script you are using is...
April 17, 2009 at 5:22 pm
That is correct, once you have fully tested the cluster failover - all drives will be visible from both nodes and only accessible from the node where the resource exists.
This...
April 17, 2009 at 4:18 pm
d short (4/17/2009)
I understand that SQL Server treats blanks as '1/1/1900', at least in display. What I don't understand is the reverse, why...
April 17, 2009 at 4:15 pm
The drives will be visible but not accessible from node 2.
April 17, 2009 at 3:36 pm
Not sure I follow you - with your example script, the only date column that is blank is the one where you don't insert anything:
insert #testdate2 ( descr) values('null')
The date...
April 17, 2009 at 2:49 pm
Viewing 15 posts - 5,341 through 5,355 (of 6,678 total)