User defined tempdb

[unknown]

Hi Everyone,

How Can we identify from system tables whether the database
is "user defined tempdb database' or "user defined
database"? For eg :

If I issue following two commands, Which system table entry
will be different.
1> create database tempdb3 on data1=10 log on log=3
2>go

1> create temporary database tempdb3 on data1=10 log on log3
2> go

[Mark A. Parsons]

User-created temporary database:

master..sysdatabases.status3 & 256 = 256

Post by unknown
Hi Everyone,
How Can we identify from system tables whether the database
is "user defined tempdb database' or "user defined
If I issue following two commands, Which system table entry
will be different.
1> create database tempdb3 on data1=10 log on log=3
2>go
1> create temporary database tempdb3 on data1=10 log on log3
2> go