ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/AnywhereTS-MSSQL/trunk/TSAdminTool/CreateTables.sql
(Generate patch)

Comparing trunk/TSAdminTool/CreateTables.sql (file contents):
Revision 127 by william, Sat Jul 14 11:14:09 2012 UTC vs.
Revision 128 by william, Sat Jul 14 13:01:52 2012 UTC

--- trunk/TSAdminTool/CreateTables.sql	2012/07/14 11:46:04	127
+++ trunk/TSAdminTool/CreateTables.sql	2012/07/14 13:01:52	128
@@ -1,8 +1,11 @@
 ´╗┐USE [master]
 GO
-IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) BEGIN
-EXEC [AnywhereTS].[dbo].[sp_fulltext_database] 'enable';
-END
+--EXEC dbo.sp_dbcmptlevel @dbname=N'AnywhereTS', @new_cmptlevel=90
+--GO
+IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
+begin
+EXEC [AnywhereTS].[dbo].[sp_fulltext_database] @action = 'enable'
+end
 GO
 ALTER DATABASE [AnywhereTS] SET ANSI_NULL_DEFAULT OFF 
 GO