Viewing 15 posts - 2,686 through 2,700 (of 2,904 total)
It depends on how your cluster is set up. Active/Passive means that ONLY ONE node can 'see' the virtual server(s) (shared disks) at one time. The cluster and virtual server(s)...
June 12, 2003 at 1:17 pm
Why reboot SQL Server 2000 on a schedule? Well, I found a reason this week. Luckily I didn't get burned. I have a Win2K Advanced Server 2000 active/passive cluster, it's...
June 12, 2003 at 12:53 pm
The SQL Server may have been created and set to listen to a port other than 1433. Especially if you have virtual servers. We have two virtual servers on one...
June 12, 2003 at 12:41 pm
<SLAP ON THE FOREHEAD>. Thanks, I never even saw the Test Center link. My only excuse is that I've used this site so much I know where the links are...
June 11, 2003 at 6:55 am
I have SQL Server 2000 on a MS Windows 2000 Advanced Server active/passive cluster. I rarely reboot my servers. They normally only get rebooted when I add software that requires...
June 11, 2003 at 6:49 am
Here's the problem:
WHERE (LEDef_ActiveInd = 1) OR(LEDef_ActiveInd = 1) AND (LEDef_Cd LIKE '10%')
You are asking:
Give me LEDef_ActiveInd = 1, OR give me (LEDef_ActiveInd = 1) AND (LEDef_Cd LIKE '10%').
So, when...
June 10, 2003 at 11:28 am
I agree with psclvn, it looks like you have SQLSERVERAGENT service set to run under the SA account. I suggest checking that and MSSQLSERVER service account. If either or both...
June 10, 2003 at 8:23 am
winash,
No, you weren't missing anything. I made a mistake.
-SQLBill
June 9, 2003 at 10:12 am
Does the time represent hours? ie: 05:00:00 = 5 hours
Will there be minutes and seconds?
I would add the varchar data as it is:
05:00:00 plus 36:00:00 equals 41:00:00
then divide it by...
June 5, 2003 at 11:32 am
Shas3 is correct. Consider that as far as SQL Server is concerned - SA is GOD. GOD can do anything, you can not stop GOD. But you CAN stop other...
June 5, 2003 at 10:13 am
How did you 'define' your decimal field? The proper syntax is:
DECIMAL(p,s)
p=precision - the number of digits total
s=scale - number of digits to the right of the decimal.
So, to be able...
June 4, 2003 at 1:01 pm
What command(s) are you using to backup the database? Maybe there's a typo or error in it.
-SQLBill
June 4, 2003 at 5:39 am
The answer depends on what you are actually backing up...
.mdf and .ldf files:
Use the sp_attach_single_db_file command to attach the .mdf
actual backup files created by BACKUP DATABASE command.
Use RESTORE DATABASE command...
June 4, 2003 at 5:37 am
Yes, COX is acting as a CALLER ID and is not allowing you access.
If the business that owns the SQL Server requires you to be able to access it from...
June 4, 2003 at 5:32 am
By the way, it appears you may be mis-understanding how ports work. Let me provide an analogy (if you do understand ports, please forgive me).
I (server) have a phone number...
June 3, 2003 at 6:40 am
Viewing 15 posts - 2,686 through 2,700 (of 2,904 total)