Ms Sql Server Technology Discussions

[ChampakDas]

steve ballmer ani antunna [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img]
[quote name='Kaarthikeya' timestamp='1364579533' post='1303508844']
no more kadaa
[/quote]

[deals2buy]

[quote name='GatisKandis' timestamp='1364579932' post='1303508896']
steve ballmer ani antunna [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img]
[/quote]
who is he?

[ChampakDas]

I am dead...I cannot tell maa tv owner nee marchipothava?[img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img]
P.S: neeko thread vesa
[quote name='Kaarthikeya' timestamp='1364580271' post='1303508954']
who is he?
[/quote]

[deals2buy]

[quote name='GatisKandis' timestamp='1364580382' post='1303508967']
I am dead...I cannot tell maa tv owner nee marchipothava?[img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img]
P.S: neeko thread vesa
[/quote]
nijamgane teleedu...even apple lo rendo vaadi peru kuda teleedu

thrd link plz...kaipinchale naaku

[loveindia]

[quote name='GatisKandis' timestamp='1364577482' post='1303508619']
this I am aware mama....if it is run throught code em avutundi..that means who dont have an instance but a processid is created...now what happens?
[/quote]

biscuit aitundi... process id danni aa transaction lock chestundi.. so dead lock create avuddi... just kill man.. dats it...

[loveindia]

[quote name='GatisKandis' timestamp='1364577695' post='1303508651']
suppose dead lock situation vachindi...were one work (A) flow has a transaction started but lets say it is diposed off abruptly now will the transaction gets rollback or does it still stay?
[/quote]

through application chestey lock avutundi... appudu aa proc or piece of code lo @@errorcount > 0 vastey ROLLBACK cheyyali or =0 COMMIT cheyyali ani condition pettukovali.. appudu work avutundi nee requirement...

[deals2buy]

[quote name='loveindia' timestamp='1364581979' post='1303509161']

through application chestey lock avutundi... appudu aa proc or piece of code lo @@errorcount > 0 vastey ROLLBACK cheyyali or =0 COMMIT cheyyali ani condition pettukovali.. appudu work avutundi nee requirement...
[/quote]
what if @@errorcount is set to -1 which is less than 0?

[loveindia]

[quote name='Kaarthikeya' timestamp='1364582079' post='1303509171']
what if @@errorcount is set to -1 which is less than 0?
[/quote]

appudu condition <>0 ani pettu instead of >0... nee doubt lo naa chakodii...[img]http://www.nandamurifans.com/forum/uploads/sml_gallery_8818_2_281352.gif[/img]

[deals2buy]

[quote name='loveindia' timestamp='1364582179' post='1303509182']

appudu condition <>0 ani pettu instead of >0... nee doubt lo naa chakodii...[img]http://www.nandamurifans.com/forum/uploads/sml_gallery_8818_2_281352.gif[/img]
[/quote]
ya correct ey bhayyo..nenu ide chesta...but marchipoyi adigesa

[ChampakDas]

MS CEO [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img]
[quote name='Kaarthikeya' timestamp='1364581709' post='1303509130']
nijamgane teleedu...even apple lo rendo vaadi peru kuda teleedu

thrd link plz...kaipinchale naaku
[/quote]

[ChampakDas]

ya killing chesthey it will get back to normal ani telsu...ekada ee dead lock process ni marchali in sql
[quote name='loveindia' timestamp='1364581806' post='1303509142']

biscuit aitundi... process id danni aa transaction lock chestundi.. so dead lock create avuddi... just kill man.. dats it...
[/quote]

[deals2buy]

[quote name='GatisKandis' timestamp='1364582623' post='1303509239']
MS CEO [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img]
[/quote]
got it now

[gandham]

HI,
Mirroring already setuped on my environment,if one principal database failover to mirroring side and how to force fail over to rest of the principle databases????

Plz Help....

[loveindia]

[quote name='piliki' timestamp='1364583858' post='1303509407']
HI,
Mirroring already setuped on my environment,if one principal database failover to mirroring side and how to force fail over to rest of the principle databases????

Plz Help....
[/quote]

DBA knowledge nil naaku...

[chelsea]

[quote name='loveindia' timestamp='1364584191' post='1303509443']

DBA knowledge nil naaku...
[/quote]

ba classes ni eppudu start chesthavu kocham PM PLS developement chesi 1 year avthunnadi naku vachinadi chala takkava malli idi okkati

Please t-sql skills improve chesukovataniki manchi online website vunte cheppu