Un-Fragmenting SQL Indexes for ITSM 7.5 + SQL Server 2005

2010-07-27 Thread Bilinski, John CTR WHS/ITMD/ASD
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

Re: SQL Server 2005

2009-12-16 Thread Matt Worsdell
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

SQL Server 2005

2009-12-16 Thread Drew Shuller
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 or

Re: SQL Server 2005 Dbase Error = SOLVED

2008-03-11 Thread Jase Brandon
t; *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] 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. >

Re: SQL Server 2005 Dbase Error

2008-03-11 Thread Joe D'Souza
f 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 a dbase ob

Re: SQL Server 2005 Dbase Error

2008-03-11 Thread Joe D'Souza
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,

Re: SQL Server 2005 Dbase Error

2008-03-11 Thread Bill H.
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 Apologi

Re: SQL Server 2005 Dbase Error

2008-03-11 Thread Jase Brandon
[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,

Re: SQL Server 2005 Dbase Error

2008-03-11 Thread Joe D'Souza
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

SQL Server 2005 Dbase Error

2008-03-11 Thread Jase Brandon
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

Re: Any Issues with BMC Remedy AR System 7.1 and SQL Server 2005

2007-12-03 Thread Hendershot,Bruce D.
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) [m

Re: Any found Issues with BMC Remedy AR System 7.1 and SQL Server 2005

2007-12-03 Thread strauss
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

Re: Any found Issues with BMC Remedy AR System 7.1 and SQL Server 2005

2007-12-03 Thread Abdul Baytops
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 P

Any found Issues with BMC Remedy AR System 7.1 and SQL Server 2005

2007-12-03 Thread Pruitt, Christopher J
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

Any Issues with BMC Remedy AR System 7.1 and SQL Server 2005

2007-12-03 Thread Pruitt, Christopher J
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] <mai

FW: Problem with MS SQL Server 2005

2007-11-13 Thread Beketov Danila
PM 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 postin

Re: Problem with MS SQL Server 2005

2007-11-09 Thread Hall Chad - chahal
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] On

Re: [SPAM] Re: Problem with MS SQL Server 2005

2007-11-08 Thread Joe D'Souza
ave 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 S

Re: [SPAM] Re: Problem with MS SQL Server 2005

2007-11-08 Thread Beketov Danila
#x27;Souza 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-

Re: Problem with MS SQL Server 2005

2007-11-08 Thread Joe D'Souza
26 PM 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 f

Re: [SPAM] Re: [SPAM] Re: Problem with MS SQL Server 2005

2007-11-08 Thread Beketov Danila
st(ARSList) [mailto:[EMAIL PROTECTED] On Behalf 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 ag

Re: [SPAM] Re: Problem with MS SQL Server 2005

2007-11-08 Thread Joe D'Souza
n you 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 S

Re: [SPAM] Re: Problem with MS SQL Server 2005

2007-11-08 Thread Beketov Danila
M] Re: 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 fro

Re: Problem with MS SQL Server 2005

2007-11-08 Thread Joe D'Souza
th MS 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 las

SQL Server 2005 CLR and ARS API

2007-03-08 Thread Heider, Stephen
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 BMC.ARSys