All,
We are about to deploy a AR System 7.5 + ITSM 7.6 on SQL Server 2005. What is
the recommended way to handle un-fragmenting of the ARSystem Db indexes?
More Specifically:
1. Does un-fragmenting the indexes give us any performance boost or does it
cause more problems when trying to fix?
2
Anyone know where I could download a trial version of SQL Server 2005?
Microsoft has a page for it but when I try it says 2005 is no longer
available, get 2008 instead. Thanks a bunch.
Drew
Soto Cano
___
UNSUBSCRIBE
Drew
Do you mean Express?, if so I have the install, contact me off list.
Matt
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Drew Shuller
Sent: 16 December 2009 3:01 PM
To: arslist@ARSLIST.ORG
Subject: SQL Server 2005
Hello All,
ITSM 7.0.01
SQL Server 2005
We are getting the strangest error in the sql logs, trying to reference the
table spt_server_info.
I have spoken with our DBA and he said this table only existed in SQL Server
2000 and not in 2005.
Has anyone seen anything like this? I don't know how
Jase,
What was the exact error?
Joe
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Jase Brandon
Sent: Tuesday, March 11, 2008 11:48 AM
To: arslist@ARSLIST.ORG
Subject: SQL Server 2005 Dbase Error
**
Hello All
System discussion list(ARSList) [mailto:
[EMAIL PROTECTED] Behalf Of *Jase Brandon
*Sent:* Tuesday, March 11, 2008 11:48 AM
*To:* arslist@ARSLIST.ORG
*Subject:* SQL Server 2005 Dbase Error
** Hello All,
ITSM 7.0.01
SQL Server 2005
We are getting the strangest error in the sql logs, trying
The object doesn't exist or the ARSystem dbo (ARAdmin) doesn't have access to
the object.
From: Jase Brandon
Sent: Tuesday, March 11, 2008 10:54 AM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: SQL Server 2005 Dbase Error
**
Hi Joe,
My Apologies
PROTECTED] Behalf Of Bill H.
Sent: Tuesday, March 11, 2008 2:32 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Server 2005 Dbase Error
**
The object doesn't exist or the ARSystem dbo (ARAdmin) doesn't have
access to the object.
From: Jase Brandon
Sent: Tuesday, March 11, 2008 10:54
Brandon
Sent: Tuesday, March 11, 2008 1:55 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Server 2005 Dbase Error
**
Hi Joe,
My Apologies for not being precise.
The exact error is shown below. In my humble opinion, it appears that the
server is trying to referenece a dbase object
] Behalf Of *Jase Brandon
*Sent:* Tuesday, March 11, 2008 1:55 PM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: SQL Server 2005 Dbase Error
** Hi Joe,
My Apologies for not being precise.
The exact error is shown below. In my humble opinion, it appears that the
server is trying to referenece
Hello Listers,
Has anyone on the list had issues with running BMC Remedy AR System 7.1
on SQL Server 2005?
Christopher Pruitt
Consultant Specialist
EDS - Bank of America
I3-Inventory IW Infrastructure Team
mailto:HYPERLINK
mailto:[EMAIL PROTECTED][EMAIL PROTECTED]
mailto:HYPERLINK
Hello Listers,
Has anyone on the list had issues with running BMC Remedy AR System 7.1
on SQL Server 2005?
Christopher Pruitt
Consultant Specialist
EDS - Bank of America
I3-Inventory IW Infrastructure Team
mailto:HYPERLINK
mailto:[EMAIL PROTECTED][EMAIL PROTECTED
We have been ruuning it in a Dev. environment for about a month with
no major problems noticed.
Quoting Pruitt, Christopher J [EMAIL PROTECTED]:
Hello Listers,
Has anyone on the list had issues with running BMC Remedy AR System 7.1
on SQL Server 2005?
Christopher Pruitt
Consultant
None. I just installed a new 7.1.00.001 system against SQL Server 2005
Sp2 on a separate server - both servers are on Win2K3 Enterprise x64.
The secret I have found to the installation is to be logged in to the
AR server with the Windows domain account that you want the service to
run under
We ran 7.0 on MS SQL Server 2005 from February 2007 to October and have
been running 7.1 on SQL 2005 since then. We haven't experienced any
problems.
Bruce Hendershot
Air Products and Chemicals, Inc.
From: Action Request System discussion list(ARSList)
[mailto
To: arslist@ARSLIST.ORG
Subject: Re: Problem with MS SQL Server 2005
Looks like something crashed your server when it made the query. Check
your arerror.log and arthread.log and see if you find more details on
that.
Chad Hall
(501) 342-2650
__20060125___This posting
] On Behalf Of Beketov Danila
Sent: Friday, November 09, 2007 1:28 AM
To: arslist@ARSLIST.ORG
Subject: Re: Problem with MS SQL Server 2005
I try to attach log files with this mail.
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED
SQL Server 2005
**
I have a serious problem with MS SQL Server 2005.
I create some join forms and I get data from last join on MS SQL Server
2000.
When I try create the same join forms and retrieve data from its I
contemplate this massage Performing Search.
It last until I press
Of Joe D'Souza
Sent: Thursday, November 08, 2007 7:37 PM
To: arslist@ARSLIST.ORG
Subject: [SPAM] Re: [SPAM] Re: Problem with MS SQL Server 2005
What's your join criteria? Try removing that criteria, SAVE the join,
then put the criteria back again and SAVE it again.. Maybe for some
reason your join
perform a search?
Joe D'Souza
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Beketov Danila
Sent: Thursday, November 08, 2007 11:28 AM
To: arslist@ARSLIST.ORG
Subject: Re: [SPAM] Re: Problem with MS SQL Server 2005
: Problem with MS SQL Server 2005
Let me guess.. large tables in the join, unindexed join criteria?
Resulting in a table scan - it will eventually show the results if you
do not press Stop, but your solution is check the join criteria and make
sure that the fields in that criteria are indexed from
To: arslist@ARSLIST.ORG
Subject: Re: [SPAM] Re: [SPAM] Re: Problem with MS SQL Server 2005
**
There’s two regular form. For example: rf1 and rf2, add into rf1 form four
character fields with name ch1, ch2, ch4 and ch5; into rf2 form - ch1, ch2,
ch3. Create join form jf1: join two forms rf1
Sent: Friday, November 09, 2007 12:42 AM
To: arslist@ARSLIST.ORG
Subject: [SPAM] Re: Problem with MS SQL Server 2005
Have you seen what is the query it runs against the database? Run an SQL
log and see what you get..
Joe D'Souza
-Original Message-
From: Action
a peep.
Cheers
Joe D'Souza
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Beketov Danila
Sent: Friday, November 09, 2007 1:21 AM
To: arslist@ARSLIST.ORG
Subject: Re: [SPAM] Re: Problem with MS SQL Server 2005
List,
I am attempting to create a stored procedure written in .Net that uses
the ARS .Net API. Everything works as expected except when adding the
ARS API part.
I am not sure if this is even possible because it seems that you can
only have one .dll file inside a SQL Assembly, and the
25 matches
Mail list logo
