The maximum key length is 900 bytes and if you create the nonclustered index that is having > 900 bytes. Index will create (expect non-key columns i.e., Columns that...

Check the below code

Declare @year varchar(10)='2011' -- Input

Declare @Dpart Tinyint

set @year = @year+'-01-01'

set @Dpart= Datepart(DW,@year)

Select Case When @Dpart = 2 Then @year When @Dpart < 2 Then DateAdd(dd,2-@Dpart,@year) ...

Hi Sumanta,

Thanks for the reply , i will try this to implement.

Regards-Deepak

Hi Brandie,

i want to get an email alert including error message that are logged either in the sysjobhisory or error log as soon as error occured. As An automated prcocess.

Regards...

Hi Brandie,

Thanks for your reply,

We receive notifications once a job fails, however, at this time, we need to check the job history/log to figure out why the job fails, and...

hi chris,

i will aggree , if we encounter any error in T-SQL , we will get error message , what if the job invocation itself failed ? and also...

hi Chris,

Thanks For your reply.

Will this provide error information , i mean...

i think SSRS subscription will be better option either standard subscription or data driven subscription based on your requirement.

you want the random values from the table ? if so use newid() in order by

ex : select * from tablename order by newid()

Regards- Deepak

what is the minimum permission required for CMS ?

it all depends...

yes we...

in the Query window i need to run sql script not by connecting another server in SSMS. I mean...

is there any way we can execute in SSMS

Regards - Deepak

Even for the below statement also

SELECT 'Test' WHERE EXISTS (SELECT SQRT(-1))

Good Question thanks 🙂