Changes between Version 9 and Version 10 of Documentatie/Beheerder/Installeren/Installatiehandleiding/SQLServer

Timestamp:

Dec 20, 2012 9:40:56 AM (13 years ago)

Author:

henk

Comment:

--

Documentatie/Beheerder/Installeren/Installatiehandleiding/SQLServer

@@ -72 +72 @@
 }}}
 
+Met de volgende query kan worden gecontroleerd of bovenstaande queries zijn gelukt:
+{{{
+SELECT [name]
+      ,[database_id]
+      ,[create_date]
+      ,[is_in_standby]
+      ,[is_cleanly_shutdown]
+      ,[snapshot_isolation_state]
+      ,[snapshot_isolation_state_desc]
+      ,[is_read_committed_snapshot_on]
+      ,[is_published]
+      ,[is_subscribed]
+      ,[is_merge_published]
+  FROM [MyDatabase].[sys].[databases]
+  WHERE name='MyDatabase'
+}}}