ChampakDas Posted March 26, 2013 Report 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]
deals2buy Posted March 27, 2013 Report Posted March 27, 2013 [quote name='GatisKandis' timestamp='1364332228' post='1303491928'] @OLEResult null undha? [/quote] ardham kaaledu
ChampakDas Posted March 27, 2013 Report 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]
Bongu..Boshanam Posted March 28, 2013 Report 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...?
deals2buy Posted March 28, 2013 Report 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
ChampakDas Posted March 29, 2013 Report Posted March 29, 2013 if there are uncommitted transactions and if you dispose the connection...will it kill that transaction?
deals2buy Posted March 29, 2013 Report 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
loveindia Posted March 29, 2013 Report 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..
deals2buy Posted March 29, 2013 Report 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?
loveindia Posted March 29, 2013 Report 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..
deals2buy Posted March 29, 2013 Report 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..
loveindia Posted March 29, 2013 Report 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]
loveindia Posted March 29, 2013 Report 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
deals2buy Posted March 29, 2013 Report 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?
loveindia Posted March 29, 2013 Report 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]
Recommended Posts