Viewing 7 posts - 16 through 22 (of 22 total)
Using Enterprise Manager, go to the Server/PC you want to investigate, right click SQL_Server_Name, Properties. On the "General" tab you'll see the version information you're looking, including SQL Server version,...
January 17, 2002 at 1:32 pm
What does your Event Log say about this system error message?
Cabby
cabby2583
Always Learn!
January 14, 2002 at 7:16 am
My understanding of the SA user account is that it should be used sparingly. As in, give it a complex password, lock it up in a safe and use it...
January 9, 2002 at 1:27 am
Absolutely agree with comments above concerning losing sequential data due to maintaning multiple logs on mirrored drives/RAID sets. I'm real interested in learning more from others regarding maintenance/storage of logs...
January 1, 2002 at 10:30 am
From a performance standpoint, it's not recommended to mix transaction logs and data. T logs are sequential, so this means that your drive heads can find the information quickly and...
January 1, 2002 at 12:54 am
I've used IBM, Dell and Compaq servers as a customer and supported Compaq Industry Standard Server products as an employee of Compaq. Some additional engineering goes into the design and...
January 1, 2002 at 12:13 am
Outstanding article and thought provoking issues. It's obvious from everyone's comments that the DBA field is evolving very rapidly. As an experienced MCSE (NT4.0 and W2K certified), but relative SQL...
December 31, 2001 at 12:18 pm
Viewing 7 posts - 16 through 22 (of 22 total)