Search results for query: *

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...

Microsoft Windows 2000 Microsoft SQL Server 2000 Enterprise Recovery Method = Full Production database file = 36,140MB current size, 26,535MB space used Production log file = 1,322MB current size, 43MB space used Autoshrink = NO Backup schedule Monday-Saturday: Log backups every 4 hours/daily...

Does anyone know how to create a batch file for installing a printer on a Windows 2000 server?

I have a small table with 34 rows and 4 columns that I need copied from one server to another. Everytime I perform the copy with data, everything comes over fine except for the 3rd column which brings back 'NULL' in every row?! I don't understand because the content came over for every other...

Nevermind this thread. After trying to delete the database it said that I couldn't, but when I got back from lunch it was gone. I think the Loading process took a very long time and it finally deleted.

I also checked the errorlog and I found "BackupFileDesc: VeryifyCreatability: Operating system error 32(The process cannot access the file because it is being used with another process.)during the creation/opening of physical device D:\HRSYS80A.MDF."