Ms Sql Server Technology Discussions

[9Pardhu]

meeku real ga SQL Server meeda enni years exp vundi?

nadi 2+ as DBA counting.

[JUJUBI_JULABI]

MI lo edina positions open untey chepandi guys !

[chelsea]

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

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

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

recovery mode and non recovery mode ki chala diff vunaya?

[deals2buy]

[quote name='9pardhu' timestamp='1349881323' post='1302604801']
meeku real ga SQL Server meeda enni years exp vundi?

nadi 2+ counting.
[/quote]


1yr

[deals2buy]

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]

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]

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

[chelsea]

GM guys

[deals2buy]

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]

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

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

[9Pardhu]

super