Viewing 15 posts - 1,666 through 1,680 (of 2,387 total)
Right Click DYNAMIC database --> New --> Database Diagram --> follow the wizard to generate the diagram.
June 9, 2003 at 12:11 pm
select counter_name, cntr_value from sysperfinfo where counter_name like 'Total Server Memory%'
June 9, 2003 at 10:05 am
Service Pack 3a. Download sql2ksp3.exe from Microsoft and install it.
June 9, 2003 at 9:46 am
My QA in NT workstation shows Version SQL 8.00 760. Go download sql2ksp3a.exe from Microsoft and reinstall it.
June 9, 2003 at 9:34 am
quote:
but Query analyzer still indicated the older version number,8.00.194 not 8.00.690.
How did you get...
June 9, 2003 at 8:51 am
We have done many times backups/restoration accros the network from SQL Server to another machine with only few time failure. The database size is from few GB to 500 GB....
June 9, 2003 at 8:45 am
You need NT service pack 5 or above before applying SQL Server SP3. Download SP3 and run the setup. No sure about Windows 98.
June 9, 2003 at 8:41 am
quote:
why would backups across the network fail?
It is possible that you have an...
June 9, 2003 at 8:33 am
From BOL.
"When an instance of SQL Server starts, it typically acquires 8 to 12 MB of memory to complete the initialization process. After the instance has finished initializing, it acquires...
June 9, 2003 at 8:00 am
See counter SQL Server : Memory Manager/Total Server Memory(KB) that indicates Total amount of dynamic memory the server is currently consuming
June 9, 2003 at 7:45 am
If you can shutdown the SQL Server for a while, copy the MDF and LDF files and you should be able to attach it.
June 6, 2003 at 11:28 am
From BOL.
"In SQL Server 2000, DBCC CHECKDB holds a schema lock on the table to prevent meta data changes while the table is being checked, thus allowing DML statements but...
June 6, 2003 at 10:01 am
quote:
how can I find out what users are assigned to a group?
Are you talking...
June 6, 2003 at 7:36 am
Please ensure restoration of transaction logs is in correct sequence.
June 6, 2003 at 7:27 am
update tblStore set column2 = column1
June 6, 2003 at 7:20 am
Viewing 15 posts - 1,666 through 1,680 (of 2,387 total)