More thanks Dude.It working.:-)

Hi SSRS dude,

=IIF(Fields!High_Level_New_Business_Channel.Value<>"Intermediary" and Fields!Account_Manager.Value<>"","Red","White")

above expression not working.Please help me

i have unable to set this expression in derived column.Pls help me..

select convert(varchar(4),month(getdate()),105) + convert(varchar(4),year(getdate()))

I need data like 201204 and storing into int datatype.Substring will give \ also???????????

Any help??????????????

Thanks Lowell.I got cleared my doubts.

Do you confirm SQL server 2008 R2 standard edition suits for my requirement with 8 processor?

You can add one more step in that job and add the following script in the command textbox.Before doing this,you should configure database mail profile('DB_GROUPMAIL') in SQL.

EXEC sp_send_dbmail @Profile_name='DB_GROUPMAIL',

@recipients='kumar.velayuthum@gmail.com',

@Copy_recipients='Phaneesh.Balachandra@xys.com',

@Subject='Backup Job...

Hi Ravi,

What error or Info you are getting in the Restore job history?

Regards

Kumar

Hi ,

Are you using any third party tools to take backup?

if so,just unselect the databases from the maiantenance plan and save it.

Again select the databases what you unselected earlier and...

Hi,

http://sqldbatask.blogspot.com/2011/12/how-to-grant-update-permission-to.html

Hope,You will get some idea to proceed

Thanks

Kumar

Hi,

Scenario 1.Daily full backup @10PM on sunday and every hour transaction log backup.(if more space to hold backups)

Scenario 2: Weekly full backup @10PM on sunday and remaining every days take...

Hi ,

Look http://technet.microsoft.com/en-us/library/ms190630.aspx.

Regards

http:\\sqldbataskwithkumar.blogspot.com

Hi,

You can check kerberos is being used or not by running below query

USE MASTER

GO

SELECT AUTH_SCHEME FROM SYS.DM_EXEC_SESSIONS

If output will be kerberos ,log on process is by kerberos authentication.

or by

...

Hi,

You need to auditing the table by writing triggers.

From the above process,you can find who deleted the table data in the audit table.

Thanks

Kumar

SQLdbataskwithkumar