Viewing 15 posts - 41,791 through 41,805 (of 49,571 total)
jonathan (1/13/2009)
SQL 2005 Server but I did not hit the error...
January 13, 2009 at 7:28 am
karthikeyan (1/13/2009)
what do you mean by database activity ?
Activity within the database. Users running queries.
January 13, 2009 at 1:04 am
Abhijit More (1/13/2009)
select distinct object_name(object_id) as Table, rowsfrom sys.partitions where index_id >= 1
and object_name(object_id) not like 'sys%'
and rows > 100
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the...
January 13, 2009 at 1:02 am
Check the SQL error log. The message just indicates that your query has been forcefully disconnected. That's usually the result of the connection been killed by someone, or the result...
January 13, 2009 at 12:47 am
You can shrink it. I wouldn't do it to a minimum value, the log will probably have to grow again if you do.
If you don't need or want point-in-time recovery...
January 12, 2009 at 11:58 pm
Please run the following query in that database. What does it return?
SELECT count(*) from sys.objects
where name = 'PK__EventStage__46AF6B36'
January 12, 2009 at 11:55 pm
Please don't create new threads for existing questions.
http://www.sqlservercentral.com/Forums/Topic616604-357-1.aspx
January 12, 2009 at 11:52 pm
Carlton Leach (1/12/2009)
Hi Gail,so DB_2 (Status = normal) that has autoclose set to on will have to complete recovery operations the next time it is accessed?
No, that one is...
January 12, 2009 at 2:24 pm
RJ (1/12/2009)
January 12, 2009 at 2:21 pm
It means that the database has been closed and the when it was closed SQL was able to finish all transactions and write all dirty pages to disk. Hence no...
January 12, 2009 at 2:11 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic634841-17-1.aspx
January 12, 2009 at 1:40 pm
The_SQL_DBA (1/12/2009)
USE msdbSELECT TOP(30) OBJECT_NAME(object_id), rows
FROM sys.partitions
ORDER BY rows DESC
How's that going to find what's filled the transaction log up?
January 12, 2009 at 1:39 pm
SanjayAttray (1/12/2009)
Instead you can put msdb, model and master database in simple recovery mode and take full backup every night.
Just bear in mind that if you put Model into...
January 12, 2009 at 1:36 pm
madhu.arda (1/12/2009)
January 12, 2009 at 1:32 pm
What SQL's probably doing is a seek on index 1 that retrieves all the rows that match on first name, then a seek on index 2 to retrieve all that...
January 12, 2009 at 1:27 pm
Viewing 15 posts - 41,791 through 41,805 (of 49,571 total)