SQL server exams - parameters to transaction

Author

parameters to transaction

naresh_sky

2002-10-05, 12:03 am

hi guys ..

can anyone of u guys help me out.

1) the problem is i want to send parameters to transaction Both (input or output) if so (reasons)

2)what r torn pages.

3)And the last how to go for Adminstration
exam (228) is there lot of T-SQL statements

that is ..(strong codeing is required or justwizards type of knowlede is enough.. because admin is basically of wizard work i believe)

thanks
naresh

2lazybutsmart

2002-10-05, 10:09 am

lemme see. ur questions aren't clear naresh, but i'll try.

as for the torn pages. A torn page can occur if the system fails due to power failure. there are settings used to detect torn pages, that i don't know.

secondly, a transactions should not have user interaction if u want robust concurrency and efficient security.

but, at times, you might need to disobey the law

. if so, cut the commit or rollback statements from the batch.

for example,

Batch1
------------------------
BEGIN TRAN
--do something
-------------------------

Batch2
--------------------------
do something
prompt for changes
drink a cup of coffee
COMMIT TRAN or ROLLBACK TRAN
---------------------------

so in the intervals, is were u disobey the law. between batch1 and batch2, u have a transaction started, but still not commited or rolled back.

If you want furthur info, u might want to ask neocorphantasam, he help me out couple of times with transaction associated questions.

and finaly, Exam 228, i'll leave that for neocorphantasam also.

cheers,
2lazybutsmart

Sponsored Links