14>
15> CREATE PROC pr_verifydb (@dbname varchar(30))
16> AS
17> DECLARE @dbid int
18> SELECT @dbid = dbid from sysdatabases
19> where name = @dbname
20> IF @@rowcount = 0
21> RETURN 50
22> RETURN 0 -- Everything is perfect!!!
23> GO
1>
2>