Thanks it worked:-D, but my issue is that I have similar DB's & they backup okay on the default backup folder but only a few that was not going through....

Unfortunately the application has been hard coded to create certain accounts for it's own use but a sql connection account is used by SSIS that needs access to all those...

I created a maintenance plan with Full Database backup, Maintenance Cleanup Task & Update Stats.

Product version is Standard Edition 64bit R2

Thanks!!

I found the solution to my problem. Changed all the sql service accounts except Full Text to Local System and on the properties of the cube on the deployment ==>...

Thanks a lot for your help, the first script works perfect but the second script is failling with invalid object name #result

Thanks

I used tvantonder-992012 suggestions as posted, also checked the msdb.dbo.sysjobactivity table and i could see the job also joined the sysjob table to get the full desc of the job...

Tx 4 yr help i'm sorted

Pls see below script but was scheduled as a job to run every hour

DECLARE @CallPresentIndicator Bit -- bit data type is to indicate true or false. 0 is "False" and...

Tx, it's a sql script that execute a database mail command if the condition is not met, then sends me an email scheduled as a job but now the job...

to write

Okay, maybe it's me i need to create a trigger that will audit a table where transactions are inserted when a phone call is made, some times the buffer of...

Thx!!

The solution to my previous problem

I installed SQL 2000 DEV SP4, then upgraded to SQL 05 SP3 DEV

All working super:-D

Hi Arun

I have the below proc but the problem with proc when it does the insert on missing profiles step it's fails with duplicate key and i understand that, what...