Tuesday 19 March 2019

SQL 2000 : Online & Offline databases

I can't believe I still need these in 2019... 

-- SQL 2000 : Offline databases
select * from master..sysdatabases
where status & 512 = 512
and dbid > 4

-- SQL 2000 : Online databases
select * from master..sysdatabases
where status & 512 <> 512
and dbid > 4
By -

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)