ChampakDas Posted March 26, 2013 Report Share Posted March 26, 2013 @OLEResult null undha? [quote name='Kaarthikeya' timestamp='1364330313' post='1303491585'] [CODE] EXECUTE @OLEResult = sp_OACreate 'Scripting.FileSystemObject', @FS OUT EXEC @OLEResult = sp_OAMethod @FS, 'OpenTextFile', @FileID OUT, @FileName, 1, 1 EXECUTE @OLEResult = sp_OAMethod @FileID, 'ReadLine', @Message OUT WHILE @OLEResult >= 0 BEGIN PRINT @Message EXECUTE @OLEResult = sp_OAMethod @FileID, 'ReadLine', @Message OUT END [/CODE] [/quote] Link to comment Share on other sites More sharing options...
deals2buy Posted March 27, 2013 Report Share Posted March 27, 2013 [quote name='GatisKandis' timestamp='1364332228' post='1303491928'] @OLEResult null undha? [/quote] ardham kaaledu Link to comment Share on other sites More sharing options...
ChampakDas Posted March 27, 2013 Report Share Posted March 27, 2013 [quote name='Kaarthikeya' timestamp='1364330313' post='1303491585'] EXECUTE @OLEResult = sp_OACreate 'Scripting.FileSystemObject', @FS OUT EXEC @OLEResult = sp_OAMethod @FS, 'OpenTextFile', @FileID OUT, @FileName, 1, 1 EXECUTE @OLEResult = sp_OAMethod @FileID, 'ReadLine', @Message OUT WHILE [color=#ff0000][size=6][b]@OLEResult[/b][/size][/color] >= 0 BEGIN PRINT @Message EXECUTE @OLEResult = sp_OAMethod @FileID, 'ReadLine', @Message OUT END [/quote] [quote name='Kaarthikeya' timestamp='1364397956' post='1303495318'] ardham kaaledu [/quote] Link to comment Share on other sites More sharing options...
Bongu..Boshanam Posted March 28, 2013 Report Share Posted March 28, 2013 [quote name='pardhu9' timestamp='1349360810' post='1302580827'] nenu currently working as SQL Server DBA [/quote] [quote name='dubbak' timestamp='1349366001' post='1302581304'] [color=#282828][font=helvetica, arial, sans-serif]nenu kada working as SQL Server DBA[/font][/color] [/quote] [quote name='Robinhood1676' timestamp='1349371508' post='1302581727'] even i'm working a SQL DBA [/quote] SQL Server - Clustering baga exp undha vayya...? Link to comment Share on other sites More sharing options...
deals2buy Posted March 28, 2013 Report Share Posted March 28, 2013 [quote name='GatisKandis' timestamp='1364419957' post='1303497941'] [/quote] no... zero or some value undi chi...visual script lo 4 lines code tho motham aipotondi...ee sql lo entha chesina avvatle Link to comment Share on other sites More sharing options...
ChampakDas Posted March 29, 2013 Report Share Posted March 29, 2013 if there are uncommitted transactions and if you dispose the connection...will it kill that transaction? Link to comment Share on other sites More sharing options...
deals2buy Posted March 29, 2013 Report Share Posted March 29, 2013 [quote name='GatisKandis' timestamp='1364569227' post='1303507828'] if there are uncommitted transactions and if you dispose the connection...will it kill that transaction? [/quote] It asks u while u dispose the connection kadaa Link to comment Share on other sites More sharing options...
loveindia Posted March 29, 2013 Report Share Posted March 29, 2013 [quote name='GatisKandis' timestamp='1364569227' post='1303507828'] if there are uncommitted transactions and if you dispose the connection...will it kill that transaction? [/quote] 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.. Link to comment Share on other sites More sharing options...
deals2buy Posted March 29, 2013 Report Share Posted March 29, 2013 [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] ippudu naa daggara oka flow of DTS packages unnayi....say like oka series of 10 unnayi and 7th step lo fail aindi...will all the transactions till then will be committed or will roll back completely to the beginning? Link to comment Share on other sites More sharing options...
loveindia Posted March 29, 2013 Report Share Posted March 29, 2013 [quote name='Kaarthikeya' timestamp='1364574370' post='1303508318'] ippudu naa daggara oka flow of DTS packages unnayi....say like oka series of 10 unnayi and 7th step lo fail aindi...will all the transactions till then will be committed or will roll back completely to the beginning? [/quote] SSIS lo oka option untadi rollback cheydaaniki... aa option true ki set chestey rollback avtai emanna issues vastey total package execution lo.. adhi set cheyakapotey ekkada varaku success aitey akkada varaku auto commit avutundi.. Link to comment Share on other sites More sharing options...
deals2buy Posted March 29, 2013 Report Share Posted March 29, 2013 [quote name='loveindia' timestamp='1364574619' post='1303508339'] SSIS lo oka option untadi rollback cheydaaniki... aa option true ki set chestey rollback avtai emanna issues vastey total package execution lo.. adhi set cheyakapotey ekkada varaku success aitey akkada varaku auto commit avutundi.. [/quote] ... naaku inni rojulu idi teleedu...maa daggara packages fail aithe madhyalo..its committing to the steps till then processed.. Link to comment Share on other sites More sharing options...
loveindia Posted March 29, 2013 Report Share Posted March 29, 2013 [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] anoogna alochanallo untey em telustadi le vay... inka pandaga chesko... [img]http://lh6.ggpht.com/-wpVRCtWO9EU/UU0hvE08WcI/AAAAAAAAK3k/niOlWDWDGwo/s150/Brahmi-2.gif[/img] Link to comment Share on other sites More sharing options...
loveindia Posted March 29, 2013 Report Share Posted March 29, 2013 [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] india lo SQL BI LEAD position ki interview teeskunna ninna... 17L ki... aadu ededo sodhi questions adugutunnadu.. nenu examples tho cheptey, exact definitions cheppu annadu.. nenu cheppa nenu student ni kaadu definitions gurtupettukodaniki... please re review your interview standards ani reverse lo titta .. sodhi gaadu.. 4+ ni 6 ani cheppaley Link to comment Share on other sites More sharing options...
deals2buy Posted March 29, 2013 Report Share Posted March 29, 2013 [quote name='loveindia' timestamp='1364575129' post='1303508374'] anoogna alochanallo untey em telustadi le vay... inka pandaga chesko... [img]http://lh6.ggpht.com/-wpVRCtWO9EU/UU0hvE08WcI/AAAAAAAAK3k/niOlWDWDGwo/s150/Brahmi-2.gif[/img] [/quote] Its Anujna man [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img] [quote name='loveindia' timestamp='1364575317' post='1303508385'] india lo SQL BI LEAD position ki interview teeskunna ninna... 17L ki... aadu ededo sodhi questions adugutunnadu.. nenu examples tho cheptey, exact definitions cheppu annadu.. nenu cheppa nenu student ni kaadu definitions gurtupettukodaniki... please re review your interview standards ani reverse lo titta .. sodhi gaadu.. 4+ ni 6 ani cheppaley [/quote]India lo andaru inthe [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img] even ikkada jarige Teeches, kagnijant laanti companies lo kuda definitions adgutaru [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img] btw enti India vellipotunnava? Link to comment Share on other sites More sharing options...
loveindia Posted March 29, 2013 Report Share Posted March 29, 2013 [quote name='Kaarthikeya' timestamp='1364575609' post='1303508408'] Its Anujna man [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img] India lo andaru inthe [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img] even ikkada jarige Teeches, kagnijant laanti companies lo kuda definitions adgutaru [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img] btw enti India vellipotunnava? [/quote] 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] Link to comment Share on other sites More sharing options...
31
-1.thumb.png.613bdd33b4e8b5f69ac815bf90e62a8b.png)
Recommended Posts