Viewing 15 posts - 61 through 75 (of 79 total)
More thanks Dude.It working.:-)
Regards,
Kumar
September 12, 2012 at 11:10 am
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
Regards,
Kumar
September 12, 2012 at 9:33 am
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()))
Regards,
Kumar
September 6, 2012 at 3:17 am
I need data like 201204 and storing into int datatype.Substring will give \ also???????????
Regards,
Kumar
September 6, 2012 at 3:14 am
Any help??????????????
Regards,
Kumar
September 6, 2012 at 2:39 am
Thanks Lowell.I got cleared my doubts.
Regards,
Kumar
September 5, 2012 at 7:04 am
Do you confirm SQL server 2008 R2 standard edition suits for my requirement with 8 processor?
Regards,
Kumar
September 5, 2012 at 5:31 am
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...
Regards,
Kumar
September 5, 2012 at 3:58 am
Hi Ravi,
What error or Info you are getting in the Restore job history?
Regards
Kumar
Regards,
Kumar
March 21, 2012 at 6:59 am
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...
Regards,
Kumar
March 21, 2012 at 5:00 am
Hi,
http://sqldbatask.blogspot.com/2011/12/how-to-grant-update-permission-to.html
Hope,You will get some idea to proceed
Thanks
Kumar
Regards,
Kumar
March 20, 2012 at 9:55 am
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...
Regards,
Kumar
March 20, 2012 at 9:49 am
Hi ,
Look http://technet.microsoft.com/en-us/library/ms190630.aspx.
Regards
http:\\sqldbataskwithkumar.blogspot.com
Regards,
Kumar
October 3, 2011 at 7:34 am
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
...
Regards,
Kumar
October 3, 2011 at 7:20 am
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
Regards,
Kumar
October 3, 2011 at 7:05 am
Viewing 15 posts - 61 through 75 (of 79 total)