Viewing 15 posts - 2,686 through 2,700 (of 2,903 total)
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
The port change has to be made on the SQL Server itself not on the client side. Then the clients have to set up the ODBC connection to that port....
June 3, 2003 at 6:29 am
Viewing 15 posts - 2,686 through 2,700 (of 2,903 total)