Viewing 15 posts - 31 through 45 (of 52 total)
@@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 +...
May 15, 2003 at 7:45 pm
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...
May 15, 2003 at 7:32 pm
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...
May 15, 2003 at 6:52 pm
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...
May 15, 2003 at 6:44 pm
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...
May 15, 2003 at 6:34 pm
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...
May 15, 2003 at 6:13 pm
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...
May 15, 2003 at 6:08 pm
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...
May 15, 2003 at 5:59 pm
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...
May 15, 2003 at 5:43 pm
Exactly what was your DBCC syntax while trying to repair the errors?
May 15, 2003 at 5:27 pm
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...
May 15, 2003 at 5:20 pm
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...
May 15, 2003 at 5:14 pm
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...
May 15, 2003 at 5:11 pm
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...
May 15, 2003 at 5:06 pm
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...
May 15, 2003 at 5:04 pm
Viewing 15 posts - 31 through 45 (of 52 total)