D
Don Juan
Hi I need to create a SP with the following fake code:
(Sql Server 2005)
....
If DB1 is available and DB2 is available
Insert into DB3
Select field1, field2 from DB1
Insert into DB3
Select field1, field2 from DB2
Where status = 1
Else
Insert into DB3
Select 'One of databases is not available','0'
End
What I need is to know if a database is Restoring.. or Offline...
Thanks in advanced
(Sql Server 2005)
....
If DB1 is available and DB2 is available
Insert into DB3
Select field1, field2 from DB1
Insert into DB3
Select field1, field2 from DB2
Where status = 1
Else
Insert into DB3
Select 'One of databases is not available','0'
End
What I need is to know if a database is Restoring.. or Offline...
Thanks in advanced