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 TouchToneTommy 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: *

  1. flstffatboy

    SQL Server 2000 Enterprise to 2005 Standard upgrade

    I was wondering what potential issues we may face with upgrading our current SQL Server environment. We were hoping to do an in place upgrade. I'm concerned since our version and licensing will change. Currently we have SQL Server 2000 Enterprise edition with CAL based licensing on an active...
  2. flstffatboy

    Error converting datetime in SQL Server job

    Hello, I'm getting the following error when running this code within a SQL Server 2000 job. There code runs fine within query analyzer. Could anyone shed any light on this? Error - "Syntax error converting datetime from character string. [SQLSTATE 22007] (Error 241). The step failed." Code...
  3. flstffatboy

    Cannot shrink log file due to orphaned replicated transactions

    Hello all, I have a SQL Server 2000 test database which is a backup and restored copy from our production database. The production database has transactional replication running on it but the test database does not. I'm having issues with trying to shrink the transaction log for the test...
  4. flstffatboy

    Replicated tables and development

    I'm looking for a little advice on SQL Server 2000 replication best practices and how to deal with table design changes in regards to replication. Background: Currently using transaction replication. Initially, tables were identifed for transactional replication. The initial publication...
  5. flstffatboy

    Email Trigger on Table

    Is it possible to create an email trigger on a insert/update/delete action on a tablein SQL Server 2000? I have a requirement for SARBOX to reveiew certain table data and be notified via email if data is changed. Any help would be appreciated, FLSTFFATBOY
  6. flstffatboy

    Query to validate if selected data is numeric

    I'm trying to determine if there is a way to select data from a field and see if it is numeric. Is there any easy way to do this through script logic in SQL Plus? Thank you, FLSTF
  7. flstffatboy

    Drawbacks to changing default application passwords

    What are the risks to changing the default schema owners passwords in Oracle Applications. We are currently using 10.7 SC I've taken over the administration and the past DBA said that Oracle does not support changing the passwords for the likes of APPS, GL, AR etc.. but I cannot find any...
  8. flstffatboy

    truncating tempdb?

    I'm new to SQL Server 2000 administration and had a problem yesterday where our tempdb grew to 25G which severely affected performance. Normally the tempdb isn't much larger than 1G. The actual user database is only 700M and SQL Server is shutdown on a nightly basis. I know the tempdb is used...
  9. flstffatboy

    Quorum disk placement

    We are currently trying to configure a new hardware solution for running SQL Server 2000 in a clustered environment with a SAN. I have been unable to get a good answer regarding the location of the Quorum disk. Can the Quorum disk be on the same physical disk (spindle) as the transaction logs...
  10. flstffatboy

    Location of Quorum disk

    We are currently trying to configure a new hardware solution for running SQL Server 2000 in a clustered environment with a SAN. I have been unable to get a good answer regarding the location of the Quorum disk. Can the Quorum disk be on the same physical disk (spindle) as the transaction logs...

Part and Inventory Search

Back
Top