Hello,

I noticed that when we installed SQL 2000 Reporting services that two
databases are created one being ReportServerTempDB.   This got me to thinking
about Oracle databases where I can create multiple temporary 'tablespaces'
and then I can assign specific users to specific tablespaces. 

In a SQL environment,  can I create separate tempdbs that will be used by
separate users and/or applications?   How do Reporting Services use the
ReportServerTempDB?

I'm trying to create a shared hosting environment in my organization and
don't want competing applications filling up the tempdb.  I'd much prefer
that each application uses it's own temp space.

Thanks!

Art

Show quote Hide quote It uses it for caching and snapshots.  Lots of reads and writes with a low
requirement for backup.

But it's an ordinary user database.

All databases on a server share memory, CPU and TempDB.  You can install
multiple instances to segregate these resources.

David

Is this index redundant?
Very Large Table Defrag?
SQL2K Logs
SQL 2000 SP4 System Log Files?
SQL Backup Plan
What is this error?
Worktables created/sec
SQL Server Express
Missing xp_sqlagent_notify
Not associated with a trusted SQL Server connection