Thanks for the reply , well i have implemented the logic and its working now , will be posting the same in Github but the way you used pipe...

Thanks for the reply , I need to do this everyday once off peak hours and we are not on SAN .

Thanks for the reply .

Well since the backup size is 200GB , I am not very comfortable using the UNC path but i will give it a try...

Thanks Gail . i lost the bet as my friend did told me that we cannot . Surely not a great situation if i land up there .

What are the...

Sorry not clear with the ask here . Please clarify if you want to just pull the delta each week or the whole sheet ? I am sorry we need...

This should work for you .

CREATE TABLE _A

(

A int ,

B int ,

c datetime

)

CREATE TABLE _B

(

A int ,

B int ,

c datetime

)

Insert into...

Thanks Jeff for the idea of putting the while loop in TRAN , I think I understand the logic behind that . I hope if anyone who uses the...

This should work for you .

CREATE TABLE _A

(

A int ,

B int ,

c datetime

)

CREATE TABLE _B

(

A int ,

B int ,

c datetime

)

Insert into...

I think using a while loop this should be achievable

DECLARE @rng-2 TABLE ( seq int identity(1,1),Id INT, RangeStart BIGINT, RangeEnd BIGINT, Category INT, NumberCount INT)

DECLARE @RNG_output TABLE...

Disabling the TCP/IP .....sounds good ...;-) ...Will test this and let you guys know . But I foumd that we can block it using IPSEC policy .