[shubhada99]

How to handle mutiple tempdb?
Have any drawbacks or any conflict problem while handling the tempdb?

Plz give me some idea or any good links.

[willy_and_the_ci]

Make sure that you are the latest patch level of Sybase to use MTB feature.

You can isolate logins based on applications, or access privileges, or even resource consumption. Always reserve a tempdb for a sso/sa priveled account.

This also slightly increases your recovery period whenever you recycle your dataserver. So, keep the MTB's to the lowest size that you can afford.

The login bindings are stored in master..sysattributes, take a nightly backup of sysattributes, so this can be restored in the event of an failure.