Viewing 15 posts - 61 through 75 (of 213 total)
You didnt say if this is an existing job that just stopped working or a new job you are trying to setup
February 22, 2011 at 2:51 pm
should be in the history of the copy or restore job
Is it possible the database are not in fulll recovery mode
February 22, 2011 at 2:46 pm
not 100 percent sure it what you are asking
but yes you can do exec ts1.dbo.stored_procedure on a linked server
February 22, 2011 at 1:30 pm
http://msdn.microsoft.com/en-us/library/dd392015(v=sql.100).aspx
this has workload vs trace
February 22, 2011 at 12:45 pm
CREATE PROC [dbo].[dba_WhatSQLIsExecuting]
AS
/*--------------------------------------------------------------------
Purpose: Shows what individual SQL statements are currently executing.
----------------------------------------------------------------------
Parameters: None.
Revision History:
24/07/2008 Ian_Stirk@yahoo.com Initial version
Example Usage:
1. exec YourServerName.master.dbo.dba_WhatSQLIsExecuting ...
February 22, 2011 at 9:58 am
is this a clean install or are the application running on it
February 22, 2011 at 9:52 am
new the right answer but talked myself into the wrong answer thinking it was a trick question
February 22, 2011 at 9:46 am
declare @errcnt as int
set @errcnt = isnull((select count(1)
from msdb.dbo.sysjobs sj
left outer join msdb.dbo.sysjobsteps sjs on sj.job_id=sjs.job_id
where sj.enabled=1 and sjs.last_run_outcome=0),0)
if @errcnt =0
begin
exec master.dbo.xp_sendmail @recipients ='missqladmins@nationsholding.com'
,@message ='All...
February 22, 2011 at 9:43 am
i use this for all my jobs
select count(1)
from msdb.dbo.sysjobs sj
left outer join msdb.dbo.sysjobsteps sjs on sj.job_id=sjs.job_id
where sj.enabled=1 and sjs.last_run_outcome=0),0)
February 22, 2011 at 9:41 am
sp_blocking
and run the profiler checking reads, writes ,duration
run the standard reports for average io, average cpu
February 22, 2011 at 9:34 am
i create a release environment for my developers to get production data
There are too many times someone writes a query that shouldnt hit production, plus it is easy then to...
February 22, 2011 at 9:22 am
cost wasnt mentioned
as a developer i always fine more screen space for the apps and explorers and the tool boxes
February 18, 2011 at 9:18 am
I am working on the script for you
but the issue for the lock is that your transaction is still waiting until you rollback or commit manually
also in the second query...
February 17, 2011 at 9:34 am
Viewing 15 posts - 61 through 75 (of 213 total)