Forum: MS SQL

Hi guys, I have set up a linked server in SQL and have a script getting data from Active Directory. i want to limit the scope of the search,...

We moved our database onto SQL2K a week ago and I've seen a few errors here and there in the log file as follows: Error returned by lfread on page...

Hi All, We are using HPSM 7.11 with Windows 2003. And DB as SQL 2005. Everything was working fine till the time we added some fields in...

Hi guys, something that might be useful for SQL users; i want to move data from one table in production out to our reporting server....

there are no (or very few) keys in the SQL tables... Just a general concern i've been having... i realise that SC has keys set up in the application...

Hi 2 all recently, my db of Service Manager shows an error about the statement; it says: - SQL State:07009-0 Message:Invalid Descriptor Index ...

Hi! I got a question... hoy i can limit my SM DB Transaction log, because it´s already on 13 GB and still growth, i need to limit the size of...

I add a new field in dept file, and it is added successfully in sql DB. I want to change the field type from "varchar"(default) to "nvarchar",...

Hello, We plan to convert from SC 6.1.3 P4 to Sql Server 2005. I’ve read the DB Conversion & RDBMS Support guide as well as the forum threads on...

Hi can you please help me to now what meen this error Type de l'événement : Avertissement Source de l'événement : BusinessObjects_CMS Catégorie...

Hi Am trying to connect to service center by installing SC ODBC Dervier version 2.0.0.8. Service Center Version 5.1.5.0.0006 (Service Center...

I am having an issue with converting from P4 to SQL (development database). During the conversion of page/historical files (cm3tpage, cm3rpage,...

Hello, We got problems during the load from a P4 UNL to the production database, running under MsSQL 2005. The table cm3r has been modified (we...

How good is the out of the box mapping for this? Are there good reasons for changing the mapping or is it satisfactory to go with the oob mappings...

Out company are thinking of moving our P4 database to a MS SQL database,.... Currently we run LFScans etc on our P4 database, and we look after...

Hello, how can i connect ServiceCenter <-> MySQL? Where cann i find some help about mapping between fields in SC and an external database? ...

Hey, Currently looking at the ServiceCenter Database we use for Peregrine, through SQL Enterprise Manager. This is so we can use some scripting to...

Hi there, we're recently configured the one of the SC(ver4) P4 tables to shadow to a MSSQL2k Server. While the initial shadow was...

Hi there, what is the syntax for the database of the sqldb:<DBNAME> parameter? I have configured an odbc connection to a mssql2k server(which is...

I know I posted this in a different topic area, but just thought I'd put it in this area too. For those people who may run their system or shadow...

After a couple of months of testing using Peregrine with SQL, we went ahead and moved our production system onto SQL. Everything went ok, EXCEPT: ...

I've noticed this error when we export to SQL, but I am curious if it is present in other RDBMSs. When we export our data to SQL, all the times on...

I've been having a little bind the past couple of days. In the SQL utilities menu, select Modify Existing SQL Mapping, I am working on the problem...