Viewing 15 posts - 5,191 through 5,205 (of 6,105 total)
The only applicable knowledge base article dealing with clustering that pulls up on replres.dll is a SQL Server 7.0 one.
http://support.microsoft.com/default.aspx?scid=kb;en-us;q254593
I'll try to remember to look at my clusters tomorrow...
August 7, 2002 at 6:23 pm
If you look at the services on your system (Start | Settings | Control Panel | Administrative Tools | Services), scroll down until you find the service "Performance Logs and...
August 7, 2002 at 8:25 am
We've a gradual worsening over time with these issues and it appeared to be that SQL Server wasn't always able to make a connection to the Exchange Server, especially during...
August 7, 2002 at 8:17 am
Does the user account have rights to logon as a service for that particular system (I'm reaching here)? I know it's a requirement for the MSSQLSERVER and SQLSERVERAGENT service accounts,...
August 7, 2002 at 8:12 am
Microsoft is getting me more and more disgruntled. Someone needs to start a betting pool on how many more vulnerabilities will be found in SQL Server 2000 before Yukon releases....
August 6, 2002 at 6:51 pm
I've gotten back in the habit of using the top of the keyboard since I bought a second hand laptop off a contractor who had just recently upgraded his. He...
August 6, 2002 at 6:45 pm
I found this in the MS Knowledge Base. Footprint looks similar:
http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;Q318672
K. Brian Kelley
August 6, 2002 at 6:39 pm
It shouldn't need to be a domain admin and besides, you do NOT want developers having access to domain admin rights, period.
A silly question, and you probably are, but...
August 6, 2002 at 6:29 pm
Profiler can be a resource hog if you're attempting to look at too much but it's intended to be run during "production" so a DBA can get a good look...
August 6, 2002 at 6:16 pm
Make sure you use UNION ALL instead of just UNION. On the off-hand chance the counts for both tables come back the same, only one row will be returned. UNION...
August 6, 2002 at 6:01 pm
Are you trying to start a counter log or are you trying to view in real time?
K. Brian Kelley
August 6, 2002 at 5:50 pm
Very true. It also is less costly since it's not filtering out duplicates.
K. Brian Kelley
August 6, 2002 at 5:47 pm
The UPDATE statement has no restrictions as it is currently written and that's why you are seeing every row changed.
Take a look at the inserted table which is available to...
August 5, 2002 at 5:32 pm
Agreed. Using the sa account is a very BAD idea. However, certain apps sometimes require it because of the way they were developed.
K. Brian Kelley
August 5, 2002 at 4:02 pm
If an application is connecting to the server using the sa account (definitely up there for a worst practice), then yes, changing the password can result in the application no...
August 5, 2002 at 2:14 pm
Viewing 15 posts - 5,191 through 5,205 (of 6,105 total)