Viewing 15 posts - 41,776 through 41,790 (of 49,562 total)
RBarryYoung (1/13/2009)
January 13, 2009 at 11:19 am
Don't use profiler, at least not the gui. Use the server-side trace procedures (sp_trace_*) and write the output to a file on a fast disk. That's the lowest impact way...
January 13, 2009 at 11:11 am
Grant Fritchey (1/13/2009)
Let me restate "Ask Microsoft or Gail"There, that's better.
Nah. I know what it runs and vaguely what that does, but not the details. I mean, DBCC Autopilot????
Besides, that's...
January 13, 2009 at 10:47 am
Steve Jones - Editor (1/13/2009)
Hmmmmm, I think I...
January 13, 2009 at 10:47 am
DTA's got two undocumented features that it uses to do evaluations of cost improvement. One is the hypothetical index (an index that has all the metadata and stats of a...
January 13, 2009 at 7:41 am
Can you ask the domain administrator (whoever runs the AD there) to see if the two SQL Servers are enabled for Kerberos delegation? It's a setting at the AD level,...
January 13, 2009 at 7:29 am
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
Viewing 15 posts - 41,776 through 41,790 (of 49,562 total)