Hi,

Thank you for your reply.

We don't have a QA environment separately. The Dev environment acts as the QA environment too.

Thanks,

Nsh.

hi,

thanks for the tips.

Natalie

Hi,

Will try out your suggestions.

Thanks for your reply.

Natalie.

Thank you all for the responses.

It works when a new query window connection is opened.

Thanks!

Hi,

Thanks for the link.

Natalie.

Hi,

It was restored - and it was showing null because the 'auto-close' option was selected.

Thanks.

Hi,

After including version is not null (as per ur suggestion) - its working fine.

Thanks a lot.

Hi,

thnx for the code......

i came across another syntax too :

declare

@login sysname

declare @dbname sysname...

Hi,

Thanks - went through your blog link. I will try one following your example.

Thanks again.

Natalie

Hi,

Sorry i am still having trouble in getting my xcacls to work.

Should the xcacls.vbs be download into a specific path....?

I downloaded the xcalcs.vbs into this path: C:\Documents and Settings\UN\My...

Hi,

I want to view the existing permission of a folder and then set the folder permission through command line or batch file.

when i use calcs "D:\Test"  in the dos...

Hi,

I have a test.sql - which contains about 4 stored procedure (create proc t1, t2,t3,t4) within it.

I want to call and execute this through a batch file.

so...

Hi,

I have the following code:

declare @new_plan_id uniqueidentifier

declare @new_command nvarchar(1000)

exec msdb.dbo.sp_add_maintenance_plan 'System DB Maint',@plan_id=@new_plan_id output

exec msdb.dbo.sp_add_maintenance_plan_db @new_plan_id, 'All System Databases'

/* entry for max_history_rows field. */

IF EXISTS (SELECT *

                FROM msdb.dbo.sysdbmaintplans

                WHERE...

I am able to receive the email notifications.

It was just that i didnt have @From in my code....... guess all statements are required for the email notifications to get...