Changes between Version 2 and Version 3 of MS SQL issues

Timestamp:

11/01/11 12:07:47 (12 years ago)

Author:

Nick Holden

Comment:

--

MS SQL issues

@@ -1 +1 @@
 Putting some notes in here that relate to SQL Server specific isssues.
 
-On linux boxes, accessing MS SQL is easiest using 'sqsh' a command-line Transact-SQL client.
+On linux boxes, accessing MS SQL is easiest using 'sqsh' a command-line Transact-SQL client:
+''sqsh -S UHLSQLBRICCSDB\\UHLBRICCSDB -U username -P password''
 
-
-On the primary MS SQL server provided by the UHL, we have configured the following:
+On the primary MS SQL server provided by the UHL (UHLSQLBRICCSDB\UHLBRICCSDB), we have configured the following for use by the i2b2 instance on uhlbriccsapp02:
 
 {{{
@@ -20 +20 @@
 }}}
 
-Links
+And the following for use by the uhlbriccsapp03 i2b2:
+
+{{{
+
+create database i2b2_app03_metadata
+create database i2b2_app03_demodata
+create database i2b2_app03_workdata
+create database i2b2_app03_metadata2
+create database i2b2_app03_demodata2
+create database i2b2_app03_workdata2
+create database i2b2_app03_b1_metadata
+create database i2b2_app03_b1_data
+create database i2b2_app03_b1_workdata
+create database i2b2_app03_hive
+create database i2b2_app03_pm
+}}}
+
+
+=== Links===
 
 This is useful on rebuilding indexes: http://www.sqldbpros.com/2010/11/sql-server-rebuild-indexes-the-fastest-way/