[THIN] Re: Summary DB
- From: "Beckett, William \(Bill\)" <bill.beckett@xxxxxxxxxxxxx>
- To: <thin@xxxxxxxxxxxxx>
- Date: Fri, 15 Dec 2006 08:08:13 -0500
That's excellent. Good info, thanks a bunch Jeremy
-----Original Message-----
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of
Jeremy Saunders
Sent: Friday, December 15, 2006 2:52 AM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: Summary DB
Hi Bill,
It isn't supported, but works perfectly. From my notes...
The last step required is to change the compatibility level of the RM
Summary database to 80 or lower, otherwise you will receive the following
error and it will fail to create the summary database.
"Description [[Microsoft][ODBC SQL Server Driver][SQL Server]The query uses
non-ANSI outer join operators ("*=" or "=*"). To run this query without
modification, please set the compatibility level for current database to 80 or
lower, using stored procedure sp_dbcmptlevel. It is strongly recommended to
rewrite the query using ANSI outer join operators (LEFT OUTER JOIN, RIGHT
OUTER JOIN). In the future versions of SQL Server, non-ANSI join operators
will not be supported even in backward-compatibility modes.]."
Use the SQL command line utility called sqlcmd to run the sp_dbcmptlevel
stored procedure.
From a command line type the following:
sqlcmd
exec sp_dbcmptlevel 'CitrixRM', '80'
go
exit
Note that sqlcmd is the new version of the osql command line utility and
contains several new features and commands. However, you may still use the
osql utility, if you wish.
So either...
sqlcmd
or
osql -E
...connects you to the local, default instance of SQL 2005 Express Edition.
If you have varied your instance and config from what I have documented
above, you may need to vary the command line to suite.
For more information about the sqlcmd command, visit the following
Microsoft Web site:
http://msdn2.microsoft.com/en-us/library/ms180944.aspx
Citrix will be supporting this under PS4.5.
Cheers.
Kind regards,
Jeremy Saunders
Senior Technical Specialist
Infrastructure Technology Services
(ITS) & Cerulean
Global Technology Services (GTS)
IBM Australia
Level 1, 1060 Hay Street
West Perth WA 6005
Postal: PO Box 525, West Perth WA
6872
Visit us at
http://www.ibm.com/services/au/its
P: +61 8 9261 8412 F: +61 8 9261 8486
P: (Reception) +61 8 9261 8420 E-mail:
M: TBA jeremy.saunders@xxxxxxxxxxx
"Beckett, William
\(Bill\)"
<bill.beckett@ste To
elcase.com> <thin@xxxxxxxxxxxxx>
Sent by: cc
thin-bounce@freel
ists.org Subject
[THIN] Summary DB
14/12/2006 11:06
PM
Please respond to
thin@xxxxxxxxxxxx
g
Is anyone using SQL express to house their summary database? PS 4.0 on Windows
2003
Any issues/problems?
H!8,rrzJmnU~
SBC SITES ONLY GOOGLE SEARCH: http://www.F1U.com
************************************************
For Archives, RSS, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
//www.freelists.org/list/thin
************************************************
Other related posts:
