The KB article is 893312 and there is a hotfix for this. I think it just made in SP 4 if not it should be in the 2187 rollup. SP 4 has 6 or 7...
I was a getting the same error in my Sql log: 18456 : Login failed for user 'NT AUTHORITYSYSTEM'. It was a different problem but I thought I'd post...
I realize this isn't your version of sql but the message was a match so I thought I'd post it: http://support.microsoft.com/kb/891719 Good luck,...
My shop wants to look into using Sql Server 2005 replication. I checked MSDN and found very little. Does anyone have any resouce links they can...
I did my initial converation on a development server and the named instances worked fine. The default instance had an issue. It only worked for...
I'm considering moving all my Sql Servers off of port 1433. I see from other posts the practice is encouraged and used a fair amount. The actual...
Luis, thanks for answering my post but my question wasn't very clear. Sql Diagnostic manager gives me a several weeks worth of history. The average...
Perfmon and Sql Diagnostic Manager are showing me big swings (3500> to <300) in my page life expectancy. The server has 5 GB RAM so I doubt total...
Last night we rebooted a server to undo the /3gb switch. The shutdown time in the Sql Server log errorlog.2 is: 2005-06-12 21:55:26.48 server...
The issue didn't involve network protocal encryption, it was a memory leak in Sql Server. Microsoft included the hotfix is SP 4 which had 4 other...
Starting in early 2004 our activeactive SQL Server cluster started experiencing intermittent slow downs, mini-dumps, and error messages in the client...
Is there a way to read an extended database property in "database A" if my current database context is "database B"? I'm trying write a procedure to...
The thought is that since I have 8 gb via AWE why short limit the OS to 1 gig. The network guys fear that Windows could get memory starved and would...
My server has 10 gig of physical RAM. Sql Server is using 8 gig via AWE. Do I still need the /3gb switch in my boot.ini? I'm thinking that using...
Does anyone know how to schedule Performance monitor on a regular and ongoing basis? The schedule tab is fine for starting it one time but doesn't...
Separate names with a comma.