@@CPU_BUSY + @@IO_BUSY + @@IDLE represents the total number of CPU ticks. You can fairly accurately represent a CPU busy percentage as:

(CPU_BUSY * 100) / (CPU_BUSY + IO_BUSY +...

To perform this via Query Analyzer, first do (adjust file and path accordingly):

RESTORE FILELISTONLY FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL\Backup\Northwind.BAK'

Take note of the logical file names listed.

Then do (replace...

I too have noticed issues with the Profiler since SP2. In my case, it is filtering on database name. I have had to resort to filtering on database...

Two questions:

1) Are you adding the columns to the end of the table or are you inserting them in between other columns?

2) Is this table referenced by another table (foreign...

You can set the default importance level in Outlook itself. I'm using Outlook 2000 and you can reach that setting by:

Tools menu

Options

E-mail Options button (on first tab - Preferences)

Advanced...

EXEC sp_attach_db @dbname = N'Northwind',

@filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\Northwind.mdf',

@filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\Northwind_log.ldf'

Be sure to adjust the path and/or the...

Also, you can add (custom) database roles to the db_datareader and db_datawriter roles as well. For instance, you could create an 'ProdXAppUser' role within the database, add 'ProdXAppUser' to...

You can also run sp_validatelogins to quickly find any orphaned Windows NT users and groups that no longer exist in the NT environment but still have entries in the SQL...

The MDF, NDF, and LDF extensions Antares686 refers to are the data and log files that SQL Server uses. Since they are not executable, a virus cannot use them...

Exactly what was your DBCC syntax while trying to repair the errors?

That same trick can be used to more efficiently organize your SQL servers in Enterprise Manager as well.

For instance, my SQL servers house multiple products but I organize EM via...

I would also check to ensure that the domain account that SQL Server Agent is configured to start under has sufficient permissions to run as a service. (Your System...

Count your blessings that it is not using all of the available memory. SQL Server will start at the min server memory when it starts up. As it...

You can start in Books On-Line (the SQL Server documentation). It lists all the error numbers, severity levels, etc.

That being said, BoL frequently only scratches the surface. You...

I have encountered the exact same error message while running a stored procedure as a scheduled agent job. The stored procedure only connected to the local server to delete...