Viewing 15 posts - 166 through 180 (of 213 total)
his question appeared to read how much server memory is in use, not available.
quote:
According to perfmon definition, 'maximum workspace memory' is...
June 9, 2003 at 2:44 pm
would that query with 'maximum workspace memory' be the memory in use.
quote:
select counter_name, cntr_value from sysperfinfo where counter_name like 'Total Server Memory%'...
June 9, 2003 at 1:31 pm
here is the exact error message
Server: Msg 3241, Level 16, State 37, Line 1
The media family on device 'e:\sqlserver\mssql\backup\attain_tlog_200306030900.TRN'
is incorrectly formed. SQL Server cannot process this media family.
Server: Msg...
June 6, 2003 at 8:59 am
that is a different error message
quote:
Please ensure restoration of transaction logs is in correct sequence.
June 6, 2003 at 8:55 am
actually that is the first thing i tried was the dbcc traceon(3111) but i got the same error
quote:
Try launching the trace flag...
June 6, 2003 at 7:05 am
the trn file the backup file
quote:
You mean the Transaction log? Or the transaction log Backup file? If you are referring to the...
June 5, 2003 at 1:40 pm
June 3, 2003 at 1:25 pm
June 3, 2003 at 1:25 pm
of course i believe in the 'records should never be deleted only have a status set theory' since one status field takes less space than a whole table. Plus...
May 30, 2003 at 2:41 pm
since it sounds like copying is what you do the most the raid configuration can make quite a difference especially if you are using raid 5 now. I had...
May 30, 2003 at 2:36 pm
/* i use this script to fix database users when i move databases to a different server.
*/
declare @username varchar(100)
declare @usersid varchar(500)
declare @sql_cmd varchar(5000)
-- This gets all of the cc info...
May 30, 2003 at 2:28 pm
actually you should use what is best for the situation, we have a database with 30000 tables in it which can only be logged shipped, but because it can create...
May 14, 2003 at 8:43 am
actually that would only work with syslogins
Sysusers table in the read only database is the problem. I can work on the logins but not the sysusers since the database...
April 14, 2003 at 12:54 pm
that option terminates users who are connected before update, not users in the database. If somebody is fired and i am removing there login it comes of the production...
April 14, 2003 at 12:08 pm
actually that didnt work because it said it was in the middle of a restore.
quote:
try this:EXEC @retval = sp_replicationdboption '<database>', '<publication type>',...
April 10, 2003 at 2:34 pm
Viewing 15 posts - 166 through 180 (of 213 total)