we decided against scom as it didn't monitor everything we wanted from SQL

is there a reason it needs to be in scom? Could you nit create a custom stored...

depends on the throughput of the server and how fast it can write to the disks. As to how long it takes. You could look at 3rd party tools...

can you do everything you can do in SSMS in the TeraData app?

stuff like creat logins/alerts/jobs/linked servers/policy based management as well as everything else that you can do in SSMS?...

has SQL agent been restarted after it was configured to use the mail profile in the SQL agent alert settings?

looks like the account has been removed from logon as a service,

run secpol.msc on the server and add in the accounts for the engine and agent to the logon...

can the sql server successfully ping the other two DC's? do the logins which your using as service accounts exist on the other two DC's

can you post the details...

in that case its best to pass in date times as date times not varchars, so you can either cast or convert them to an ISO date format in the...

could you not use a data conversion task in the middle of the source and destination to convert in SSIS rather than in the actual query at the source

are you using parameters to pass in dates?

the @ means its a parameter/variable which is used to run the query block

eg

delcare @name = 'Anthony'

select * from users where name = @name

go into the data source and what DB does it want to access? if it matches the name of the DB in SQL then there is something else at...

looking at a default trace from my test bed it doesnt capture password changes.

it captures the audit login change property event and the details are "records modifications on login property...

itskanchanhere, we are all volunteers here and post in our spare time so please do be patient if you dont get a responce straight away.

i would say use the right...

something somewhere changed the password

take a look in the default trace file as it might still be in there if your lucky

but if not, without some sort of auditing on...

without more information on the "else" part of things I cant help, unsure what you want to else or what logic you want in the query and what outputs with...