9Pardhu Posted October 10, 2012 Author Report Posted October 10, 2012 meeku real ga SQL Server meeda enni years exp vundi? nadi 2+ as DBA counting.
JUJUBI_JULABI Posted October 10, 2012 Report Posted October 10, 2012 MI lo edina positions open untey chepandi guys !
chelsea Posted October 10, 2012 Report Posted October 10, 2012 [quote name='9pardhu' timestamp='1349881323' post='1302604801'] meeku real ga SQL Server meeda enni years exp vundi? nadi 2+ counting. [/quote] nearly 2 years kani office work chesinadi aithe ok 8 months anthe AS BI Developer
Darling999 Posted October 10, 2012 Report Posted October 10, 2012 [quote name='Vaampire' timestamp='1349840740' post='1302603819'] backup chesi restore cheyyalema??? or else ssis package tho copy seyyochu kada [/quote] idi simple, backup and restore ey kaani nenu adigina question enti, between two different servers so network mapping lo backup file teeskochaa new server ki pani khatam ayindi
Darling999 Posted October 10, 2012 Report Posted October 10, 2012 [quote name='chelsea' timestamp='1349877847' post='1302604530'] bhayya ayyina Back up and Restore chestha only databases chesthamu kani ssrs reports and SSIS package and cubes ela vasthavi [/quote] reports and packages neeku already BIDS lo untey direct ga kotha server ki point chesi deply cheyyatamey, lekapotey existing server nuchi teeeskochi akkad nunchi cheyyachu easy ney adi oka saari choostey vachestadi
9Pardhu Posted October 10, 2012 Author Report Posted October 10, 2012 recovery mode and non recovery mode ki chala diff vunaya?
deals2buy Posted October 11, 2012 Report Posted October 11, 2012 [quote name='9pardhu' timestamp='1349881323' post='1302604801'] meeku real ga SQL Server meeda enni years exp vundi? nadi 2+ counting. [/quote] 1yr
deals2buy Posted October 11, 2012 Report Posted October 11, 2012 Monna evaro Reporting gurinchi edo question adigaaru ga.. edo basic article okati kanipinchindi..use avutundemo evarikaina ani vestunna [url="http://www.sqlservercentral.com/articles/SSRS/93760/"]http://www.sqlservercentral.com/articles/SSRS/93760/[/url]
bokuboy Posted October 11, 2012 Report Posted October 11, 2012 SQL BI Developer FT Position undhi....evariki ayina cheppandi http://www.andhrafriends.com/topic/345987-calling-mtkr-and-sql-bi-developers-full-time-position/
JUJUBI_JULABI Posted October 11, 2012 Report Posted October 11, 2012 [quote name='ChoclateBoy' timestamp='1349964180' post='1302609905'] SQL BI Developer FT Position undhi....evariki ayina cheppandi [url="http://www.andhrafriends.com/topic/345987-calling-mtkr-and-sql-bi-developers-full-time-position/"]http://www.andhrafri...-time-position/[/url] [/quote] acha !
deals2buy Posted October 11, 2012 Report Posted October 11, 2012 Babulu...nenu 2000 Client vadutunna..indulo error handling koddiga siraak aina pani ani naaku telusu.. naaku oka doubt vachindi.. naa daggara queries ila unnayi BEGIN TRUNCATE Table dbo.A1 TRUNCATE Table dbo.A2 TRUNCATE Table dbo.A3 TRUNCATE Table dbo.A4 TRUNCATE Table dbo.A5 SELECT @err = @@error IF(@err<>0) PRINT 'Error Occurred' so ee paina statments lo suppose 3rd table truncate chesinappudu error vasthe adi error handler cheyyaledu kada..ilaanti situations lo error handle ela use cheyyalo cheptara koddiga fleeze..very urgent
chelsea Posted October 11, 2012 Report Posted October 11, 2012 [color=#282828][font=helvetica, arial, sans-serif]BEGIN Try[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]TRUNCATE Table dbo.A1[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]TRUNCATE Table dbo.A2[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]TRUNCATE Table dbo.A3[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]TRUNCATE Table dbo.A4[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]TRUNCATE Table dbo.A5[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]Begin end[/font][/color] BEGIN CATCH DECLARE @ErrorMessage NVARCHAR(4000) = 'Error Line = ' + ' ' + CAST(ERROR_LINE() AS VARCHAR(10)) + ' ' + ERROR_MESSAGE() END CATCH END Try cheyyi ba okka sari
chelsea Posted October 11, 2012 Report Posted October 11, 2012 [quote name='deals2buy' timestamp='1349981467' post='1302611901'] Babulu...nenu 2000 Client vadutunna..indulo error handling koddiga siraak aina pani ani naaku telusu.. naaku oka doubt vachindi.. naa daggara queries ila unnayi BEGIN TRUNCATE Table dbo.A1 TRUNCATE Table dbo.A2 TRUNCATE Table dbo.A3 TRUNCATE Table dbo.A4 TRUNCATE Table dbo.A5 SELECT @err = @@error IF(@err<>0) PRINT 'Error Occurred' so ee paina statments lo suppose 3rd table truncate chesinappudu error vasthe adi error handler cheyyaledu kada..ilaanti situations lo error handle ela use cheyyalo cheptara koddiga fleeze..very urgent [/quote] nuvu sql server 2000 antunnavu kada [url="http://www.aspfree.com/c/a/ms-sql-server/exception-handling-in-sql-server-2000-and-2005/"]http://www.aspfree.com/c/a/ms-sql-server/exception-handling-in-sql-server-2000-and-2005/[/url]
Recommended Posts