You are safe, In spite of your best efforts to make a mess SQL 7.0 will not let you harm existing installed components. You will need to exercise your...

John, If your server is HTT enabled then before changing the BIOS to turn off HTT check the code with the Option stated in my previous email to verify that...

Acctually the problem is mostlikely with the Novell desktop settings. I had this issue occur when the script didn't maintain the changes. Icons and setting changes to the *.msc file,...

I am interested in what is the real cause of your cpu problem, I think you haven’t gone deep enough into the way SQL Server utilizes CPU's, The main...

Why do I think I know this Development Manger?  As for the responses to the thread uh...NICE ! (yea yea I have no meaning full...

Not trying to worry you excessively but are you auditing your logins and the like ? If not, set the auditing on Full and verify that you are not getting...

Yes you must install a MAPI client (MS OUTLOOK) and then create an active profile. After this you should be able to configure SQL Mail.

Goodluck

Jim Babington

jbabington@hotmail.com

Attempt to search for the missing .MSC file first. If that can be located you may wish copy it back to the C:\Program Files\Microsoft SQL Server\80\Tools\BINN\ directory.

If not copy...

The simplest answer might be like this:

Are you using Standard Edition ?

Are you using Replication ?

Are you running applications Other than SQL Server or is this a Dedicated DB Server...

Sean,

Sorry About the Format...Since you have provided very basic disk information in relation to the SANs and The server it is difficult to provide or offer a improved performance solution....

Anil and Prakash,

Is this a online production db ? If so what recovery model is set (full, Simple, etc) You wish to shrink THEN remove the Second .LDF correct ?...

Xujohn,

A tad confused but also are you running Outlook for Office 2000 (2003, XP) when you attempt to start the mail service with xp_startmail? Have you attempted to start the...

Xujohn, Just a few questions...

1. One you have under the SQL Server Agent properties tab have you set the default mail profile to be used?

2. Did you stop...

Regarding the issue of the db size, is the size (1800 MB) including the transaction log? If so did you truncate the log? Also since you have converted datatypes from...

Aside from my moronic misspelling of "Virtual", I have found the following information. Conditions:

·Slow Query Performance

·Deadlocking due to resource

Some of these problems traced to when the optimizer decides to...