Jump to content

Ms Sql Server Technology Discussions


9Pardhu

Recommended Posts

steve ballmer ani antunna s%H# [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]

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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? s%H#
[/quote]

Link to comment
Share on other sites

[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 s%H#

thrd link plz...kaipinchale naaku s%H#

Link to comment
Share on other sites

[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...

Link to comment
Share on other sites

[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...

Link to comment
Share on other sites

[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? sSa_j@il

Link to comment
Share on other sites

[quote name='Kaarthikeya' timestamp='1364582079' post='1303509171']
what if @@errorcount is set to -1 which is less than 0? sSa_j@il
[/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]

Link to comment
Share on other sites

[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 sSc_hidingsofa

Link to comment
Share on other sites

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 s%H#

thrd link plz...kaipinchale naaku s%H#
[/quote]

Link to comment
Share on other sites

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]

Link to comment
Share on other sites

[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 s%H#

Link to comment
Share on other sites

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....

Link to comment
Share on other sites

[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... *<:( CITI#H@

Link to comment
Share on other sites

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

DBA knowledge nil naaku... CITI#H@
[/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 *<:(

Link to comment
Share on other sites

×
×
  • Create New...