Recent content by lory

Thank you ESquared, I will do as you suggested. :)

CHAR

We are selecting data from SQL, then using the results to perform sqr processing. The sqr program cannot deal with all the extra spaces at the end of the data and therefore we are not able to run the program effectively. I realize why the spaces are there, but would really like to find a way...

Is there some way to make SQL Server not append white spaces to fields when the data is returned from a select, but still return any white spaces placed in the field by a user?

Here's the script: SET ANSI_NULLS ON GO spU_reindex_tables_new SET ANSI_NULLS OFF GO And here is the stored procedure: DECLARE x SCROLL CURSOR FOR SELECT DISTINCT o.name FROM sysobjects o, sysindexes i where o.type = 'U' and i.id=o.id and i.id>98 and i.name not like '_hind%' and...

I have a reindex script that is failing with the error "Msg 1934, Sev 16: DBCC failed because the following SET options have incorrect settings: 'ANSI_NULLS.'. [SQLSTATE 42000]" I ran SET ANSI_NULLS ON, then ran the reindex script and it failed again with the same error? It doesn't...

I have 2 Windows 2K servers with MS SQL 2000, clustered. Linked server was set up on a stand-alone sql server linking to Node A using the cluster name. Installed MS DTC and added it as a resource in the Cluster Admin on Node A (Node B was down at this point.) When I booted Node B, I received...

Well, for starters we have intermittent problems with Crystal processes. One will hang in Initiated or Processing status and subsequent ones will error out. This is supposedly fixed in 8.42.09 + POC or later releases. The process scheduler appears to have a memory leak since object processes...

I would love to get responses from anyone who is on PeopleTools 8.42.08 (exactly this release) or later and whether or not you feel this release is stable. I'm specifically interested if you are running Microsoft Windows 2000 for any component, i.e. database, application, process scheduler...

I have a W2K Server with SQL Server 2000 SP2 installed. The port number is 1433 (default), but we need to change it. Is it possible to change this port number or do I have to reinstall?

Anyone know of any software or has anyone written anything that will give you a client connectivity count on the application servers? I would really like to see how many concurrent users we have compared to our slow performance times. Thanks in advance.

Crystal Enterprise version 8. ODBC is set up correctly on the server to connect to the MS SQL 2000 database.

I am running a crystal report with a cross tab graph. It runs fine on my desktop, but errors on the server with this error "Crystal Reports Print Engine error text: Error detected by database DLL." After running an ODBC trace on the server I see this error "CRW_ELWCC060_17...

Help!! My database ran out of disk space when reindexing in the middle of the night and is now in suspect mode. Once I found out, I deleted some files to release space, but it's been over an hour and it is still in suspect mode. What do I do? Both mdf and ldf were on the same drive.

Well, I tried added this step after the database backup DBCC SHRINKFILE (dbfilename, 10) and nothing happened. At least the file did not get smaller. I assumed that would happen since you have to actually truncate to force the transaction log to reduce. At any rate, are there real performance...