-
Identifying System/User Databases
Hi,
i´m looking for TSQL-Code (7.0/2000) to identify, if a SQL Server Database ist a SystemDatabase or a UserDatabase. In the sysdatabases there is no information abount that.
Skol,
Peter
-
User database's dbid is > 6.
-
But the pubs db ist dbid5 an the northwind db is db17?
Are this example databases system or user databases?
-
They are sql installation created user db. System db id should be 1 to 4.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|