Ms Sql Server Technology Discussions

[ChampakDas]

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

[quote name='GatisKandis' timestamp='1364332228' post='1303491928']
@OLEResult null undha?
[/quote]
ardham kaaledu

[ChampakDas]

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

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

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

if there are uncommitted transactions and if you dispose the connection...will it kill that transaction?

[deals2buy]

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

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

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

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

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

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

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

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

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