For such kind of reasons we should avoid float and real datatypes ? And rather use decimal and numeric ?

Check it

declare @test-2 float

select @test-2 = 0.1234123412341234

select @test-2

select ltrim(rtrim(@test))

Results are as follows:

0.123412341234123

0.123412

What error you are getting ?

The following thing works for me for granting execute permissions on all the procedures to a role:

grant EXEC to <rolename>

The same way i was thinking and thats how my mind...

Thats what I was thinking. However then my mind started thinking ridicously for the following command:

grant insert, update, delete on all tables to <rolename>

Nothing sort of this, right ??? 🙂

Yeah. Sorry but I forgot to mention that due to certain restrictions we cannot use built in roles. Is there kind of parallel mechanism to implement db_datawriter ?

Lolz. Can my query be more optimized ?

At the same time, I also strongly agree with you about not using cursors.

Thanks Koen,

With the following configuration:

tabA

Id ParentId

1001 NULL

1002 1001

1003 1001

1004 NULL

1005 NULL

tabB

Id Value

1001 123

1002 25

1003 30

1004 85

1005 218

your query will give results as:

IDValue

1001369 [123+123+123 which is wrong]

100485

1005218

which means it is repeating...

I am testing it with implementing the logic using triggers. I hope it will work fine.

There were no blockings reported at that point of time by the monitoring people. They killed the process after it kept running for around 30-45 minutes (which usually takes 1-2...

Can someone please help on this ?

This implies two things:

1. Any open transaction before full DB backup READ but not committed or rollbacked will be included in the full backup. [It sounds strange to me as...

I mean Yes, it will require a reboot but is it something post which we should consider testing our application connecting to the databases ?

Also check the fragmentation of the tables. Probably those need to be defragmented.