Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: lory
  • Order by date
  1. lory

    White spaces in select

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

    White spaces in select

    CHAR
  3. lory

    White spaces in select

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

    White spaces in select

    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?
  5. lory

    ANSI_NULLS error when reindexing

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

    ANSI_NULLS error when reindexing

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

    MS DTC name resolution problem

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

    PeopleTools version - which one is good?

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

    PeopleTools version - which one is good?

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

    Can you change the port number of a SQL Server instance?

    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?
  11. lory

    PS 8.x Tuxedo client connection count

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

    Driver does not support this function (0)

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

    Driver does not support this function (0)

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

    Database in suspect mode

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

    Log shrink clarification

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

    Log shrink clarification

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

    Batch file for installing printers

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

    DTS object copy returned nulls in one column

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

    Database in loading status

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

    Database in loading status

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

Part and Inventory Search

Back
Top