Thanks Mohit,

But can u please give me a direct link for that cms webcast?

I m not able to find anything there

and one more thing so do...

Thanks jeff

hmm almost there..but since i m not supposed to pass value or

declare variable in name facet of my policy..i cant use this code

which is fine..

EXEC (' declare @name sysname

...

well i agree but irrespective of all tht we r going to create new system , we are building it from scratch..

Now so far i m using NAme facet...

Where @Name...

well ya thts fine.. thanks

well i think this is not wht i want.. or m not getting u..

just copy n paste my code on ur ssms query window and execute it.. u willl understand...

--ok i have modified it but still its not giving coreect results

i wan 3, 4 and 5 th position as only alphabets no number or anything else..

but its not checking...

code print error in above code...

set @sql= ('select substring('''+@Name+''',3,1)')

--Exec(@sql)

--print @sql

set @cmd = ('select substring('''+@Name+''',4,1)')

--exec (@cmd)

set @line = ('select substring('''+@Name+''',5,1)')

--exec (@line)

So m selecting 3 , 4...

yeah that makes sense thanks

nope--not working u can try

exec('

DECLARE @object sysname,@sql varchar(100)

SET @object = ''P_adv_person''

set @sql = ''select substring(@object,3,1)''

Exec(@sql)')

...

thanks for ur reply i always gets stuck in dynamic quotes

Well thanks for ur extra comments and advice...

But if some one can share more knowledge abt how to build this kind of policy.. i appreciate

Thanks

I did that and i can see that SQL Server is started and sql agent is also started..

i found this from new error log file..

Why SQL Server...

select name,log_reuse_wait_desc from sys.databases

is it possible to change log_reuse_wait_desc column value from nothing to LOG_Backup?

because ad hoc updates to system tables are not allowed in sql 2005

changing this option might...

hmm may be typing mistake.. i m getting this

name rows reserved data index_size unused

transactions2354421 ...

right now i m getting this result after executing the command

Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62

The object 'transactions' does not exist in database 'cdr' or is...