change the Remote Query timeouts.

Right click on instance name in SSMS, choose Properties, click on Connections.....

it should be set to 600 seconds (default).

sound likes IBM Tivoli/Maestro needs SQL Server 2008 drivers installed.

it depends on what the table contains. (filestream data, identity column, timestamps, etc...)

but i like to do the following (your mileage will vary);

1. create the database where the data will...

and i should mention that to get that code to work Ole Automation Procedures has to be enabled. (not on by default)

sp_configure 'show advanced options' ,'1'

go

reconfigure

go

sp_configure 'Ole Automation Procedures', '1'

go

reconfigure

go

and the whole thing to send an email from the server that has low disk space.....

DECLARE @hr int

DECLARE @fso int

DECLARE @drive char(1)

DECLARE @odrive int

DECLARE @TotalSize varchar(20)

DECLARE @MB bigint...

in order to get drive sizes vs free space and run a comparison in SQL, you have to use sp_OAMethod

so the xp_Fixeddrives is only half the solution. you have to...

you could do this;

BACKUP DATABASE @name TO DISK = @fileName

if (@@ERROR<>0)

begin

create table tempdb..errorlog (LogDate datetime, ProcessInfo varchar(100), [Text] varchar(max))

insert into tempdb..errorlog

exec sys.xp_readerrorlog 0

declare @mailcmd varchar(1000)

set @mailcmd = (select top...

Don't you have the choice of 'Hour' as a schedule?

you can set the start time and interval.

nvm, i see you want an end time.....

add something like this to your WHERE statement.

and DATEPART(YEAR, e.eecDateOfLastHire) = @yearpicked

you could populate the @yearpicked variable in SSRS by defining that varialbe with another select statement.

select distinct DATEPART(YEAR, e.eecDateOfLastHire)...

You do not have a default mail profile set up.

select * from [msdb].[dbo].[sysmail_profile]

select * from [msdb].[dbo].[sysmail_principalprofile]

Run to see your profile names and if any are set to default.

A "is_default" value...

try this script instead;

query = "Select * from __InstanceCreationEvent" _

& " " & "where TargetInstance isa 'Win32_NTLogEvent'" _

& " " & "and (TargetInstance.Logfile = 'Application' or TargetInstance.Logfile =...

Hi Phil,

Only MSSQL logs will be forwarded to the central server. That is a SQL Server Agent function.

SQL Server Agent will not forward non SQL Application log entries.

The modification to...

msilver (5/25/2012)

---

I'm using SQL Server 2008 R2. I created the database successfully but when I run the next script, I get an error (Msg 156, Level 15, State 1,...

bev.bellisio (5/25/2012)

---

I was successful setting this up on the server I wanted to use as Central server. However, when I tried to change one of my other servers' Agent properties...

12 seconds for failover....

wmi alerts are run in 30 second intervals by default.

from MS;

SQL Server Agent evaluates WMI-based alerts in fixed-size batches at fixed intervals. By default, alerts are evaluated...