Ms Sql Server Technology Discussions

[deals2buy]

[quote name='loveindia' timestamp='1364576004' post='1303508451']

No, voorkey appudappudu india lo interview calls teeskuntaa.. mana brain sharp avuddi ani.. [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img]
[/quote]
chi jeevitham..naaku neelaga budhi eppudu pudutundo ento? [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img]

btw nuvvu emaina MS certification raasava?

[loveindia]

[quote name='Kaarthikeya' timestamp='1364576056' post='1303508455']
chi jeevitham..naaku neelaga budhi eppudu pudutundo ento? [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img]

btw nuvvu emaina MS certification raasava?
[/quote]

2005 dev 2008 dev 2008 bi raasa... [img]http://lh6.ggpht.com/-wpVRCtWO9EU/UU0hvE08WcI/AAAAAAAAK3k/niOlWDWDGwo/s150/Brahmi-2.gif[/img]

[deals2buy]

[quote name='loveindia' timestamp='1364576265' post='1303508482']

2005 dev 2008 dev 2008 bi raasa... [img]http://lh6.ggpht.com/-wpVRCtWO9EU/UU0hvE08WcI/AAAAAAAAK3k/niOlWDWDGwo/s150/Brahmi-2.gif[/img]
[/quote]
ee dev endi kothaga? eppudu vinale?

Isn't dev and BI the same?

[ChampakDas]

no..just code flow ala untey em avutundi...does it bomb?
[quote name='Kaarthikeya' timestamp='1364573591' post='1303508244']
It asks u while u dispose the connection kadaa
[/quote]

[deals2buy]

[quote name='GatisKandis' timestamp='1364577416' post='1303508611']
no..just code flow ala untey em avutundi...does it bomb?
[/quote]
ela unte? can u plz be more specific?

[ChampakDas]

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 name='loveindia' timestamp='1364574275' post='1303508307']

on the first note, if you try to close a window that you used transactions in, it will show a message saying "THERE ARE UNCOMMITTED TRANSACTIONS". okvela close chestey rollback avtai changes..
[/quote]

[ChampakDas]

thats awful
[quote name='Kaarthikeya' timestamp='1364574854' post='1303508357']
... naaku inni rojulu idi teleedu...maa daggara packages fail aithe madhyalo..its committing to the steps till then processed..
[/quote]

[ChampakDas]

[quote name='Kaarthikeya' timestamp='1364577474' post='1303508618']
ela unte? can u plz be more specific?
[/quote]
[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]

[deals2buy]

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

I guess code lo kuda same anukunta....there should be an option in SSMS to set the value of the transactions same as SSIS

[ChampakDas]

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?

[deals2buy]

[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]
AFAIK it stays....

atleast na code lo aithe adi stay avutondi mari

[ChampakDas]

lets assume what you said is correct, now I close the application that means no more processes running from the web side. Now, aa transaction alage undipothada? undi pothey ms sql lo bug fix cheyali
[quote name='Kaarthikeya' timestamp='1364577913' post='1303508666']
AFAIK it stays....

atleast na code lo aithe adi stay avutondi mari
[/quote]

[deals2buy]

[quote name='GatisKandis' timestamp='1364578086' post='1303508679']
lets assume what you said is correct, now I close the application that means no more processes running from the web side. Now, aa transaction alage undipothada? undi pothey ms sql lo bug fix cheyali
[/quote]
not sure calling Bill Gates [img]http://www.manadb.com/Smileys/default/Brahmi.gif[/img]

[ChampakDas]

calling steve [img]http://www.manadb.com/Smileys/default/Brahmi.gif[/img]
[quote name='Kaarthikeya' timestamp='1364578271' post='1303508696']
not sure calling Bill Gates [img]http://www.manadb.com/Smileys/default/Brahmi.gif[/img]
[/quote]

[deals2buy]

[quote name='GatisKandis' timestamp='1364579309' post='1303508807']
calling steve [img]http://www.manadb.com/Smileys/default/Brahmi.gif[/img]
[/quote]
no more kadaa