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!

  • Congratulations wOOdy-Soft 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
  • Content: Threads
  • Order by date
  1. 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?
  2. 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...
  3. 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...
  4. 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...
  5. 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?
  6. 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.
  7. 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...
  8. 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.
  9. 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...
  10. lory

    Batch file for installing printers

    Does anyone know how to create a batch file for installing a printer on a Windows 2000 server?
  11. 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...
  12. lory

    Database in loading status

    I started to restore a database, something I've done hundreds of times, but in the middle of the restore I received an error that stated "ConnectionRead (recv()). General network error. Check your network documentation." The file I was restoring from was copied from a different...
  13. lory

    Implications to changing sa password

    Need to change the password for sa. What are all the things I need to think about when doing so on MS SQL 7.0?
  14. lory

    Upgrade from 7.0 to 2000

    Does anyone know the exact steps that are best to take when upgrading from SQL 7.0 to 2000? Do I do an install of 2000, then restore a 7.0 bak file to upgrade? How to upgrade, is there a wizard? What gotchas are there with upgrading? Thanks for the info in advance.
  15. lory

    Releasing memory

    Why doesn't SQL Server 7.0 release memory? I have 2 GB of memory and task manager says that Memory Usage is 1963228KB. There is hardly any activity on my application server, which means hardly anyone is on the server doing anything. Noone is doing anything directly to the database. How do I...
  16. lory

    Security using directory audit

    I think we have an in-house hacker in our company. I have a Windows 2000 server that I have gone to Local Security Policy > Local Policies > Audit Policy and turned on Success, Failure to "Audit directory service access, Audit object access, audit system events". I went to a...
  17. lory

    SQL Profiler running and I didn't start it!

    I never started SQL Server Profiler and I see entries for it in the Application Log on my server. SQLServerProfiler is listed as the source and "Trace Started, Trace Stopped, Filter Changed, etc." is listed as the Category. Noone in my group has started it either. What is happening...
  18. lory

    Oracle8i password please???

    I installed oracle8i personal edition for win98 and everytime I start the database it ask for a startup password, just password its not asking for userid or login name. I already tried tiger, manager, change_on_install without success. Does anybody know the password, please help.
  19. lory

    password please???

    I installed oracle8i personal edition for win98 and everytime I start the database it ask for a startup password, just password its not asking for userid or login name. I already tried tiger, manager, change_on_install without success. Does anybody know the password, please help.

Part and Inventory Search

Back
Top