I need both.

If having backup with in last 24 hrs then retrieve backup_finish_Date.

If no backup with ln last 24 hrs then retrieve null in the place of backup_finish_date.

So the condition...

Thanks to all....

Yes,where clause in jeff's query changes the join.

Here, i wanted to get the data having backups and no backups with in last day.

I have tried below as below....Let me...

Thanks John...:-)

Definitely i will search it out and will give update once i get the solution....

Thanks to all once again....

Bagath.

Yes, You are right.

But here we do not have permission to execute the .exe files in local systems.

I have to check thru only QA or manual check.

Is MS provides any...

Thanks you very much sir,

So there is no way to get the date and time....

Just i wanted to not to check all the pc's whether dst has been installed or...

Thanks you very much sir,

So there is no way to get the date and time....

Just i wanted to not to check all the pc's whether dst has been installed or...

Thanks you very much sir,

So there is no way to get the date and time....

Just i wanted to not to check all the pc's whether dst has been installed or...

Thanks allot for the response....

Yes you right.The problem was with the cubes(cubes were not exist) only.

Thanks once again.

Bagath.

Hey,

Thanks allot for your great responce and suggestions.Will try to continue like that only.

Once again thanks to all of you.

Cheers,

Thanks You very much ...:-)

Cheers,

Bagath

But i dont have background in the front end side?

Could the pwd save in any other location while creating login?

Thanks,

🙂

Here,what my problem is i do not have priviliges to change the password and the pwd is different for the apps.

This account is using by many reporting projects  if i...

So there is no way to the get the password for 'sa' login Right?

Thanks,

Thanks For all for providing the valuable info....:-)

Would you provide any URL ?

I have tried and successfully created the trigger......

Thank you very much Ijaz....  🙂

Bagath