Run this stored proc and you will get the desired results.. Its a script I pulled off the net..

====

CREATE PROCEDURE sp_diskspace

AS

SET NOCOUNT ON

DECLARE @hr int

DECLARE @fso int

DECLARE @drive...

well,  your answer was pretty close but not quite complete.. Messages such as "log backed up" are system messages and thus cannot be deleted from the "manage sql server messages"...

Has any of the table definition(s) changed?

what are the four indexes?

Your question is very vague. Once you have connectivity to sql server (and data), depending on your app (ASP, JAVA, etc, etc..), feel free to invoke queries and...

Hi Steve, Appreciate your input. I am of the same opinion that over years of working with sql server, this was the first time I heard this...

Usually when the SP finishes or the user connction terminates, the temp tables are all released. what you will have a pretty fragmented data file.. Unless, you have...

Why isn't the SP cleaning behind itself.. That's the normal practice..

My Bad , guys - please ignore this post.. I was running Profiler and that seemed to be inducing the big jump in the latch time counter... ...

Gracias, guys... Is there any way of specifying location of new column via sql analyzer (I meant T-sql)..? Via EM, you can just go insert it anywhere you...

Hi - Something related to this query..

what's sql internals for adding a column? Does sql server have to recreate the whole table? i.e., does the old table get...

Also, since DBCC CHECKDB runs as a job, you should be able to check msdb..sysjobhistory for sql_severity and run_status flag(s)...

Will that work Allen?

Wize