2004-02-15
1 reads
counter
RE: Writing to a log within a stored procedure.
the Log RAISEERROR uses are the Windows Application Log and the SQL Server Error Log!!!!
2004-02-13
RE: Use another port instead of 1433
I don't know about other readers, but I'm kinda confused. I get these two: 1. You have SQL Server Personnal Edition on your home computer. 2. You have Enterprise Manager on your home computer. But what I'm confused about is what are you trying to connect to? a. YOUR SQL Server? or b. a REMOTE […]
2003-06-02
1 reads
RE: Use another port instead of 1433
Go the other port route. One of the reasons to block on 1433 has to do with the SQL Spida worm (SQL Snake, SQL Sapphire, etc.) and the one that came out before that. They make a connection on 1433 and try to login as sa with no password. Hence, if you block 1433, those […]
2003-05-30
1 reads
2003-05-28
1 reads
RE: Clustering: Node removed from cluster
I think we found the root cause. The MSDTC had stopped and was unable to start. The error said that it can't start because it wasn't configured to run in a cluster. Please run comclust.exe. This doesn't make sense because it was previously running in a cluster. Can I run this safely and not affect […]
2003-05-28
1 reads
RE: Clustering: Node removed from cluster
Cluster Service must be running at all times on all nodes.
2003-05-27
1 reads
RE: Clustering: Node removed from cluster
I'll check the passords, thanks. It hasn't been evicted. It just lost communication. However, I can ping the server and it sees it. Also, should the Cluster Service always be running on both nodes? I just noticed it's stopped on inactive node. Darren
2003-05-27
1 reads
RE: Why an overflow?
Thanks, I just re-read BOL for the fourth time and the light clicked on in my head. At that moment I go the email that you had replied. Read your reply and the puzzle was complete. Thanks, Ross
2003-05-27
RE: Why an overflow?
You only secifie the maximum total number (3) of decimal digits that can be stored, both to the left and to the right of the decimal point. The maxium number can only be 99.9
2003-05-27
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers